private void ShowInfo()
{
MyERP.BLL.PUB_SALE bll = new MyERP.BLL.PUB_SALE();
MyERP.Model.PUB_SALE model = bll.GetModel();
this.lblCompanyCode.Text = model.CompanyCode;
this.lblEmployeCode.Text = model.EmployeCode;
this.lblEmployeeName.Text = model.EmployeeName;
this.lblDepartmentCode.Text = model.DepartmentCode;
this.lblEmployeeType.Text = model.EmployeeType;
this.lblIDCardNo.Text = model.IDCardNo;
this.lblSociatyNo.Text = model.SociatyNo;
this.lblSensusData.Text = model.SensusData;
this.lblSex.Text = model.Sex;
this.lblBirthDay.Text = model.BirthDay.ToString();
this.lblDegree.Text = model.Degree;
this.lblDegreeCard.Text = model.DegreeCard;
this.lblHealth.Text = model.Health;
this.lblHealthDate.Text = model.HealthDate.ToString();
this.lblSpinsterhood.Text = model.Spinsterhood;
this.lblSpinsterhoodDate.Text = model.SpinsterhoodDate.ToString();
this.lblIdleness.Text = model.Idleness;
this.lblIdlenessDate.Text = model.IdlenessDate.ToString();
this.lblTitle.Text = model.Title;
this.lblArrialDay.Text = model.ArrialDay.ToString();
this.lblLeaveDay.Text = model.LeaveDay.ToString();
this.lblPhone.Text = model.Phone;
this.lblAddress.Text = model.Address;
this.lblZip.Text = model.Zip;
this.lblEmail.Text = model.Email;
this.lblAllowUsed.Text = model.AllowUsed;
this.lblSociatyCode.Text = model.SociatyCode;
this.lblSociatyDate.Text = model.SociatyDate.ToString();
this.lblSociatyPay.Text = model.SociatyPay.ToString();
this.lblIndiSWBX.Text = model.IndiSWBX.ToString();
this.lblIndiSYBX.Text = model.IndiSYBX.ToString();
this.lblSociatyComp.Text = model.SociatyComp;
this.lblRemark.Text = model.Remark;
this.lblEmployeNo.Text = model.EmployeNo;
this.lblWorkID.Text = model.WorkID;
this.lblSituations.Text = model.Situations;
this.lblHospitalPay.Text = model.HospitalPay;
this.lblHospitalDate.Text = model.HospitalDate.ToString();
this.lblContract.Text = model.Contract;
this.lblContractDate.Text = model.ContractDate.ToString();
this.lblPayMounth.Text = model.PayMounth;
this.lblIsZB.Text = model.IsZB;
this.lblIsBD.Text = model.IsBD;
this.lblLastEdit.Text = model.LastEdit.ToString();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.PUB_SALE GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 CompanyCode,EmployeCode,EmployeeName,DepartmentCode,EmployeeType,IDCardNo,SociatyNo,SensusData,Sex,BirthDay,Degree,DegreeCard,Health,HealthDate,Spinsterhood,SpinsterhoodDate,Idleness,IdlenessDate,Title,ArrialDay,LeaveDay,Phone,Address,Zip,Email,AllowUsed,SociatyCode,SociatyDate,SociatyPay,IndiSWBX,IndiSYBX,SociatyComp,Remark,EmployeNo,WorkID,Situations,HospitalPay,HospitalDate,Contract,ContractDate,PayMounth,IsZB,IsBD,LastEdit from PUB_SALE ");
strSql.Append(" where ");
SqlParameter[] parameters =
{
};
MyERP.Model.PUB_SALE model = new MyERP.Model.PUB_SALE();
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.txtCompanyCode.Text.Trim().Length == 0)
{
strErr += "CompanyCode不能为空！\\n";
}
if (this.txtEmployeCode.Text.Trim().Length == 0)
{
strErr += "EmployeCode不能为空！\\n";
}
if (this.txtEmployeeName.Text.Trim().Length == 0)
{
strErr += "EmployeeName不能为空！\\n";
}
if (this.txtDepartmentCode.Text.Trim().Length == 0)
{
strErr += "DepartmentCode不能为空！\\n";
}
if (this.txtEmployeeType.Text.Trim().Length == 0)
{
strErr += "EmployeeType不能为空！\\n";
}
if (this.txtIDCardNo.Text.Trim().Length == 0)
{
strErr += "IDCardNo不能为空！\\n";
}
if (this.txtSociatyNo.Text.Trim().Length == 0)
{
strErr += "SociatyNo不能为空！\\n";
}
if (this.txtSensusData.Text.Trim().Length == 0)
{
strErr += "SensusData不能为空！\\n";
}
if (this.txtSex.Text.Trim().Length == 0)
{
strErr += "Sex不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtBirthDay.Text))
{
strErr += "BirthDay格式错误！\\n";
}
if (this.txtDegree.Text.Trim().Length == 0)
{
strErr += "Degree不能为空！\\n";
}
if (this.txtDegreeCard.Text.Trim().Length == 0)
{
strErr += "DegreeCard不能为空！\\n";
}
if (this.txtHealth.Text.Trim().Length == 0)
{
strErr += "Health不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtHealthDate.Text))
{
strErr += "HealthDate格式错误！\\n";
}
if (this.txtSpinsterhood.Text.Trim().Length == 0)
{
strErr += "Spinsterhood不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtSpinsterhoodDate.Text))
{
strErr += "SpinsterhoodDate格式错误！\\n";
}
if (this.txtIdleness.Text.Trim().Length == 0)
{
strErr += "Idleness不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtIdlenessDate.Text))
{
strErr += "IdlenessDate格式错误！\\n";
}
if (this.txtTitle.Text.Trim().Length == 0)
{
strErr += "Title不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtArrialDay.Text))
{
strErr += "ArrialDay格式错误！\\n";
}
if (!PageValidate.IsDateTime(txtLeaveDay.Text))
{
strErr += "LeaveDay格式错误！\\n";
}
if (this.txtPhone.Text.Trim().Length == 0)
{
strErr += "Phone不能为空！\\n";
}
if (this.txtAddress.Text.Trim().Length == 0)
{
strErr += "Address不能为空！\\n";
}
if (this.txtZip.Text.Trim().Length == 0)
{
strErr += "Zip不能为空！\\n";
}
if (this.txtEmail.Text.Trim().Length == 0)
{
strErr += "Email不能为空！\\n";
}
if (this.txtAllowUsed.Text.Trim().Length == 0)
{
strErr += "AllowUsed不能为空！\\n";
}
if (this.txtSociatyCode.Text.Trim().Length == 0)
{
strErr += "SociatyCode不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtSociatyDate.Text))
{
strErr += "SociatyDate格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtSociatyPay.Text))
{
strErr += "SociatyPay格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtIndiSWBX.Text))
{
strErr += "IndiSWBX格式错误！\\n";
}
if (!PageValidate.IsDecimal(txtIndiSYBX.Text))
{
strErr += "IndiSYBX格式错误！\\n";
}
if (this.txtSociatyComp.Text.Trim().Length == 0)
{
strErr += "SociatyComp不能为空！\\n";
}
if (this.txtRemark.Text.Trim().Length == 0)
{
strErr += "Remark不能为空！\\n";
}
if (this.txtEmployeNo.Text.Trim().Length == 0)
{
strErr += "EmployeNo不能为空！\\n";
}
if (this.txtWorkID.Text.Trim().Length == 0)
{
strErr += "WorkID不能为空！\\n";
}
if (this.txtSituations.Text.Trim().Length == 0)
{
strErr += "Situations不能为空！\\n";
}
if (this.txtHospitalPay.Text.Trim().Length == 0)
{
strErr += "HospitalPay不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtHospitalDate.Text))
{
strErr += "HospitalDate格式错误！\\n";
}
if (this.txtContract.Text.Trim().Length == 0)
{
strErr += "Contract不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtContractDate.Text))
{
strErr += "ContractDate格式错误！\\n";
}
if (this.txtPayMounth.Text.Trim().Length == 0)
{
strErr += "PayMounth不能为空！\\n";
}
if (this.txtIsZB.Text.Trim().Length == 0)
{
strErr += "IsZB不能为空！\\n";
}
if (this.txtIsBD.Text.Trim().Length == 0)
{
strErr += "IsBD不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
string CompanyCode = this.txtCompanyCode.Text;
string EmployeCode = this.txtEmployeCode.Text;
string EmployeeName = this.txtEmployeeName.Text;
string DepartmentCode = this.txtDepartmentCode.Text;
string EmployeeType = this.txtEmployeeType.Text;
string IDCardNo = this.txtIDCardNo.Text;
string SociatyNo = this.txtSociatyNo.Text;
string SensusData = this.txtSensusData.Text;
string Sex = this.txtSex.Text;
DateTime BirthDay = DateTime.Parse(this.txtBirthDay.Text);
string Degree = this.txtDegree.Text;
string DegreeCard = this.txtDegreeCard.Text;
string Health = this.txtHealth.Text;
DateTime HealthDate = DateTime.Parse(this.txtHealthDate.Text);
string Spinsterhood = this.txtSpinsterhood.Text;
DateTime SpinsterhoodDate = DateTime.Parse(this.txtSpinsterhoodDate.Text);
string Idleness = this.txtIdleness.Text;
DateTime IdlenessDate = DateTime.Parse(this.txtIdlenessDate.Text);
string Title = this.txtTitle.Text;
DateTime ArrialDay = DateTime.Parse(this.txtArrialDay.Text);
DateTime LeaveDay = DateTime.Parse(this.txtLeaveDay.Text);
string Phone = this.txtPhone.Text;
string Address = this.txtAddress.Text;
string Zip = this.txtZip.Text;
string Email = this.txtEmail.Text;
string AllowUsed = this.txtAllowUsed.Text;
string SociatyCode = this.txtSociatyCode.Text;
DateTime SociatyDate = DateTime.Parse(this.txtSociatyDate.Text);
decimal SociatyPay = decimal.Parse(this.txtSociatyPay.Text);
decimal IndiSWBX = decimal.Parse(this.txtIndiSWBX.Text);
decimal IndiSYBX = decimal.Parse(this.txtIndiSYBX.Text);
string SociatyComp = this.txtSociatyComp.Text;
string Remark = this.txtRemark.Text;
string EmployeNo = this.txtEmployeNo.Text;
string WorkID = this.txtWorkID.Text;
string Situations = this.txtSituations.Text;
string HospitalPay = this.txtHospitalPay.Text;
DateTime HospitalDate = DateTime.Parse(this.txtHospitalDate.Text);
string Contract = this.txtContract.Text;
DateTime ContractDate = DateTime.Parse(this.txtContractDate.Text);
string PayMounth = this.txtPayMounth.Text;
string IsZB = this.txtIsZB.Text;
string IsBD = this.txtIsBD.Text;
byte[] LastEdit = new UnicodeEncoding().GetBytes(this.txtLastEdit.Text);
MyERP.Model.PUB_SALE model = new MyERP.Model.PUB_SALE();
model.CompanyCode = CompanyCode;
model.EmployeCode = EmployeCode;
model.EmployeeName = EmployeeName;
model.DepartmentCode = DepartmentCode;
model.EmployeeType = EmployeeType;
model.IDCardNo = IDCardNo;
model.SociatyNo = SociatyNo;
model.SensusData = SensusData;
model.Sex = Sex;
model.BirthDay = BirthDay;
model.Degree = Degree;
model.DegreeCard = DegreeCard;
model.Health = Health;
model.HealthDate = HealthDate;
model.Spinsterhood = Spinsterhood;
model.SpinsterhoodDate = SpinsterhoodDate;
model.Idleness = Idleness;
model.IdlenessDate = IdlenessDate;
model.Title = Title;
model.ArrialDay = ArrialDay;
model.LeaveDay = LeaveDay;
model.Phone = Phone;
model.Address = Address;
model.Zip = Zip;
model.Email = Email;
model.AllowUsed = AllowUsed;
model.SociatyCode = SociatyCode;
model.SociatyDate = SociatyDate;
model.SociatyPay = SociatyPay;
model.IndiSWBX = IndiSWBX;
model.IndiSYBX = IndiSYBX;
model.SociatyComp = SociatyComp;
model.Remark = Remark;
model.EmployeNo = EmployeNo;
model.WorkID = WorkID;
model.Situations = Situations;
model.HospitalPay = HospitalPay;
model.HospitalDate = HospitalDate;
model.Contract = Contract;
model.ContractDate = ContractDate;
model.PayMounth = PayMounth;
model.IsZB = IsZB;
model.IsBD = IsBD;
model.LastEdit = LastEdit;
MyERP.BLL.PUB_SALE bll = new MyERP.BLL.PUB_SALE();
bll.Add(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "add.aspx");
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.PUB_SALE DataRowToModel(DataRow row)
{
MyERP.Model.PUB_SALE model = new MyERP.Model.PUB_SALE();
if (row != null)
{
if (row["CompanyCode"] != null)
{
model.CompanyCode = row["CompanyCode"].ToString();
}
if (row["EmployeCode"] != null)
{
model.EmployeCode = row["EmployeCode"].ToString();
}
if (row["EmployeeName"] != null)
{
model.EmployeeName = row["EmployeeName"].ToString();
}
if (row["DepartmentCode"] != null)
{
model.DepartmentCode = row["DepartmentCode"].ToString();
}
if (row["EmployeeType"] != null)
{
model.EmployeeType = row["EmployeeType"].ToString();
}
if (row["IDCardNo"] != null)
{
model.IDCardNo = row["IDCardNo"].ToString();
}
if (row["SociatyNo"] != null)
{
model.SociatyNo = row["SociatyNo"].ToString();
}
if (row["SensusData"] != null)
{
model.SensusData = row["SensusData"].ToString();
}
if (row["Sex"] != null)
{
model.Sex = row["Sex"].ToString();
}
if (row["BirthDay"] != null && row["BirthDay"].ToString() != "")
{
model.BirthDay = DateTime.Parse(row["BirthDay"].ToString());
}
if (row["Degree"] != null)
{
model.Degree = row["Degree"].ToString();
}
if (row["DegreeCard"] != null)
{
model.DegreeCard = row["DegreeCard"].ToString();
}
if (row["Health"] != null)
{
model.Health = row["Health"].ToString();
}
if (row["HealthDate"] != null && row["HealthDate"].ToString() != "")
{
model.HealthDate = DateTime.Parse(row["HealthDate"].ToString());
}
if (row["Spinsterhood"] != null)
{
model.Spinsterhood = row["Spinsterhood"].ToString();
}
if (row["SpinsterhoodDate"] != null && row["SpinsterhoodDate"].ToString() != "")
{
model.SpinsterhoodDate = DateTime.Parse(row["SpinsterhoodDate"].ToString());
}
if (row["Idleness"] != null)
{
model.Idleness = row["Idleness"].ToString();
}
if (row["IdlenessDate"] != null && row["IdlenessDate"].ToString() != "")
{
model.IdlenessDate = DateTime.Parse(row["IdlenessDate"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["ArrialDay"] != null && row["ArrialDay"].ToString() != "")
{
model.ArrialDay = DateTime.Parse(row["ArrialDay"].ToString());
}
if (row["LeaveDay"] != null && row["LeaveDay"].ToString() != "")
{
model.LeaveDay = DateTime.Parse(row["LeaveDay"].ToString());
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["Address"] != null)
{
model.Address = row["Address"].ToString();
}
if (row["Zip"] != null)
{
model.Zip = row["Zip"].ToString();
}
if (row["Email"] != null)
{
model.Email = row["Email"].ToString();
}
if (row["AllowUsed"] != null)
{
model.AllowUsed = row["AllowUsed"].ToString();
}
if (row["SociatyCode"] != null)
{
model.SociatyCode = row["SociatyCode"].ToString();
}
if (row["SociatyDate"] != null && row["SociatyDate"].ToString() != "")
{
model.SociatyDate = DateTime.Parse(row["SociatyDate"].ToString());
}
if (row["SociatyPay"] != null && row["SociatyPay"].ToString() != "")
{
model.SociatyPay = decimal.Parse(row["SociatyPay"].ToString());
}
if (row["IndiSWBX"] != null && row["IndiSWBX"].ToString() != "")
{
model.IndiSWBX = decimal.Parse(row["IndiSWBX"].ToString());
}
if (row["IndiSYBX"] != null && row["IndiSYBX"].ToString() != "")
{
model.IndiSYBX = decimal.Parse(row["IndiSYBX"].ToString());
}
if (row["SociatyComp"] != null)
{
model.SociatyComp = row["SociatyComp"].ToString();
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["EmployeNo"] != null)
{
model.EmployeNo = row["EmployeNo"].ToString();
}
if (row["WorkID"] != null)
{
model.WorkID = row["WorkID"].ToString();
}
if (row["Situations"] != null)
{
model.Situations = row["Situations"].ToString();
}
if (row["HospitalPay"] != null)
{
model.HospitalPay = row["HospitalPay"].ToString();
}
if (row["HospitalDate"] != null && row["HospitalDate"].ToString() != "")
{
model.HospitalDate = DateTime.Parse(row["HospitalDate"].ToString());
}
if (row["Contract"] != null)
{
model.Contract = row["Contract"].ToString();
}
if (row["ContractDate"] != null && row["ContractDate"].ToString() != "")
{
model.ContractDate = DateTime.Parse(row["ContractDate"].ToString());
}
if (row["PayMounth"] != null)
{
model.PayMounth = row["PayMounth"].ToString();
}
if (row["IsZB"] != null)
{
model.IsZB = row["IsZB"].ToString();
}
if (row["IsBD"] != null)
{
model.IsBD = row["IsBD"].ToString();
}
if (row["LastEdit"] != null && row["LastEdit"].ToString() != "")
{
model.LastEdit = (byte[])row["LastEdit"];
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MyERP.Model.PUB_SALE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PUB_SALE(");
strSql.Append("CompanyCode,EmployeCode,EmployeeName,DepartmentCode,EmployeeType,IDCardNo,SociatyNo,SensusData,Sex,BirthDay,Degree,DegreeCard,Health,HealthDate,Spinsterhood,SpinsterhoodDate,Idleness,IdlenessDate,Title,ArrialDay,LeaveDay,Phone,Address,Zip,Email,AllowUsed,SociatyCode,SociatyDate,SociatyPay,IndiSWBX,IndiSYBX,SociatyComp,Remark,EmployeNo,WorkID,Situations,HospitalPay,HospitalDate,Contract,ContractDate,PayMounth,IsZB,IsBD,LastEdit)");
strSql.Append(" values (");
strSql.Append("@CompanyCode,@EmployeCode,@EmployeeName,@DepartmentCode,@EmployeeType,@IDCardNo,@SociatyNo,@SensusData,@Sex,@BirthDay,@Degree,@DegreeCard,@Health,@HealthDate,@Spinsterhood,@SpinsterhoodDate,@Idleness,@IdlenessDate,@Title,@ArrialDay,@LeaveDay,@Phone,@Address,@Zip,@Email,@AllowUsed,@SociatyCode,@SociatyDate,@SociatyPay,@IndiSWBX,@IndiSYBX,@SociatyComp,@Remark,@EmployeNo,@WorkID,@Situations,@HospitalPay,@HospitalDate,@Contract,@ContractDate,@PayMounth,@IsZB,@IsBD,@LastEdit)");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 10),
new SqlParameter("@EmployeCode", SqlDbType.NVarChar, 12),
new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 20),
new SqlParameter("@DepartmentCode", SqlDbType.NVarChar, 12),
new SqlParameter("@EmployeeType", SqlDbType.NVarChar, 6),
new SqlParameter("@IDCardNo", SqlDbType.NVarChar, 20),
new SqlParameter("@SociatyNo", SqlDbType.NVarChar, 20),
new SqlParameter("@SensusData", SqlDbType.NVarChar, 1),
new SqlParameter("@Sex", SqlDbType.NVarChar, 6),
new SqlParameter("@BirthDay", SqlDbType.SmallDateTime),
new SqlParameter("@Degree", SqlDbType.NVarChar, 6),
new SqlParameter("@DegreeCard", SqlDbType.NVarChar, 1),
new SqlParameter("@Health", SqlDbType.NVarChar, 1),
new SqlParameter("@HealthDate", SqlDbType.SmallDateTime),
new SqlParameter("@Spinsterhood", SqlDbType.NVarChar, 1),
new SqlParameter("@SpinsterhoodDate", SqlDbType.SmallDateTime),
new SqlParameter("@Idleness", SqlDbType.NVarChar, 1),
new SqlParameter("@IdlenessDate", SqlDbType.SmallDateTime),
new SqlParameter("@Title", SqlDbType.NVarChar, 20),
new SqlParameter("@ArrialDay", SqlDbType.SmallDateTime),
new SqlParameter("@LeaveDay", SqlDbType.SmallDateTime),
new SqlParameter("@Phone", SqlDbType.NVarChar, 100),
new SqlParameter("@Address", SqlDbType.NVarChar, 60),
new SqlParameter("@Zip", SqlDbType.NVarChar, 6),
new SqlParameter("@Email", SqlDbType.NVarChar, 40),
new SqlParameter("@AllowUsed", SqlDbType.NVarChar, 1),
new SqlParameter("@SociatyCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SociatyDate", SqlDbType.SmallDateTime),
new SqlParameter("@SociatyPay", SqlDbType.Decimal, 9),
new SqlParameter("@IndiSWBX", SqlDbType.Decimal, 9),
new SqlParameter("@IndiSYBX", SqlDbType.Decimal, 9),
new SqlParameter("@SociatyComp", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@EmployeNo", SqlDbType.NVarChar, 30),
new SqlParameter("@WorkID", SqlDbType.NVarChar, 30),
new SqlParameter("@Situations", SqlDbType.NVarChar, 20),
new SqlParameter("@HospitalPay", SqlDbType.NText),
new SqlParameter("@HospitalDate", SqlDbType.SmallDateTime),
new SqlParameter("@Contract", SqlDbType.NText),
new SqlParameter("@ContractDate", SqlDbType.SmallDateTime),
new SqlParameter("@PayMounth", SqlDbType.NVarChar, 20),
new SqlParameter("@IsZB", SqlDbType.NVarChar, 1),
new SqlParameter("@IsBD", SqlDbType.NVarChar, 1),
new SqlParameter("@LastEdit", SqlDbType.VarBinary, 8)
};
parameters[0].Value = model.CompanyCode;
parameters[1].Value = model.EmployeCode;
parameters[2].Value = model.EmployeeName;
parameters[3].Value = model.DepartmentCode;
parameters[4].Value = model.EmployeeType;
parameters[5].Value = model.IDCardNo;
parameters[6].Value = model.SociatyNo;
parameters[7].Value = model.SensusData;
parameters[8].Value = model.Sex;
parameters[9].Value = model.BirthDay;
parameters[10].Value = model.Degree;
parameters[11].Value = model.DegreeCard;
parameters[12].Value = model.Health;
parameters[13].Value = model.HealthDate;
parameters[14].Value = model.Spinsterhood;
parameters[15].Value = model.SpinsterhoodDate;
parameters[16].Value = model.Idleness;
parameters[17].Value = model.IdlenessDate;
parameters[18].Value = model.Title;
parameters[19].Value = model.ArrialDay;
parameters[20].Value = model.LeaveDay;
parameters[21].Value = model.Phone;
parameters[22].Value = model.Address;
parameters[23].Value = model.Zip;
parameters[24].Value = model.Email;
parameters[25].Value = model.AllowUsed;
parameters[26].Value = model.SociatyCode;
parameters[27].Value = model.SociatyDate;
parameters[28].Value = model.SociatyPay;
parameters[29].Value = model.IndiSWBX;
parameters[30].Value = model.IndiSYBX;
parameters[31].Value = model.SociatyComp;
parameters[32].Value = model.Remark;
parameters[33].Value = model.EmployeNo;
parameters[34].Value = model.WorkID;
parameters[35].Value = model.Situations;
parameters[36].Value = model.HospitalPay;
parameters[37].Value = model.HospitalDate;
parameters[38].Value = model.Contract;
parameters[39].Value = model.ContractDate;
parameters[40].Value = model.PayMounth;
parameters[41].Value = model.IsZB;
parameters[42].Value = model.IsBD;
parameters[43].Value = model.LastEdit;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MyERP.Model.PUB_SALE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update PUB_SALE set ");
strSql.Append("CompanyCode=@CompanyCode,");
strSql.Append("EmployeCode=@EmployeCode,");
strSql.Append("EmployeeName=@EmployeeName,");
strSql.Append("DepartmentCode=@DepartmentCode,");
strSql.Append("EmployeeType=@EmployeeType,");
strSql.Append("IDCardNo=@IDCardNo,");
strSql.Append("SociatyNo=@SociatyNo,");
strSql.Append("SensusData=@SensusData,");
strSql.Append("Sex=@Sex,");
strSql.Append("BirthDay=@BirthDay,");
strSql.Append("Degree=@Degree,");
strSql.Append("DegreeCard=@DegreeCard,");
strSql.Append("Health=@Health,");
strSql.Append("HealthDate=@HealthDate,");
strSql.Append("Spinsterhood=@Spinsterhood,");
strSql.Append("SpinsterhoodDate=@SpinsterhoodDate,");
strSql.Append("Idleness=@Idleness,");
strSql.Append("IdlenessDate=@IdlenessDate,");
strSql.Append("Title=@Title,");
strSql.Append("ArrialDay=@ArrialDay,");
strSql.Append("LeaveDay=@LeaveDay,");
strSql.Append("Phone=@Phone,");
strSql.Append("Address=@Address,");
strSql.Append("Zip=@Zip,");
strSql.Append("Email=@Email,");
strSql.Append("AllowUsed=@AllowUsed,");
strSql.Append("SociatyCode=@SociatyCode,");
strSql.Append("SociatyDate=@SociatyDate,");
strSql.Append("SociatyPay=@SociatyPay,");
strSql.Append("IndiSWBX=@IndiSWBX,");
strSql.Append("IndiSYBX=@IndiSYBX,");
strSql.Append("SociatyComp=@SociatyComp,");
strSql.Append("Remark=@Remark,");
strSql.Append("EmployeNo=@EmployeNo,");
strSql.Append("WorkID=@WorkID,");
strSql.Append("Situations=@Situations,");
strSql.Append("HospitalPay=@HospitalPay,");
strSql.Append("HospitalDate=@HospitalDate,");
strSql.Append("Contract=@Contract,");
strSql.Append("ContractDate=@ContractDate,");
strSql.Append("PayMounth=@PayMounth,");
strSql.Append("IsZB=@IsZB,");
strSql.Append("IsBD=@IsBD,");
strSql.Append("LastEdit=@LastEdit");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@CompanyCode", SqlDbType.NVarChar, 10),
new SqlParameter("@EmployeCode", SqlDbType.NVarChar, 12),
new SqlParameter("@EmployeeName", SqlDbType.NVarChar, 20),
new SqlParameter("@DepartmentCode", SqlDbType.NVarChar, 12),
new SqlParameter("@EmployeeType", SqlDbType.NVarChar, 6),
new SqlParameter("@IDCardNo", SqlDbType.NVarChar, 20),
new SqlParameter("@SociatyNo", SqlDbType.NVarChar, 20),
new SqlParameter("@SensusData", SqlDbType.NVarChar, 1),
new SqlParameter("@Sex", SqlDbType.NVarChar, 6),
new SqlParameter("@BirthDay", SqlDbType.SmallDateTime),
new SqlParameter("@Degree", SqlDbType.NVarChar, 6),
new SqlParameter("@DegreeCard", SqlDbType.NVarChar, 1),
new SqlParameter("@Health", SqlDbType.NVarChar, 1),
new SqlParameter("@HealthDate", SqlDbType.SmallDateTime),
new SqlParameter("@Spinsterhood", SqlDbType.NVarChar, 1),
new SqlParameter("@SpinsterhoodDate", SqlDbType.SmallDateTime),
new SqlParameter("@Idleness", SqlDbType.NVarChar, 1),
new SqlParameter("@IdlenessDate", SqlDbType.SmallDateTime),
new SqlParameter("@Title", SqlDbType.NVarChar, 20),
new SqlParameter("@ArrialDay", SqlDbType.SmallDateTime),
new SqlParameter("@LeaveDay", SqlDbType.SmallDateTime),
new SqlParameter("@Phone", SqlDbType.NVarChar, 100),
new SqlParameter("@Address", SqlDbType.NVarChar, 60),
new SqlParameter("@Zip", SqlDbType.NVarChar, 6),
new SqlParameter("@Email", SqlDbType.NVarChar, 40),
new SqlParameter("@AllowUsed", SqlDbType.NVarChar, 1),
new SqlParameter("@SociatyCode", SqlDbType.NVarChar, 50),
new SqlParameter("@SociatyDate", SqlDbType.SmallDateTime),
new SqlParameter("@SociatyPay", SqlDbType.Decimal, 9),
new SqlParameter("@IndiSWBX", SqlDbType.Decimal, 9),
new SqlParameter("@IndiSYBX", SqlDbType.Decimal, 9),
new SqlParameter("@SociatyComp", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200),
new SqlParameter("@EmployeNo", SqlDbType.NVarChar, 30),
new SqlParameter("@WorkID", SqlDbType.NVarChar, 30),
new SqlParameter("@Situations", SqlDbType.NVarChar, 20),
new SqlParameter("@HospitalPay", SqlDbType.NText),
new SqlParameter("@HospitalDate", SqlDbType.SmallDateTime),
new SqlParameter("@Contract", SqlDbType.NText),
new SqlParameter("@ContractDate", SqlDbType.SmallDateTime),
new SqlParameter("@PayMounth", SqlDbType.NVarChar, 20),
new SqlParameter("@IsZB", SqlDbType.NVarChar, 1),
new SqlParameter("@IsBD", SqlDbType.NVarChar, 1),
new SqlParameter("@LastEdit", SqlDbType.VarBinary, 8)
};
parameters[0].Value = model.CompanyCode;
parameters[1].Value = model.EmployeCode;
parameters[2].Value = model.EmployeeName;
parameters[3].Value = model.DepartmentCode;
parameters[4].Value = model.EmployeeType;
parameters[5].Value = model.IDCardNo;
parameters[6].Value = model.SociatyNo;
parameters[7].Value = model.SensusData;
parameters[8].Value = model.Sex;
parameters[9].Value = model.BirthDay;
parameters[10].Value = model.Degree;
parameters[11].Value = model.DegreeCard;
parameters[12].Value = model.Health;
parameters[13].Value = model.HealthDate;
parameters[14].Value = model.Spinsterhood;
parameters[15].Value = model.SpinsterhoodDate;
parameters[16].Value = model.Idleness;
parameters[17].Value = model.IdlenessDate;
parameters[18].Value = model.Title;
parameters[19].Value = model.ArrialDay;
parameters[20].Value = model.LeaveDay;
parameters[21].Value = model.Phone;
parameters[22].Value = model.Address;
parameters[23].Value = model.Zip;
parameters[24].Value = model.Email;
parameters[25].Value = model.AllowUsed;
parameters[26].Value = model.SociatyCode;
parameters[27].Value = model.SociatyDate;
parameters[28].Value = model.SociatyPay;
parameters[29].Value = model.IndiSWBX;
parameters[30].Value = model.IndiSYBX;
parameters[31].Value = model.SociatyComp;
parameters[32].Value = model.Remark;
parameters[33].Value = model.EmployeNo;
parameters[34].Value = model.WorkID;
parameters[35].Value = model.Situations;
parameters[36].Value = model.HospitalPay;
parameters[37].Value = model.HospitalDate;
parameters[38].Value = model.Contract;
parameters[39].Value = model.ContractDate;
parameters[40].Value = model.PayMounth;
parameters[41].Value = model.IsZB;
parameters[42].Value = model.IsBD;
parameters[43].Value = model.LastEdit;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
