| | |
| | | var total = 0; //总条数 |
| | | var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit,A.Type from TRight A |
| | | left join T_CodeRules B on A.right_code=B.rightcode |
| | | where A.parent_id<>'0' and A.is_delete<>'1' " + search + ""; |
| | | where A.parent_id<>'0' and A.is_delete<>'1' and A.is_rcode<>'N' " + search + ""; |
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
| | | mes.code = "200"; |
| | | mes.Message = "查询成功!"; |
| | |
| | | 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) |
| | | { |