订单编码+年月+流水号
private string GetDateNo()
{
string purchaseOrderNo;
string date = DateTime.Now.ToString("yyyy"+"MM");
string maxNo = App.BasicInofDbDataSet.GetMaxPurchaseOrderNo();//获取订单编号最大值(CGDD201906-002)
string maxDate = maxNo.Substring(4, 6);//得到订单编号最大值的“年月”部分(201906)
string maxDateNo = maxNo.Substring(11, 3);//得到订单编号最大值的序列部分,也就是“-”之后的三个数字(002)
if (date == maxDate)//如果本月有数据
{
int.TryParse(maxDateNo, out int dd);//将订单编号的序列部分转换为 int 类型,以便进行“+1”运算
int newDateNo = dd + 1;
purchaseOrderNo = "CGDD" + date + "-" + newDateNo.ToString("000");
}
else
{
purchaseOrderNo = "CGDD" + date + "-001";// “-”和 “001” 分开写会更清晰些
}
return purchaseOrderNo;
}
通过SQL 对 char 类型最大值的查询得到订单的最大NO号
// 采购单编号最大值查询
public string GetMaxPurchaseOrderNo()
{
SqlConnection sqlConnection = new SqlConnection(connDefString);
SqlCommand sqlCommand = new SqlCommand("SELECT MAX(Number) FROM PurchaseOrders", sqlConnection);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sqlCommand);
DataTable dtPurchaseOrderNo = new DataTable();
dataAdapter.Fill(dtPurchaseOrderNo);
// string str = DataTable.Rows[行][列].ToString();
string str = dtPurchaseOrderNo.Rows[0][0].ToString();
return str;
}