| | |
| | | var dynamicParams = new DynamicParameters(); |
| | | try |
| | | { |
| | | sql = @"select rightcode from T_CodeRules where rightcode=@rightcode"; |
| | | sql = @"select rightcode,value from T_CodeRules where rightcode=@rightcode"; |
| | | dynamicParams.Add("@rightcode", rightcode); |
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
| | | if (data.Rows.Count > 0) |
| | | { |
| | | sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode"; |
| | | string value = data.Rows[0]["value"].ToString(); |
| | | if (decimal.Parse(incbit) > value.Length) |
| | | { |
| | | decimal cnum = decimal.Parse(incbit) - value.Length; |
| | | for (int i = 0; i < cnum; i++) |
| | | { |
| | | value = "0" + value; |
| | | } |
| | | } |
| | | sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,value=@value,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode"; |
| | | dynamicParams.Add("@prefix", prefix); |
| | | dynamicParams.Add("@filingdate", filingdate); |
| | | dynamicParams.Add("@incbit", incbit); |
| | | dynamicParams.Add("@value", value); |
| | | dynamicParams.Add("@lm_user", lm_user); |
| | | dynamicParams.Add("@CreateDate", DateTime.Now.ToString()); |
| | | dynamicParams.Add("@rightcode", rightcode); |
| | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[生成系统条码(自定义)] |
| | | public static ToMessage LabelBarCode(string rightcode, string partcode, string qty, string onelabqty) |
| | | { |
| | | mes = AppLableBarCode.EncodingSeach(rightcode, partcode, qty, onelabqty); |
| | | return mes; |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region[车间公告列表] |
| | | public static ToMessage SystemAnnouncementSearch(string wkspcode, string ancetitle, string ancecont, string cancel, string level, int startNum, int endNum, string prop, string order) |
| | | { |