public int DeleteBusiness_Main(H_Bus_MainEntity hce) { int intResult = 0; string strSql = "Delete from H_Business_Main where CCID=@c1"; OleDbParameter[] prams = { new OleDbParameter("@c1", hce.CCID) }; intResult = AccessHelper.ExecuteNonQuery(strCon(), strSql, prams); return intResult; }
bool InsertBusinessMain() { try { H_Bus_MainEntity HBD = new H_Bus_MainEntity(); HBD.CCID = CompanyID; HBD.ZTS = TxtToDec(txtzts.Text.Trim()); HBD.TotalSquare = TxtToDec(txtzpfs.Text.Trim()); HBD.Price = TxtToDec(txtdj.Text.Trim()); HBD.TotalPrice = TxtToDec(txtzje.Text.Trim()); db.DeleteBusiness_Main(HBD); if (!db.InsertBusiness_Main(HBD)) return false; else return true; } catch (Exception ex) { log.wrirteLog("主页面", "增加明细主表", ex.Message); return false; } }
/// <summary> /// 明细主表 /// </summary> /// <param name="ue"></param> /// <returns></returns> public bool InsertBusiness_Main(H_Bus_MainEntity hcm) { bool result = true; try { string SqlStr = " " + " Insert into H_Business_Main (CCID, ZTS, TotalSquare, Price, TotalPrice, DoTime) " + " values(@c1,@c2,@c3,@c4,@c5,@c6) "; OleDbParameter[] prams = { new OleDbParameter("@c1", hcm.CCID), new OleDbParameter("@c2", hcm.ZTS), new OleDbParameter("@c3", hcm.TotalSquare), new OleDbParameter("@c4", hcm.Price), new OleDbParameter("@c5", hcm.TotalPrice), new OleDbParameter("@c6", DateTime.Now.ToString()) }; int intresult = AccessHelper.ExecuteNonQuery(strCon(), SqlStr, prams); if (intresult == 0) result = false; else result = true; } catch (Exception ex) { log.wrirteLog("数据库操作", "明细主表H_Business_Main", ex.Message); result = false; } return result; }