/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyERP.Model.PUB_COMPANY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PUB_COMPANY(");
strSql.Append("COMPANY_CODE,COMPANY_NAME,COMPANY_FULLNAME,PARENT_COMPANY_CODE,MANAGER,ADDRESS,TELPHONE,ZIP,EMAIL,HTTP,LICENSE,REGISTER_BANK,BANK_ACCOUNT,ALLOW_USED,REMARK)");
strSql.Append(" values (");
strSql.Append("@COMPANY_CODE,@COMPANY_NAME,@COMPANY_FULLNAME,@PARENT_COMPANY_CODE,@MANAGER,@ADDRESS,@TELPHONE,@ZIP,@EMAIL,@HTTP,@LICENSE,@REGISTER_BANK,@BANK_ACCOUNT,@ALLOW_USED,@REMARK)");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 10),
new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 60),
new SqlParameter("@COMPANY_FULLNAME", SqlDbType.NChar, 200),
new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 10),
new SqlParameter("@MANAGER", SqlDbType.NVarChar, 20),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 200),
new SqlParameter("@TELPHONE", SqlDbType.NVarChar, 20),
new SqlParameter("@ZIP", SqlDbType.NVarChar, 6),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 20),
new SqlParameter("@HTTP", SqlDbType.NVarChar, 20),
new SqlParameter("@LICENSE", SqlDbType.NVarChar, 50),
new SqlParameter("@REGISTER_BANK", SqlDbType.NVarChar, 60),
new SqlParameter("@BANK_ACCOUNT", SqlDbType.NVarChar, 30),
new SqlParameter("@ALLOW_USED", SqlDbType.NVarChar, 1),
new SqlParameter("@REMARK", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.COMPANY_CODE;
parameters[1].Value = model.COMPANY_NAME;
parameters[2].Value = model.COMPANY_FULLNAME;
parameters[3].Value = model.PARENT_COMPANY_CODE;
parameters[4].Value = model.MANAGER;
parameters[5].Value = model.ADDRESS;
parameters[6].Value = model.TELPHONE;
parameters[7].Value = model.ZIP;
parameters[8].Value = model.EMAIL;
parameters[9].Value = model.HTTP;
parameters[10].Value = model.LICENSE;
parameters[11].Value = model.REGISTER_BANK;
parameters[12].Value = model.BANK_ACCOUNT;
parameters[13].Value = model.ALLOW_USED;
parameters[14].Value = model.REMARK;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void ShowInfo()
{
MyERP.BLL.PUB_COMPANY bll = new MyERP.BLL.PUB_COMPANY();
MyERP.Model.PUB_COMPANY model = bll.GetModel();
this.lblCOMPANY_CODE.Text = model.COMPANY_CODE;
this.lblCOMPANY_NAME.Text = model.COMPANY_NAME;
this.lblCOMPANY_FULLNAME.Text = model.COMPANY_FULLNAME;
this.lblPARENT_COMPANY_CODE.Text = model.PARENT_COMPANY_CODE;
this.lblMANAGER.Text = model.MANAGER;
this.lblADDRESS.Text = model.ADDRESS;
this.lblTELPHONE.Text = model.TELPHONE;
this.lblZIP.Text = model.ZIP;
this.lblEMAIL.Text = model.EMAIL;
this.lblHTTP.Text = model.HTTP;
this.lblLICENSE.Text = model.LICENSE;
this.lblREGISTER_BANK.Text = model.REGISTER_BANK;
this.lblBANK_ACCOUNT.Text = model.BANK_ACCOUNT;
this.lblALLOW_USED.Text = model.ALLOW_USED;
this.lblREMARK.Text = model.REMARK;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.PUB_COMPANY GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 COMPANY_CODE,COMPANY_NAME,COMPANY_FULLNAME,PARENT_COMPANY_CODE,MANAGER,ADDRESS,TELPHONE,ZIP,EMAIL,HTTP,LICENSE,REGISTER_BANK,BANK_ACCOUNT,ALLOW_USED,REMARK from PUB_COMPANY ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtCOMPANY_CODE.Text.Trim().Length == 0)
{
strErr += "COMPANY_CODE不能为空！\\n";
}
if (this.txtCOMPANY_NAME.Text.Trim().Length == 0)
{
strErr += "COMPANY_NAME不能为空！\\n";
}
if (this.txtCOMPANY_FULLNAME.Text.Trim().Length == 0)
{
strErr += "COMPANY_FULLNAME不能为空！\\n";
}
if (this.txtPARENT_COMPANY_CODE.Text.Trim().Length == 0)
{
strErr += "PARENT_COMPANY_CODE不能为空！\\n";
}
if (this.txtMANAGER.Text.Trim().Length == 0)
{
strErr += "MANAGER不能为空！\\n";
}
if (this.txtADDRESS.Text.Trim().Length == 0)
{
strErr += "ADDRESS不能为空！\\n";
}
if (this.txtTELPHONE.Text.Trim().Length == 0)
{
strErr += "TELPHONE不能为空！\\n";
}
if (this.txtZIP.Text.Trim().Length == 0)
{
strErr += "ZIP不能为空！\\n";
}
if (this.txtEMAIL.Text.Trim().Length == 0)
{
strErr += "EMAIL不能为空！\\n";
}
if (this.txtHTTP.Text.Trim().Length == 0)
{
strErr += "HTTP不能为空！\\n";
}
if (this.txtLICENSE.Text.Trim().Length == 0)
{
strErr += "LICENSE不能为空！\\n";
}
if (this.txtREGISTER_BANK.Text.Trim().Length == 0)
{
strErr += "REGISTER_BANK不能为空！\\n";
}
if (this.txtBANK_ACCOUNT.Text.Trim().Length == 0)
{
strErr += "BANK_ACCOUNT不能为空！\\n";
}
if (this.txtALLOW_USED.Text.Trim().Length == 0)
{
strErr += "ALLOW_USED不能为空！\\n";
}
if (this.txtREMARK.Text.Trim().Length == 0)
{
strErr += "REMARK不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string COMPANY_CODE = this.txtCOMPANY_CODE.Text;
string COMPANY_NAME = this.txtCOMPANY_NAME.Text;
string COMPANY_FULLNAME = this.txtCOMPANY_FULLNAME.Text;
string PARENT_COMPANY_CODE = this.txtPARENT_COMPANY_CODE.Text;
string MANAGER = this.txtMANAGER.Text;
string ADDRESS = this.txtADDRESS.Text;
string TELPHONE = this.txtTELPHONE.Text;
string ZIP = this.txtZIP.Text;
string EMAIL = this.txtEMAIL.Text;
string HTTP = this.txtHTTP.Text;
string LICENSE = this.txtLICENSE.Text;
string REGISTER_BANK = this.txtREGISTER_BANK.Text;
string BANK_ACCOUNT = this.txtBANK_ACCOUNT.Text;
string ALLOW_USED = this.txtALLOW_USED.Text;
string REMARK = this.txtREMARK.Text;
MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY();
model.COMPANY_CODE = COMPANY_CODE;
model.COMPANY_NAME = COMPANY_NAME;
model.COMPANY_FULLNAME = COMPANY_FULLNAME;
model.PARENT_COMPANY_CODE = PARENT_COMPANY_CODE;
model.MANAGER = MANAGER;
model.ADDRESS = ADDRESS;
model.TELPHONE = TELPHONE;
model.ZIP = ZIP;
model.EMAIL = EMAIL;
model.HTTP = HTTP;
model.LICENSE = LICENSE;
model.REGISTER_BANK = REGISTER_BANK;
model.BANK_ACCOUNT = BANK_ACCOUNT;
model.ALLOW_USED = ALLOW_USED;
model.REMARK = REMARK;
MyERP.BLL.PUB_COMPANY bll = new MyERP.BLL.PUB_COMPANY();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyERP.Model.PUB_COMPANY model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PUB_COMPANY set ");
strSql.Append("COMPANY_CODE=@COMPANY_CODE,");
strSql.Append("COMPANY_NAME=@COMPANY_NAME,");
strSql.Append("COMPANY_FULLNAME=@COMPANY_FULLNAME,");
strSql.Append("PARENT_COMPANY_CODE=@PARENT_COMPANY_CODE,");
strSql.Append("MANAGER=@MANAGER,");
strSql.Append("ADDRESS=@ADDRESS,");
strSql.Append("TELPHONE=@TELPHONE,");
strSql.Append("ZIP=@ZIP,");
strSql.Append("EMAIL=@EMAIL,");
strSql.Append("HTTP=@HTTP,");
strSql.Append("LICENSE=@LICENSE,");
strSql.Append("REGISTER_BANK=@REGISTER_BANK,");
strSql.Append("BANK_ACCOUNT=@BANK_ACCOUNT,");
strSql.Append("ALLOW_USED=@ALLOW_USED,");
strSql.Append("REMARK=@REMARK");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 10),
new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 60),
new SqlParameter("@COMPANY_FULLNAME", SqlDbType.NChar, 200),
new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 10),
new SqlParameter("@MANAGER", SqlDbType.NVarChar, 20),
new SqlParameter("@ADDRESS", SqlDbType.NVarChar, 200),
new SqlParameter("@TELPHONE", SqlDbType.NVarChar, 20),
new SqlParameter("@ZIP", SqlDbType.NVarChar, 6),
new SqlParameter("@EMAIL", SqlDbType.NVarChar, 20),
new SqlParameter("@HTTP", SqlDbType.NVarChar, 20),
new SqlParameter("@LICENSE", SqlDbType.NVarChar, 50),
new SqlParameter("@REGISTER_BANK", SqlDbType.NVarChar, 60),
new SqlParameter("@BANK_ACCOUNT", SqlDbType.NVarChar, 30),
new SqlParameter("@ALLOW_USED", SqlDbType.NVarChar, 1),
new SqlParameter("@REMARK", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.COMPANY_CODE;
parameters[1].Value = model.COMPANY_NAME;
parameters[2].Value = model.COMPANY_FULLNAME;
parameters[3].Value = model.PARENT_COMPANY_CODE;
parameters[4].Value = model.MANAGER;
parameters[5].Value = model.ADDRESS;
parameters[6].Value = model.TELPHONE;
parameters[7].Value = model.ZIP;
parameters[8].Value = model.EMAIL;
parameters[9].Value = model.HTTP;
parameters[10].Value = model.LICENSE;
parameters[11].Value = model.REGISTER_BANK;
parameters[12].Value = model.BANK_ACCOUNT;
parameters[13].Value = model.ALLOW_USED;
parameters[14].Value = model.REMARK;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.PUB_COMPANY DataRowToModel(DataRow row)
{
MyERP.Model.PUB_COMPANY model = new MyERP.Model.PUB_COMPANY();
if (row != null)
{
if (row["COMPANY_CODE"] != null)
{
model.COMPANY_CODE = row["COMPANY_CODE"].ToString();
}
if (row["COMPANY_NAME"] != null)
{
model.COMPANY_NAME = row["COMPANY_NAME"].ToString();
}
if (row["COMPANY_FULLNAME"] != null)
{
model.COMPANY_FULLNAME = row["COMPANY_FULLNAME"].ToString();
}
if (row["PARENT_COMPANY_CODE"] != null)
{
model.PARENT_COMPANY_CODE = row["PARENT_COMPANY_CODE"].ToString();
}
if (row["MANAGER"] != null)
{
model.MANAGER = row["MANAGER"].ToString();
}
if (row["ADDRESS"] != null)
{
model.ADDRESS = row["ADDRESS"].ToString();
}
if (row["TELPHONE"] != null)
{
model.TELPHONE = row["TELPHONE"].ToString();
}
if (row["ZIP"] != null)
{
model.ZIP = row["ZIP"].ToString();
}
if (row["EMAIL"] != null)
{
model.EMAIL = row["EMAIL"].ToString();
}
if (row["HTTP"] != null)
{
model.HTTP = row["HTTP"].ToString();
}
if (row["LICENSE"] != null)
{
model.LICENSE = row["LICENSE"].ToString();
}
if (row["REGISTER_BANK"] != null)
{
model.REGISTER_BANK = row["REGISTER_BANK"].ToString();
}
if (row["BANK_ACCOUNT"] != null)
{
model.BANK_ACCOUNT = row["BANK_ACCOUNT"].ToString();
}
if (row["ALLOW_USED"] != null)
{
model.ALLOW_USED = row["ALLOW_USED"].ToString();
}
if (row["REMARK"] != null)
{
model.REMARK = row["REMARK"].ToString();
}
}
return(model);
}
