| | |
| | | using (var db = SqlSugarConnection.SugarClient("TransferExamine")) |
| | | { |
| | | string sql = String.Format("update PenGouList set Div1 = {0},Div2 = {1},Div3 = {2},Div4 = {3},Total8 = {4},Result8 = '{5}',Comment8 = '{6}',Process_Comment = '{7}',Delay_Month8 = '{8}' where ProcessInstance_UID = '{9}'", num1, num2, num3, num4, numAll, result, remake, value, month, uid); |
| | | return db.Ado.ExecuteCommand(sql); |
| | | int rows= db.Ado.ExecuteCommand(sql); |
| | | |
| | | string sql1 = string.Format(@"update PreFlowlites_PositionChange set |
| | | Process_Comment= (select Process_Comment from PenGouList where ProcessInstance_UID='{0}') |
| | | , Result8 = (select Result8 from PenGouList where ProcessInstance_UID = '{0}'), |
| | | Assess_Status = (select Assess_Status from PenGouList where ProcessInstance_UID = '{0}') |
| | | where |
| | | SN in (select SN from PenGouList where ProcessInstance_UID = '{0}')",uid); |
| | | return db.Ado.ExecuteCommand(sql1); |
| | | } |
| | | } |
| | | |