取BOM变更单,本月最大单号
select MAX(ECNNo)+1 from pimPDMBOMECNMaster where left(ECNNo,6)=DateName(year,GetDate())+DateName(month,GetDate())
流水号设计:
string strSQL = string.Format("SELECT right(max(ECRNo),4) as ECR FROM pimECMECRSheet where CONVERT(varchar(100), Create_On, 112)=CONVERT(varchar(100), GETDATE(), 112)");
string s = dbUtil.GetSelectedItemData(strSQL);
int i;
if (s == "" || s == null)
{
s = "0001";
}
else
{
i = Int32.Parse(s);
i++;
s = i.ToString().PadLeft(4, '0');
}
string strECNno = "ECR" + DateTime.Now.ToString("yyMMdd")+"."+s;
select MAX(ECNNo)+1 from pimPDMBOMECNMaster where left(ECNNo,6)=DateName(year,GetDate())+DateName(month,GetDate())
流水号设计:
string strSQL = string.Format("SELECT right(max(ECRNo),4) as ECR FROM pimECMECRSheet where CONVERT(varchar(100), Create_On, 112)=CONVERT(varchar(100), GETDATE(), 112)");
string s = dbUtil.GetSelectedItemData(strSQL);
int i;
if (s == "" || s == null)
{
s = "0001";
}
else
{
i = Int32.Parse(s);
i++;
s = i.ToString().PadLeft(4, '0');
}
string strECNno = "ECR" + DateTime.Now.ToString("yyMMdd")+"."+s;