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;
}
