public int tb_CompanyMenthodUpDate(tb_Company Company)
{
int intFalg = 0;
try
{
string str_Add = "update tb_Company set ";
str_Add += "CompanyName='" + Company.strCompanyName + "',CompanyDirector='" + Company.strCompanyDirector + "',";
str_Add += "CompanyPhone='" + Company.strCompanyPhone + "',CompanyFax='" + Company.strCompanyFax + "',CompanyAddress='" + Company.strCompanyAddress + "',";
str_Add += "Falg='" + Company.intEmpFalg + "' where CompanyID ='" + Company.intCompanyID + "'";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString());
return(intFalg);
}
}
//删除
public Boolean Delete(tb_Company company)
{
string sqlDelete = "update tb_Company set ";
sqlDelete += "Flag='" + company.intEmpFlag + "' where ComID ='" + company.intCompanyID + "'";
try
{
SqlConnection conn = (new GetSqlConnection()).GetCon();
SqlCommand cmd = new SqlCommand(sqlDelete, conn);
cmd.ExecuteNonQuery();
conn.Dispose();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return(false);
}
}
//添加
public Boolean Add(tb_Company company)
{
string sqlAdd = "insert into tb_Company values( ";
sqlAdd += "'" + company.intCompanyID + "','" + company.strCompanyName + "','" + company.strCompanyDirector + "',";
sqlAdd += "'" + company.strCompanyPhone + "','" + company.strCompanyAddress + "','" + company.strCompanyFax + "',";
sqlAdd += "'" + company.strCompanyRemark + "','" + company.daReDateTime + "'," + company.intEmpFlag + ")";
try
{
SqlConnection conn = (new GetSqlConnection()).GetCon();
SqlCommand cmd = new SqlCommand(sqlAdd, conn);
cmd.ExecuteNonQuery();
conn.Dispose();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
//修改
public Boolean Update(tb_Company company)
{
string sqlUpdate = "update tb_Company set ";
sqlUpdate += "ComName='" + company.strCompanyName + "',ComDirector='" + company.strCompanyDirector + "',";
sqlUpdate += "ComPhone='" + company.strCompanyPhone + "',ComFax='" + company.strCompanyFax + "',ComAddress='" + company.strCompanyAddress + "',";
sqlUpdate += "ComRemark='" + company.strCompanyRemark + "',ReDateTime='" + company.daReDateTime + "',Flag='" + company.intEmpFlag + "' where ComID ='" + company.intCompanyID + "'";
try
{
SqlConnection conn = (new GetSqlConnection()).GetCon();
SqlCommand cmd = new SqlCommand(sqlUpdate, conn);
cmd.ExecuteNonQuery();
conn.Dispose();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
return(false);
}
}
public int tb_CompanyMenthodAdd(tb_Company Company)
{
int intFalg = 0;
try
{
string str_Add = "insert into tb_Company values( ";
str_Add += "'" + Company.intCompanyID + "','" + Company.strCompanyName + "',";
str_Add += "'" + Company.strCompanyPhone + "','" + Company.strCompanyFax + "','" + Company.strCompanyAddress + "',";
str_Add += "'" + Company.intEmpFalg + "','" + Company.strCompanyDirector + "')";
getSqlConnection getConnection = new getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(str_Add, conn);
intFalg = cmd.ExecuteNonQuery();
conn.Dispose();
return(intFalg);
}
catch (Exception ee)
{
return(intFalg);
}
}
public int tb_CompanyMenthodDelete(tb_Company Company)
{
int intFalg = 0;
return(intFalg);
}
