public bool InsertInfo(SaleEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_sale(saleId,commodityName,saleDate,saleNumber,payMethod,workerName" +
",Gonghao) values(" + "'" + obj.SalesrecordsId + "'" + "," + "'" + obj.Productname + "'" + ","
+ "'" + obj.Saledate + "'" + "," + "'" + obj.Salenumber + "'" + "," + "'" + obj.Paymethod + "'" + "," + "'" + obj.Workername +
"'" + "," + "'" + obj.Jobnumber + "')");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool InsertInfo(PurchaseEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_purchase(purchaseId,commodityName,purchaseNumber,costPrice,total,purchaseDate" +
",handler,purchaseStatus) values(" + "'" + obj.PurchaseId + "'" + "," + "'" + obj.Productname + "'" + ","
+ "'" + obj.Purchasenumber + "'" + "," + "'" + obj.Costprice + "'" + "," + "'" + obj.Total + "'" + "," + "'" + obj.Purchasedate +
"'" + "," + "'" + obj.Experience + "'" + "," + "'" + obj.Purchasestate + "')");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool UpdateInfo(PurchaseEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_purchase set purchaseId='" + obj.PurchaseId + "'," +
"commodityName='" + obj.Productname + "',purchaseNumber='" + obj.Purchasenumber + "',costPrice='" + obj.Costprice + "',total=" +
"'" + obj.Total + "',purchaseDate='" + obj.Purchasedate + "'" +
",handler='" + obj.Experience + "',purchaseStatus='" + obj.Purchasestate + "' where purchaseId='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool InsertInfo(SupplierEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_supplier(supplierId,businessName,contacts,phone,address,settlementMethod)" +
" values(" + "'" + obj.SupplierId + "'" + "," + "'" + obj.Merchantname + "'" + ","
+ "'" + obj.Contacts + "'" + "," + "'" + obj.Phone + "'" + "," + "'" + obj.Address + "'" + "," + "'" + obj.Settlement + "')");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool UpdateInfo(SaleEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_sale set saleId='" + obj.SalesrecordsId + "'," +
"commodityName='" + obj.Productname + "',saleDate='" + obj.Saledate + "',saleNumber='" + obj.Salenumber + "',payMethod=" +
"'" + obj.Paymethod + "',workerName='" + obj.Workername + "'" +
",Gonghao='" + obj.Jobnumber + "' where saleId='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool InsertInfo(ProductInfoEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_commodityInfo(commodityId,commodityName,businessName,costPrice,unitPrice,commodityNumber" +
",remarks) values(" + "'" + obj.ProductId + "'" + "," + "'" + obj.Productname + "'" + ","
+ "'" + obj.Merchantname + "'" + "," + "'" + obj.Costprice + "'" + "," + "'" + obj.Unitprice + "'" + "," + "'" + obj.Merchantinventory +
"'" + "," + "'" + obj.Remarks + "')");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool UpdateInfo(SupplierEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_supplier set businessName='" + obj.Merchantname + "'," +
"contacts='" + obj.Contacts + "',phone='" + obj.Phone + "',address='" + obj.Address + "',settlementMethod=" +
"'" + obj.Settlement + "' where supplierId='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool UpdateInfo(ProductInfoEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_commodityInfo set commodityId='" + obj.ProductId + "'," +
"commodityName='" + obj.Productname + "',businessName='" + obj.Merchantname + "',costPrice='" + obj.Costprice + "',unitPrice=" +
"'" + obj.Unitprice + "',commodityNumber='" + obj.Merchantinventory + "'" +
",remarks='" + obj.Remarks + "' where purchaseId='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool InsertInfo(WorkerEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_zhigong(Gonghao,Password,Name,Shenfenzhenghao,Sex,Address" +
",Gongzuodanwei,Phone,Birth,Ruyongriqi) values(" + "'" + obj.Jobnumber + "'" + "," + "'" + obj.Password + "'" + ","
+ "'" + obj.Name + "'" + "," + "'" + obj.Idnumber + "'" + "," + "'" + obj.Sex + "'" + "," + "'" + obj.Address +
"'" + "," + "'" + obj.Workunit + "'" + "," + "'" + obj.Phone + "'" + "," + "'" + obj.Birth + "'" + "," + "'" + obj.Hiredate + "'" + ")");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool UpdateInfo(WorkerEntity obj, string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("update tb_zhigong set Password='******'," +
"Name='" + obj.Name + "',Shenfenzhenghao='" + obj.Idnumber + "',Sex='" + obj.Sex + "',Address=" +
"'" + obj.Address + "',Phone='" + obj.Phone + "'" +
",Birth='" + obj.Birth + "',Ruyongriqi='" + obj.Hiredate + "'where Gonghao='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool DeleteInfo(string jobnumber)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("delete from tb_purchase where purchaseId='" + jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
public bool SelectUniqueInfo(WorkerEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("select Gonghao from tb_zhigong where Gonghao='" + obj.Jobnumber + "'");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}
//注册
public bool InsertInfo(WorkerEntity obj)
{
con = Connectionsql.Connection();
bool term = SelectMysql.result("insert into tb_zhigong(Gonghao,Password,Gongzuodanwei) values(" + "'" + obj.Jobnumber + "'" + "," + "'" + obj.Password + "'" + ","
+ "'" + obj.Workunit + "')");
try
{
if (term == true)
{
return(term);
}
}
catch (MySqlException e)
{
MessageBox.Show(e.Message, "提示", MessageBoxButtons.OK);
}
finally
{
con.Close();
}
return(term);
}