public static bool UpdatePayInfo(PayInfo payInfo, string YYCode, ref string err) { string sql = "select PayType from PayInfo where payId='" + payInfo.PayId + "'"; string pType = SQLBase.ExecuteScalar(sql).ToString(); string paySql = GSqlSentence.GetUpdateInfoByD <PayInfo>(payInfo, "PayId", "PayInfo"); if (SQLBase.ExecuteNonQuery(paySql) <= 0) { err = "缴费信息更新失败"; return(false); } sql = "update ConsumptionInfo set type=" + payInfo.PayType + " where PayId='" + payInfo.PayId + "'"; if (SQLBase.ExecuteNonQuery(sql) <= 0) { err = "消费信息更新失败"; return(false); } if (pType != payInfo.PayType && payInfo.PayType == "2") { sql = "select ClienName from ClientPayInfo where ClienName = '" + payInfo.PayCompany + "'"; DataTable dt = SQLBase.FillTable(sql); if (dt.Rows.Count > 0) { sql = "update ClientPayInfo set Money = Money+" + payInfo.PayMoney + " where ClienName = '" + payInfo.PayCompany + "'"; if (SQLBase.ExecuteNonQuery(sql) <= 0) { return(false); } } else { sql = "insert into ClientPayInfo(ClienName,Money) values('" + payInfo.PayCompany + "'," + payInfo.PayMoney + ")"; if (SQLBase.ExecuteNonQuery(sql) <= 0) { return(false); } } } return(true); }
public static bool UpdateMandate(MandateInfo mandate, List <SampleInfo> sampleList, ref string err) { string MandateSql = GSqlSentence.GetUpdateInfoByD(mandate, "YYCode", "MandateInfo"); if (mandate.MCode != "" && mandate.MCode != null) { string MCode = mandate.MCode; int number = 0; for (int i = 0; i < sampleList.Count; i++) { string sampleCode = ""; if (sampleList[i].Number > 1) { string strartStr = (number + 1).ToString(); string endStr = (number + sampleList[i].Number).ToString(); if (strartStr.Length < 2) { strartStr = "0" + strartStr; } if (endStr.Length < 2) { endStr = "0" + endStr; } sampleCode = MCode + "-" + strartStr + "-" + endStr; number = Convert.ToInt32(endStr); } else { if ((number + 1).ToString().Length > 2) { sampleCode = MCode + "-" + (number + 1); } else { string result = "00" + (number + 1); sampleCode = MCode + "-" + result.Substring(result.Length - 2, 2); } number += 1; } sampleList[i].SampleCode = sampleCode; } } string sampleSql = GSqlSentence.GetInsertByList <SampleInfo>(sampleList, "SampleInfo"); List <TestItem> testItemList = GetItemIDs(mandate.TestingItems, mandate.YYCode); string testItemSql = GSqlSentence.GetInsertByList <TestItem>(testItemList, "TestItem"); string sql = ""; if (SQLBase.ExecuteNonQuery(MandateSql) > 0) { sql = "delete SampleInfo where YYCode='" + mandate.YYCode + "'"; if (SQLBase.ExecuteNonQuery(sql) >= 0) { if (sampleList.Count > 0) { if (SQLBase.ExecuteNonQuery(sampleSql) <= 0) { err = "样品信息添加失败"; return(false); } } } sql = "delect TestItem where YYCode='" + mandate.YYCode + "'"; if (SQLBase.ExecuteNonQuery(sql) >= 0) { if (testItemList.Count > 0) { if (SQLBase.ExecuteNonQuery(testItemSql) <= 0) { err = "检测项目添加失败"; return(false); } } } string content = "修改委托单信息"; if (!insertLog(mandate.YYCode, content)) { err = "更新日志失败"; return(false); } return(true); } err = "委托信息更新失败"; return(false); }