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