protected void Page_Load(object sender, EventArgs e)
{
//删除
if (ToolManager.CheckQueryString("ids"))
{
string temp = SupplierInfoManager.DeleteSupplierInfo(ToolManager.GetQueryString("ids"));
string ids = ToolManager.GetQueryString("ids");
bool result = temp == "1" ? true : false;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "删除供应商信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除成功");
Response.Write(temp);
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "删除供应商信息" + ToolManager.ReplaceSingleQuotesToBlank(ids), "删除失败！原因" + temp);
Response.Write(temp);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPageOperation("btnSearch", "AddOrEditSupplierInfo.aspx", "SupplierDetailedInfoList.aspx");
}
divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0201", "Add");
divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0201", "Delete");
divImp.Visible = ToolCode.Tool.GetUserMenuFunc("L0201", "Imp");
divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0201", "Exp");
}
private void onload()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from SupplierInfo where SupplierId='{0}' ", ToolManager.GetQueryString("Id"));
SupplierInfo supplierinfo = SupplierInfoManager.ConvertDataTableToModel(sql);
this.lbSupplierId.InnerText = supplierinfo.SupplierId;
this.lbSupplierName.InnerText = supplierinfo.SupplierName;
this.lbRegisteredAddress.InnerText = supplierinfo.RegisteredAddress;
this.lbLegalPerson.InnerText = supplierinfo.LegalPerson;
this.lbContacts.InnerText = supplierinfo.Contacts;
this.lbRegisteredPhone.InnerText = supplierinfo.RegisteredPhone;
this.lbContactTelephone.InnerText = supplierinfo.ContactTelephone;
this.lbFax.InnerText = supplierinfo.Fax;
this.lbMobilePhone.InnerText = supplierinfo.MobilePhone;
this.lbEmail.InnerText = supplierinfo.Email;
this.lbQQ.InnerText = supplierinfo.QQ;
this.lbZipCode.InnerText = supplierinfo.ZipCode;
this.lbSparePhone.InnerText = supplierinfo.SparePhone;
this.lbAccountBank.InnerText = supplierinfo.AccountBank;
this.lbBankRowNumber.InnerText = supplierinfo.BankRowNumber;
this.lbBankAccount.InnerText = supplierinfo.BankAccount;
this.lbTaxNo.InnerText = supplierinfo.TaxNo;
this.lbDeliveryAddress.InnerText = supplierinfo.DeliveryAddress;
this.lbWebsiteAddress.InnerText = supplierinfo.WebsiteAddress;
this.lbRemark.InnerText = supplierinfo.Remark;
lbPaymentdays.InnerText = supplierinfo.paymentdays + "天";
lbPercentageInAdvance.InnerText = (Convert.ToDouble(supplierinfo.percentageInAdvance) * 100).ToString() + "%";
}
}
private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from SupplierInfo where SupplierId='{0}' ", ToolManager.GetQueryString("Id"));
//sql = string.Format(@" select * from SupplierInfo where SupplierId='{0}' ", "1");
this.trSupplierId.Visible = false;
SupplierInfo supplierinfo = SupplierInfoManager.ConvertDataTableToModel(sql);
this.txtSupplierId.Text = supplierinfo.SupplierId;
this.txtSupplierName.Text = supplierinfo.SupplierName;
this.txtRegisteredAddress.Text = supplierinfo.RegisteredAddress;
this.txtLegalPerson.Text = supplierinfo.LegalPerson;
this.txtContacts.Text = supplierinfo.Contacts;
this.txtRegisteredPhone.Text = supplierinfo.RegisteredPhone;
this.txtContactTelephone.Text = supplierinfo.ContactTelephone;
this.txtFax.Text = supplierinfo.Fax;
this.txtMobilePhone.Text = supplierinfo.MobilePhone;
this.txtZipCode.Text = supplierinfo.ZipCode;
this.txtSparePhone.Text = supplierinfo.SparePhone;
this.txtEmail.Text = supplierinfo.Email;
this.txtQQ.Text = supplierinfo.QQ;
this.txtAccountBank.Text = supplierinfo.AccountBank;
this.txtBankRowNumber.Text = supplierinfo.BankRowNumber;
this.txtBankAccount.Text = supplierinfo.BankAccount;
this.txtTaxNo.Text = supplierinfo.TaxNo;
this.txtWebsiteAddress.Text = supplierinfo.WebsiteAddress;
this.txtDeliveryAddress.Text = supplierinfo.DeliveryAddress;
this.txtRemark.Text = supplierinfo.Remark;
this.drpPaymentMode.SelectedValue = supplierinfo.PaymentMode;
//this.txtPaymentdays.Text = supplierinfo.paymentdays.ToString();
//this.drpPercentageInAdvance.SelectedValue = supplierinfo.percentageInAdvance.ToString();
this.txtFactoryAddress.Text = supplierinfo.FactoryAddress;
this.drpPayType.SelectedValue = supplierinfo.PayType;
btnSubmit.Text = "修改";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string error = string.Empty;
Model.SupplierInfo supplierinfo = new SupplierInfo();
supplierinfo.SupplierId = this.txtSupplierId.Text.Trim();
supplierinfo.SupplierName = this.txtSupplierName.Text.Trim();
supplierinfo.RegisteredAddress = this.txtRegisteredAddress.Text.Trim();
supplierinfo.LegalPerson = this.txtLegalPerson.Text.Trim();
supplierinfo.Contacts = this.txtContacts.Text.Trim();
supplierinfo.RegisteredPhone = this.txtRegisteredPhone.Text.Trim();
supplierinfo.ContactTelephone = this.txtContactTelephone.Text.Trim();
supplierinfo.Fax = this.txtFax.Text.Trim();
supplierinfo.MobilePhone = this.txtMobilePhone.Text.Trim();
supplierinfo.ZipCode = this.txtZipCode.Text.Trim();
supplierinfo.SparePhone = this.txtSparePhone.Text.Trim();
supplierinfo.Email = this.txtEmail.Text.Trim();
supplierinfo.QQ = this.txtQQ.Text.Trim();
supplierinfo.AccountBank = this.txtAccountBank.Text.Trim();
supplierinfo.BankRowNumber = this.txtBankRowNumber.Text.Trim();
supplierinfo.BankAccount = this.txtBankAccount.Text.Trim();
supplierinfo.TaxNo = this.txtTaxNo.Text.Trim();
supplierinfo.WebsiteAddress = this.txtWebsiteAddress.Text.Trim();
supplierinfo.DeliveryAddress = this.txtDeliveryAddress.Text.Trim();
supplierinfo.Remark = this.txtRemark.Text.Trim();
supplierinfo.paymentdays = 0;
supplierinfo.percentageInAdvance = 0;
supplierinfo.FactoryAddress = this.txtFactoryAddress.Text.Trim();
supplierinfo.PayType = this.drpPayType.SelectedValue;
supplierinfo.PaymentMode = this.drpPaymentMode.SelectedValue;
if (string.IsNullOrEmpty(supplierinfo.SupplierId) || string.IsNullOrEmpty(supplierinfo.SupplierName) || string.IsNullOrEmpty(supplierinfo.PaymentMode))
{
lbSubmit.Text = "请将带*号的内容填写完整！";
return;
}
bool result;
if (btnSubmit.Text.Equals("添加"))
{
result = SupplierInfoManager.AddSupplierInfo(supplierinfo, ref error);
lbSubmit.Text = result == true ? "添加成功" : "添加失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "增加供应商信息" + supplierinfo.SupplierId, "增加成功");
ToolCode.Tool.ResetControl(this.Controls);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "增加供应商信息" + supplierinfo.SupplierId, "增加失败！原因" + error);
return;
}
}
else
{
result = SupplierInfoManager.EditSupplierInfo(supplierinfo, ref error);
lbSubmit.Text = result == true ? "修改成功" : "修改失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑供应商信息" + supplierinfo.SupplierId, "编辑成功");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑供应商信息" + supplierinfo.SupplierId, "编辑失败！原因" + error);
return;
}
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string error = string.Empty;
//DataTable dt = NPOIExcelHelper.ReadExcel(this.FU_Excel);
DataSet ds = ToolManager.ImpExcel(this.FU_Excel, Server);
if (ds == null)
{
lbMsg.Text = "选择的文件为空或不是标准的Excel文件！";
return;
}
List <SupplierInfo> supplierinfos = new List <SupplierInfo>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SupplierInfo supplierinfo = new SupplierInfo();
supplierinfo.SupplierId = dr["供应商编号"] == null ? "" : dr["供应商编号"].ToString();
supplierinfo.SupplierName = dr["供应商名称"] == null ? "" : dr["供应商名称"].ToString();
supplierinfo.RegisteredAddress = dr["注册地址"] == null ? "" : dr["注册地址"].ToString();
supplierinfo.LegalPerson = dr["法人代表"] == null ? "" : dr["法人代表"].ToString();
supplierinfo.Contacts = dr["联系人"] == null ? "" : dr["联系人"].ToString();
supplierinfo.RegisteredPhone = dr["注册电话"] == null ? "" : dr["注册电话"].ToString();
supplierinfo.ContactTelephone = dr["联系电话"] == null ? "" : dr["联系电话"].ToString();
supplierinfo.Fax = dr["传真"] == null ? "" : dr["传真"].ToString();
supplierinfo.MobilePhone = dr["手机"] == null ? "" : dr["手机"].ToString();
supplierinfo.ZipCode = dr["邮编"] == null ? "" : dr["邮编"].ToString();
supplierinfo.SparePhone = dr["备用电话"] == null ? "" : dr["备用电话"].ToString();
supplierinfo.Email = dr["Email"] == null ? "" : dr["Email"].ToString();
supplierinfo.QQ = dr["QQ"] == null ? "" : dr["QQ"].ToString();
supplierinfo.AccountBank = dr["开户银行"] == null ? "" : dr["开户银行"].ToString();
supplierinfo.BankRowNumber = dr["银行行号"] == null ? "" : dr["银行行号"].ToString();
supplierinfo.BankAccount = dr["银行帐号"] == null ? "" : dr["银行帐号"].ToString();
supplierinfo.TaxNo = dr["纳税号"] == null ? "" : dr["纳税号"].ToString();
supplierinfo.WebsiteAddress = dr["网址"] == null ? "" : dr["网址"].ToString();
supplierinfo.DeliveryAddress = dr["送货地点"] == null ? "" : dr["送货地点"].ToString();
supplierinfo.FactoryAddress = dr["工厂地址"] == null ? "" : dr["工厂地址"].ToString();
supplierinfo.Remark = dr["备注"] == null ? "" : dr["备注"].ToString();
supplierinfo.paymentdays = 0;
supplierinfo.percentageInAdvance = 0;
supplierinfo.PayType = dr["付款类型"] == null ? "" : dr["付款类型"].ToString();
supplierinfo.PaymentMode = dr["付款方式"] == null ? "" : dr["付款方式"].ToString();
//if (dr["账期"] == null || dr["账期"].ToString() == "")
//{
// supplierinfo.paymentdays = 0;
//}
//else
//{
// supplierinfo.paymentdays = Convert.ToInt32(dr["账期"]);
//}
//if (dr["预付百分比"] == null || dr["预付百分比"].ToString() == "")
//{
// supplierinfo.percentageInAdvance = 1.00;
//}
//else
//{
// supplierinfo.percentageInAdvance = Convert.ToDouble(dr["预付百分比"]);
//}
supplierinfos.Add(supplierinfo);
}
bool result = SupplierInfoManager.BatchAddData(supplierinfos, ref error);
lbMsg.Text = result == true ? "导入成功！" : "导入失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "导入供应商信息", "导入成功！");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "导入供应商信息", "导入失败！原因" + error);
return;
}
}
