| | |
| | | sql += "and " + key + " = " + model.GetType().GetProperty(key).GetValue(model); |
| | | } |
| | | |
| | | LogService.Write(sql); |
| | | //LogService.Write(sql); |
| | | return sql; |
| | | }catch(Exception e) |
| | | { |
| | |
| | | sWhere = sWhere.Replace("'", "''"); |
| | | } |
| | | |
| | | LogService.Write("exec h_p_PM_ProjectBill_StepsList '" + stage + "','" + sWhere + "'"); |
| | | //LogService.Write("exec h_p_PM_ProjectBill_StepsList '" + stage + "','" + sWhere + "'"); |
| | | ds = oCN.RunProcReturn("exec h_p_PM_ProjectBill_StepsList '" + stage + "','" + sWhere + "'", "h_p_PM_ProjectBill_StepsList"); |
| | | |
| | | //æ·»å åå |
| | |
| | | try |
| | | { |
| | | var _value = msg["oMainStr"].ToString(); |
| | | LogService.Write(_value); |
| | | //LogService.Write(_value); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0]; // 表åä¸»ä½ |
| | | string msg3 = sArray[1]; // æå¨é¶æ®µ |
| | | string msg4 = sArray[2]; // æä½ç¨æ· |
| | | LogService.Write(msg2); |
| | | LogService.Write(msg3); |
| | | LogService.Write(msg4); |
| | | //LogService.Write(msg2); |
| | | //LogService.Write(msg3); |
| | | //LogService.Write(msg4); |
| | | msg2 = "[" + msg2 + "]"; |
| | | List<ClsPM_ProjectBill_Work> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsPM_ProjectBill_Work>>(msg2); |
| | | LogService.Write(list); |
| | | //LogService.Write(list); |
| | | if (string.Equals(msg3, "jiaodi", StringComparison.InvariantCultureIgnoreCase)) |
| | | { |
| | | list[0].HJiaodiSaveFlag = 1; |
| | |
| | | sWhere = sWhere.Replace("'", "''"); |
| | | } |
| | | |
| | | LogService.Write("exec h_p_PM_ProjectBill_FeeList '" + stage + "','" + sWhere + "'"); |
| | | //LogService.Write("exec h_p_PM_ProjectBill_FeeList '" + stage + "','" + sWhere + "'"); |
| | | ds = oCN.RunProcReturn("exec h_p_PM_ProjectBill_FeeList '" + stage + "','" + sWhere + "'", "h_p_PM_ProjectBill_FeeList"); |
| | | |
| | | //æ·»å åå |
| | |
| | | try |
| | | { |
| | | var _value = msg["oMainStr"].ToString(); |
| | | LogService.Write(_value); |
| | | //LogService.Write(_value); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0]; // 表åä¸»ä½ |
| | |
| | | string msg4 = sArray[2]; // æä½ç¨æ· |
| | | msg2 = "[" + msg2 + "]"; |
| | | List<ClsPM_ProjectBill_WorkFee> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsPM_ProjectBill_WorkFee>>(msg2); |
| | | LogService.Write(list); |
| | | //LogService.Write(list); |
| | | if (string.Equals(msg3, "workFeeEntry", StringComparison.InvariantCultureIgnoreCase)) |
| | | { |
| | | list[0].HGongfeiluruSaveFlag = 1; |