protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version"))
{
ControlBindManager.BindCustomer(this.drpCustomer);
string ProductNumber = Server.UrlDecode(ToolManager.GetQueryString("ProductNumber"));
string Version = Server.UrlDecode(ToolManager.GetQueryString("Version"));
string CustomerId = Server.UrlDecode(ToolManager.GetQueryString("CustomerId"));
string error = string.Empty;
string sql = string.Format(" select * from ProductCustomerProperty where ProductNumber='{0}' and Version='{1}' and CustomerId='{2}'", ProductNumber, Version, CustomerId);
if (!ToolManager.CheckQueryString("CustomerId"))
{
this.btnSubmit.Text = "添加";
this.lbCustomerProductNumber.Visible = false;
this.txtCustomerProductNumber.Visible = true;
}
else
{
this.btnSubmit.Text = "修改";
this.lbCustomerProductNumber.Visible = true;
this.txtCustomerProductNumber.Visible = false;
this.drpCustomer.Visible = false;
DataTable dt = SqlHelper.GetTable(sql, ref error);
drpCustomer.Enabled = false;
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lbProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString();
lblCustomer.Text = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString();
lbVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString();
lbCustomerProductNumber.Text = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
this.btnSubmit.Text = "修改";
}
}
this.lbProductNumber.Text = ProductNumber;
this.lbVersion.Text = Version;
}
else
{
Response.Write("请选择产成品编号、版本！");
Response.End();
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckQueryString("PackageNumber"))
{
ControlBindManager.BindCustomer(this.drpCustomer);
string PackageNumber = ToolManager.GetQueryString("PackageNumber");
string customerid = Server.UrlDecode(ToolManager.GetQueryString("CustomerId"));
string error = string.Empty;
string sql = string.Format(@" select p.PackageNumber,c.CustomerName,p.CustomerPackageInfoNumber,p.Remark from
PackageInfoCustomerProperty p left join Customer c on p.CustomerId=c.CustomerId where PackageNumber='{0}' and
p.CustomerId='{1}'", PackageNumber, customerid);
if (!ToolManager.CheckQueryString("CustomerId"))
{
this.btnSubmit.Text = "添加";
this.lbPackageNumber.Text = PackageNumber;
this.lbCustomer.Visible = false;
}
else
{
this.btnSubmit.Text = "修改";
this.drpCustomer.Visible = false;
this.lbPackageNumber.Text = PackageNumber;
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lbPackageNumber.Text = dr["PackageNumber"] == null ? "" : dr["PackageNumber"].ToString();
lbCustomer.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString();
txtCustomerPackageInfoNumber.Text = dr["CustomerPackageInfoNumber"] == null ? "" : dr["CustomerPackageInfoNumber"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
this.btnSubmit.Text = "修改";
}
}
}
else
{
Response.Write("请选择包编码！");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckQueryString("MaterialNumber"))
{
ControlBindManager.BindCustomer(this.drpCustomer);
string MaterialNumber = ToolManager.GetQueryString("MaterialNumber");
string customerid = Server.UrlDecode(ToolManager.GetQueryString("CustomerId"));
string error = string.Empty;
string sql = string.Format(@" select * from MaterialCustomerProperty where MaterialNumber='{0}' and CustomerId='{1}'", MaterialNumber, customerid);
if (!ToolManager.CheckQueryString("CustomerId"))
{
this.btnSubmit.Text = "添加";
this.lbMaterialNumber.Text = MaterialNumber;
this.lbCustomerMaterialNumber.Visible = false;
this.txtCustomerMaterialNumber.Visible = true;
}
else
{
this.btnSubmit.Text = "修改";
this.lbCustomerMaterialNumber.Visible = true;
this.txtCustomerMaterialNumber.Visible = false;
drpCustomer.Enabled = false;
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lbCustomerMaterialNumber.Text = dr["CustomerMaterialNumber"] == null ? "" : dr["CustomerMaterialNumber"].ToString();
drpCustomer.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
this.btnSubmit.Text = "修改";
}
}
this.lbMaterialNumber.Text = MaterialNumber;
}
else
{
Response.Write("请选择原材料！");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindCustomer(drpCustomer);
// ControlBindManager.BindDrp(" select distinct (USER_NAME) ,User_Id from PM_USER ", this.drpCustomerContact, "User_Id", "USER_NAME");
if (ToolManager.CheckQueryString("id"))
{
string error = string.Empty;
string sql = string.Format(" select * from QuoteInfo where QuoteNumber='{0}'", ToolManager.GetQueryString("id"));
DataTable dt = SqlHelper.GetTable(sql, ref error);
DataRow dr = dt.Rows[0];
txtQuoteTime.Text = dr["QuoteTime"] == null ? "" : dr["QuoteTime"].ToString();
drpType.SelectedValue = dr["QuoteType"] == null ? "" : dr["QuoteType"].ToString();
drpCustomer.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString();
//用户名
//ControlBindManager.BindDrp(" select distinct (USER_NAME) ,User_Id from PM_USER ", this.drpCustomerContact, "User_Id", "USER_NAME");
txtCustomerContact.Text = dr["ContactId"] == null ? "" : dr["ContactId"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
btnSubmit.Text = "修改";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select USER_ID,USER_NAME from PM_USER", this.drpName, "USER_ID", "USER_NAME");
ControlBindManager.BindCustomer(this.drpCustomerId);
this.trReportTime.Visible = false;
if (ToolManager.CheckQueryString("ReportTime") && ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version"))
{
DataTable dt = HasDeleted();
if (dt != null)
{
DataRow dr = dt.Rows[0];
lblCustomerId.Text = dr["CustomerName"] == null ? "" : dr["CustomerName"].ToString();
lbReportTime.Text = dr["ReportTime"] == null ? "" : dr["ReportTime"].ToString();
lblProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString();
lblVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString();
txtCustomerProductNumber.Text = dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString();
txtQty.Text = dr["Qty"] == null ? "" : dr["Qty"].ToString();
txtRepairReason.Text = dr["RepairReason"] == null ? "" : dr["RepairReason"].ToString();
txtRepairDate.Text = dr["RepairDate"] == null ? "" : dr["RepairDate"].ToString();
txtRepairInspectionDate.Text = dr["RepairInspectionDate"] == null ? "" : dr["RepairInspectionDate"].ToString();
drpName.Text = dr["Name"] == null ? "" : dr["Name"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
BindCustomer(txtProductNumber.Text, txtVersion.Text, drpCustomerId.Text, dr["CustomerProductNumber"] == null ? "" : dr["CustomerProductNumber"].ToString());
}
btnSubmit.Text = "修改";
this.txtReportTime.Visible = false;
this.lbReportTime.Visible = true;
this.txtProductNumber.Enabled = false;
this.txtVersion.Enabled = false;
this.drpCustomerId.Visible = false;
this.txtProductNumber.Visible = false;
this.txtVersion.Visible = false;
}
else
{
btnSubmit.Text = "添加";
this.lbReportTime.Visible = false;
this.txtReportTime.Visible = true;
this.lblCustomerId.Visible = false;
if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version") && ToolManager.CheckQueryString("CustomerId"))
{
string productnumber = ToolManager.GetQueryString("ProductNumber");
string version = ToolManager.GetQueryString("Version");
string customerid = ToolManager.GetQueryString("CustomerId");
string sql = string.Format(@"
select CustomerProductNumber from ProductCustomerProperty where ProductNumber='{0}' and Version ='{1}' and CustomerId='{2}'", productnumber, version, customerid);
Response.Write(SqlHelper.GetScalar(sql));
Response.End();
}
}
if (ToolManager.CheckQueryString("m"))
{
string result = string.Empty;
string sql = string.Format(@" select top 20 ProductNumber,[Version] ,ProductName from Product ");
if (ToolManager.CheckQueryString("contion"))
{
sql += string.Format(@" where
ProductNumber like '%{0}%' or ProductNumber like'%{0}' or ProductNumber like '{0}%' or
ProductName like '%{0}%' or ProductName like'%{0}' or ProductName like '{0}%'
order by ProductNumber asc", ToolManager.GetQueryString("contion"));
}
DataTable dt = SqlHelper.GetTable(sql);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
result += string.Format(" <tr><td>{0}</td><td>{1}</td><td>{2}</td></tr>", dr["ProductName"], dr["ProductNumber"], dr["Version"]);
}
}
Response.Write(result);
Response.End();
return;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ControlBindManager.BindCustomer(this.drpCustomerId);
}
