public int DeleteCompany(H_CompanyEntity hce) { int intResult = 0; string strSql = "Delete from H_Company where CID=@c1"; OleDbParameter[] prams = { new OleDbParameter("@c1", hce.CID) }; intResult = AccessHelper.ExecuteNonQuery(strCon(), strSql, prams); return intResult; }
public int DeleteCompany(H_CompanyEntity hce) { int intResult = 0; string strSql = "Delete from H_Company where CID=@c1"; OleDbParameter[] prams = { new OleDbParameter("@c1", hce.CID) }; intResult = AccessHelper.ExecuteNonQuery(strCon(), strSql, prams); return(intResult); }
/// <summary> /// 获取控件内容 /// </summary> bool Insert_Company() { if (CompanyID == "") { CompanyID = db.GetMaxID("Cpy", "H_Company"); } H_CompanyEntity hce = new H_CompanyEntity(); hce.CID = CompanyID; hce.CName = txtname.Text.Trim(); bool iscksf = false; try { if (cksf.SelectedItem.ToString() == "是") { iscksf = true; } else if (cksf.SelectedItem.ToString() == "否") { iscksf = false; } } catch { } hce.CIsGlass = iscksf; hce.CColor = txtcolor.Text.Trim(); hce.CAdress = cbadress.SelectedValue.ToString(); hce.CGlass = cbglass.SelectedValue.ToString(); hce.CRemarks = txtbz.Text.Trim(); hce.CTelphone = txtphone.Text.Trim(); db.DeleteCompany(hce); if (!db.InsertCompany(hce)) { MessageBox.Show("公司资料保存失败!!"); return(false); } else { return(true); } }
/// <summary> /// 公司 /// </summary> /// <param name="ue"></param> /// <returns></returns> public bool InsertCompany(H_CompanyEntity hce) { bool result = true; try { string SqlStr = " " + " Insert into H_Company (CID,CName,CTelphone,CColor,CGlass, CIsGlass, CRemarks,CAdress, DoTime) " + " values(@c1,@c2,@c3,@c4,@c5,@c6,@c7,@c8,@c9) "; OleDbParameter[] prams = { new OleDbParameter("@c1", hce.CID), new OleDbParameter("@c2", hce.CName), new OleDbParameter("@c3", hce.CTelphone), new OleDbParameter("@c4", hce.CColor), new OleDbParameter("@c5", hce.CGlass), new OleDbParameter("@c6", hce.CIsGlass), new OleDbParameter("@c7", hce.CRemarks), new OleDbParameter("@c8", hce.CAdress), new OleDbParameter("@c9", DateTime.Now.ToString()) }; int intresult = AccessHelper.ExecuteNonQuery(strCon(), SqlStr, prams); if (intresult == 0) { result = false; } else { result = true; } } catch (Exception ex) { log.wrirteLog("数据库操作", "公司资料增加", ex.Message); result = false; } return(result); }
/// <summary> /// 获取控件内容 /// </summary> bool Insert_Company() { if(CompanyID=="") CompanyID = db.GetMaxID("Cpy", "H_Company"); H_CompanyEntity hce = new H_CompanyEntity(); hce.CID = CompanyID; hce.CName = txtname.Text.Trim(); bool iscksf = false; try { if (cksf.SelectedItem.ToString() == "是") iscksf = true; else if (cksf.SelectedItem.ToString() == "否") iscksf = false; } catch { } hce.CIsGlass = iscksf; hce.CColor = txtcolor.Text.Trim(); hce.CAdress = cbadress.SelectedValue.ToString(); hce.CGlass = cbglass.SelectedValue.ToString(); hce.CRemarks = txtbz.Text.Trim(); hce.CTelphone = txtphone.Text.Trim(); db.DeleteCompany(hce); if (!db.InsertCompany(hce)) { MessageBox.Show("公司资料保存失败!!"); return false; } else return true; }
/// <summary> /// 公司 /// </summary> /// <param name="ue"></param> /// <returns></returns> public bool InsertCompany(H_CompanyEntity hce) { bool result = true; try { string SqlStr = " " + " Insert into H_Company (CID,CName,CTelphone,CColor,CGlass, CIsGlass, CRemarks,CAdress, DoTime) " + " values(@c1,@c2,@c3,@c4,@c5,@c6,@c7,@c8,@c9) " ; OleDbParameter[] prams = { new OleDbParameter("@c1", hce.CID), new OleDbParameter("@c2", hce.CName), new OleDbParameter("@c3", hce.CTelphone), new OleDbParameter("@c4", hce.CColor), new OleDbParameter("@c5", hce.CGlass), new OleDbParameter("@c6", hce.CIsGlass), new OleDbParameter("@c7", hce.CRemarks), new OleDbParameter("@c8", hce.CAdress), new OleDbParameter("@c9", DateTime.Now.ToString()) }; int intresult = AccessHelper.ExecuteNonQuery(strCon(), SqlStr, prams); if (intresult == 0) result = false; else result = true; } catch (Exception ex) { log.wrirteLog("数据库操作", "公司资料增加", ex.Message); result = false; } return result; }