之前的写的自动编码单据流水码是写在存储过程或者函数中的&＃xff0c;今天用程序写一个发现TOSTRING可以格式化方便。
/// /// 年月日&＃43;两位流水码/// /// public static string AutoCode() {string yearmonthday &＃61;System.DateTime.Now.Year.ToString() &＃43; System.DateTime.Now.Month.ToString("00") &＃43; System.DateTime.Now.Day.ToString("00");string flowcode &＃61; string.Empty;//流水码StringBuilder sb &＃61; new StringBuilder();sb.Append(" select 报价单号 from [dbo].[UF_Quotation]");sb.Append(" where Left(报价单号,8)&＃61;&＃39;" &＃43; yearmonthday &＃43; "&＃39;");using (SqlDataReader dr &＃61; SqlHelper.ExecuteReader(SqlHelper.conn, CommandType.Text, sb.ToString())){if (dr.Read()){int tempcode&＃61;int.Parse(dr[0].ToString().Substring (8,2))&＃43;1;flowcode &＃61; tempcode.ToString("00"); ;}else{flowcode &＃61; "01";}}return yearmonthday &＃43; flowcode;}
京公网安备 11010802041100号