| | |
|---|
| | | //获取最大单据号 |
|---|
| | | if (i == 1) //首单获取工单号 |
|---|
| | | { |
|---|
| | | sql = @"select isnull(max(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code))),0)+1 as worknumb from TK_Wrk_Man where m_po=@erpordercode"; |
|---|
| | | sql = @"select isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as worknumb |
|---|
| | | from TK_Wrk_Man where m_po=@erpordercode"; |
|---|
| | | dynamicParams.Add("@erpordercode", erpordercode); |
|---|
| | | var data = DapperHelper.selectdata(sql, dynamicParams); |
|---|
| | | num = Convert.ToInt32(data.Rows[0]["WORKNUMB"].ToString()); |
|---|
| | |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[MES工单新增、获取工单号] |
|---|
| | | public static ToMessage AddMesOrderCodeSearch() |
|---|
| | | { |
|---|
| | | string sql = ""; |
|---|
| | | string wo_code = ""; |
|---|
| | | var dynamicParams = new DynamicParameters(); |
|---|
| | | try |
|---|
| | | { |
|---|
| | | //获取单据号 |
|---|
| | | sql = @"SELECT 'SGPO'+CONVERT(varchar(12) , getdate(), 112 )+'_'+cast(isnull(max(cast(substring(wo_code,charindex('_',wo_code)+1,len(wo_code)-charindex('_',wo_code)) as numeric)),0)+1 as varchar) as numct |
|---|
| | | FROM TK_Wrk_Man where wo_code like '%SGPO%'"; |
|---|
| | | var data = DapperHelper.selecttable(sql); |
|---|
| | | mes.code = "200"; |
|---|
| | | mes.Message = "查询成功!"; |
|---|
| | | mes.data = data.Rows[0]["numct"].ToString(); |
|---|
| | | } |
|---|
| | | catch (Exception e) |
|---|
| | | { |
|---|
| | | mes.code = "300"; |
|---|
| | | mes.count = 0; |
|---|
| | | mes.Message = e.Message; |
|---|
| | | mes.data = null; |
|---|
| | | } |
|---|
| | | return mes; |
|---|
| | | } |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | #region[MES工单新增、编辑提交] |
|---|
| | | public static ToMessage AddUpdateMesOrder(string mesorderstus, string sourceorder, string ordertype, string mesordercode, string partcode, string mesqty, string routecode, string wkshopcode, string planstartdate, string planenddate, string orderlev, string username, string opertype, string is_aps, string bom_id) |
|---|
| | | { |
|---|
