/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyERP.Model.SYS_REGISTER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SYS_REGISTER(");
strSql.Append("COMPANY_CODE,COMPANY_NAME,PARENT_COMPANY_CODE,FULL_NAME,ADRESS,SERVICE_PHONE)");
strSql.Append(" values (");
strSql.Append("@COMPANY_CODE,@COMPANY_NAME,@PARENT_COMPANY_CODE,@FULL_NAME,@ADRESS,@SERVICE_PHONE)");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 50),
new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 50),
new SqlParameter("@FULL_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ADRESS", SqlDbType.NVarChar, 50),
new SqlParameter("@SERVICE_PHONE", SqlDbType.NChar, 10)
};
parameters[0].Value = model.COMPANY_CODE;
parameters[1].Value = model.COMPANY_NAME;
parameters[2].Value = model.PARENT_COMPANY_CODE;
parameters[3].Value = model.FULL_NAME;
parameters[4].Value = model.ADRESS;
parameters[5].Value = model.SERVICE_PHONE;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.SYS_REGISTER DataRowToModel(DataRow row)
{
MyERP.Model.SYS_REGISTER model = new MyERP.Model.SYS_REGISTER();
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["PARENT_COMPANY_CODE"] != null)
{
model.PARENT_COMPANY_CODE = row["PARENT_COMPANY_CODE"].ToString();
}
if (row["FULL_NAME"] != null)
{
model.FULL_NAME = row["FULL_NAME"].ToString();
}
if (row["ADRESS"] != null)
{
model.ADRESS = row["ADRESS"].ToString();
}
if (row["SERVICE_PHONE"] != null)
{
model.SERVICE_PHONE = row["SERVICE_PHONE"].ToString();
}
}
return(model);
}
private void ShowInfo(string COMPANY_CODE)
{
MyERP.BLL.SYS_REGISTER bll = new MyERP.BLL.SYS_REGISTER();
MyERP.Model.SYS_REGISTER model = bll.GetModel(COMPANY_CODE);
this.lblCOMPANY_CODE.Text = model.COMPANY_CODE;
this.lblCOMPANY_NAME.Text = model.COMPANY_NAME;
this.lblPARENT_COMPANY_CODE.Text = model.PARENT_COMPANY_CODE;
this.lblFULL_NAME.Text = model.FULL_NAME;
this.lblADRESS.Text = model.ADRESS;
this.lblSERVICE_PHONE.Text = model.SERVICE_PHONE;
}
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.txtPARENT_COMPANY_CODE.Text.Trim().Length == 0)
{
strErr += "PARENT_COMPANY_CODE不能为空！\\n";
}
if (this.txtFULL_NAME.Text.Trim().Length == 0)
{
strErr += "FULL_NAME不能为空！\\n";
}
if (this.txtADRESS.Text.Trim().Length == 0)
{
strErr += "ADRESS不能为空！\\n";
}
if (this.txtSERVICE_PHONE.Text.Trim().Length == 0)
{
strErr += "SERVICE_PHONE不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string COMPANY_CODE = this.txtCOMPANY_CODE.Text;
string COMPANY_NAME = this.txtCOMPANY_NAME.Text;
string PARENT_COMPANY_CODE = this.txtPARENT_COMPANY_CODE.Text;
string FULL_NAME = this.txtFULL_NAME.Text;
string ADRESS = this.txtADRESS.Text;
string SERVICE_PHONE = this.txtSERVICE_PHONE.Text;
MyERP.Model.SYS_REGISTER model = new MyERP.Model.SYS_REGISTER();
model.COMPANY_CODE = COMPANY_CODE;
model.COMPANY_NAME = COMPANY_NAME;
model.PARENT_COMPANY_CODE = PARENT_COMPANY_CODE;
model.FULL_NAME = FULL_NAME;
model.ADRESS = ADRESS;
model.SERVICE_PHONE = SERVICE_PHONE;
MyERP.BLL.SYS_REGISTER bll = new MyERP.BLL.SYS_REGISTER();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyERP.Model.SYS_REGISTER model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SYS_REGISTER set ");
strSql.Append("COMPANY_NAME=@COMPANY_NAME,");
strSql.Append("PARENT_COMPANY_CODE=@PARENT_COMPANY_CODE,");
strSql.Append("FULL_NAME=@FULL_NAME,");
strSql.Append("ADRESS=@ADRESS,");
strSql.Append("SERVICE_PHONE=@SERVICE_PHONE");
strSql.Append(" where COMPANY_CODE=@COMPANY_CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@PARENT_COMPANY_CODE", SqlDbType.NVarChar, 50),
new SqlParameter("@FULL_NAME", SqlDbType.NVarChar, 50),
new SqlParameter("@ADRESS", SqlDbType.NVarChar, 50),
new SqlParameter("@SERVICE_PHONE", SqlDbType.NChar, 10),
new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.COMPANY_NAME;
parameters[1].Value = model.PARENT_COMPANY_CODE;
parameters[2].Value = model.FULL_NAME;
parameters[3].Value = model.ADRESS;
parameters[4].Value = model.SERVICE_PHONE;
parameters[5].Value = model.COMPANY_CODE;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.SYS_REGISTER GetModel(string COMPANY_CODE)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 COMPANY_CODE,COMPANY_NAME,PARENT_COMPANY_CODE,FULL_NAME,ADRESS,SERVICE_PHONE from SYS_REGISTER ");
strSql.Append(" where COMPANY_CODE=@COMPANY_CODE ");
SqlParameter[] parameters =
{
new SqlParameter("@COMPANY_CODE", SqlDbType.NVarChar, 50)
};
parameters[0].Value = COMPANY_CODE;
MyERP.Model.SYS_REGISTER model = new MyERP.Model.SYS_REGISTER();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
