private void BindDrpProduct()
{
string sql = string.Format(@"select distinct (mo.ProductNumber+'^'+mo.Version) as Value,
(mo.ProductName+' 【'+mo.Version+'】') as Text
from Product mo order by Text asc");
ControlBindManager.BindDrp(sql, this.drpProduct, "Value", "Text");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select distinct USER_NAME,USER_ID from PM_USER", drpName, "USER_ID", "USER_NAME");
LoadPage();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select distinct PaymentMode from PaymentMode", this.drpPaymentMode, "PaymentMode", "PaymentMode");
LoadPage();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql = string.Format(" select OdersNumber from SaleOder where ProductType ='贸易' and OdersType ='样品订单' and OrderStatus ='未完成' and ISNULL( CheckTime ,'')!='' ");
ControlBindManager.BindDrp(sql, drpOrderNumber, "OdersNumber", "OdersNumber");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
spPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0409", "Print");
ControlBindManager.BindDrp(@"select distinct OdersNumber from SaleOder where ProductType='加工' and OrderStatus='未完成' and isnull(CheckTime,'')!=''", drpOdersNumber, "OdersNumber", "OdersNumber");
PageSearch();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select Id,PaymentMode from PaymentMode", drpPaymentMode, "Id", "PaymentMode");
ControlBindManager.BindDrp("select SupplierId,SupplierName from SupplierInfo", drpSupplierId, "SupplierId", "SupplierName");
ControlBindManager.BindDrp("select [USER_ID],[USER_NAME] from PM_USER", drpContactId, "USER_ID", "USER_NAME");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string getsupSql = "select SupplierId,SupplierName from SupplierInfo order by SupplierName asc";
DataTable dtSupplier = SqlHelper.GetTable(getsupSql);
foreach (DataRow dr in dtSupplier.Rows)
{
SupplierIds += dr["SupplierName"] + ",";
}
SupplierIds = SupplierIds.TrimEnd(',');
ControlBindManager.BindDrp("select Id,PaymentMode from PaymentMode", drpPaymentMode, "Id", "PaymentMode");
//ControlBindManager.BindDrp("select SupplierId,SupplierName from SupplierInfo order by SupplierName asc", drpSupplierId, "SupplierId", "SupplierName");
ControlBindManager.BindDrp("select [USER_ID],[USER_NAME] from PM_USER", drpContactId, "USER_ID", "USER_NAME");
if (ToolManager.CheckQueryString("OrdersNumber"))
{
string ordersNumber = ToolManager.GetQueryString("OrdersNumber");
if (!CheckHas(ordersNumber))
{
Response.Write("该采购订单不存在！");
Response.End();
return;
}
string sql = string.Format(" select * from CertificateOrders where OrdersNumber='{0}' ", ordersNumber);
DataTable dt = SqlHelper.GetTable(sql);
DataRow dr = dt.Rows[0];
txtOrdersDate.Text = dr["OrdersDate"] == null ? "" : dr["OrdersDate"].ToString();
drpPaymentMode.SelectedValue = dr["PaymentMode"] == null ? "" : dr["PaymentMode"].ToString();
//drpSupplierId.SelectedValue = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString();
DataRow[] drs = dtSupplier.Select("SupplierId='" + dr["SupplierId"] + "'");
if (drs.Length > 0)
{
this.SupplierName.Value = drs[0]["SupplierName"].ToString();
}
drpContactId.SelectedValue = dr["ContactId"] == null ? "" : dr["ContactId"].ToString();
drpOrderType.SelectedValue = dr["OrderType"].ToString();
txtHTNumber.Text = dr["HTNumber"] == null ? "" : dr["HTNumber"].ToString();
txtOrderNumber.Text = ordersNumber;
txtOrderNumber.ReadOnly = true;
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
btnSubmit.Text = "修改";
}
else
{
btnSubmit.Text = "添加";
txtOrderNumber.ReadOnly = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp(" select WorkSnNumber,WorkSnName from WorkSn ", drpWorkSnNumber, "WorkSnNumber", "WorkSnName");
if (ToolManager.CheckQueryString("ProductNumber") && ToolManager.CheckQueryString("Version"))
{
string ProductNumber = ToolManager.GetQueryString("ProductNumber");
string Version = ToolManager.GetQueryString("Version");
string tempSql = string.Format(@"select CustomerProductNumber from ProductCustomerProperty where ProductNumber ='{0}' and Version ='{1}'", ProductNumber, Version);
string temp = string.Empty;
foreach (DataRow drT in SqlHelper.GetTable(tempSql).Rows)
{
temp += drT["CustomerProductNumber"] == null ? "" : drT["CustomerProductNumber"].ToString() + ",";
}
lbCustomerProductNumber.Text = temp.TrimEnd(',');
string WorkSnNumber = Server.UrlDecode(ToolManager.GetQueryString("WorkSnNumber"));
string error = string.Empty;
string sql = string.Format(@" select * from ProductWorkSnProperty where ProductNumber='{0}' and Version='{1}' and WorkSnNumber='{2}'", ProductNumber, Version, WorkSnNumber);
if (!ToolManager.CheckQueryString("WorkSnNumber"))
{
this.btnSubmit.Text = "添加";
this.lbWorkSnNumber.Visible = false;
}
else
{
this.btnSubmit.Text = "修改";
this.drpWorkSnNumber.Visible = false;
this.lbWorkSnNumber.Visible = true;
sql = string.Format(@" select * from ProductWorkSnProperty where
ProductNumber='{0}' and Version='{1}' and WorkSnNumber='{2}'", ProductNumber, Version, WorkSnNumber);
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lbProductNumber.Text = dr["ProductNumber"] == null ? "" : dr["ProductNumber"].ToString();
lbVersion.Text = dr["Version"] == null ? "" : dr["Version"].ToString();
lbWorkSnNumber.Text = WorkSnNumber;
txtRowNumber.Text = dr["RowNumber"] == null ? "" : dr["RowNumber"].ToString();
txtRatedManhour.Text = dr["RatedManhour"] == null ? "" : dr["RatedManhour"].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)
{
ControlBindManager.BindDrp("select USER_ID,USER_NAME from PM_USER", this.drpImportPerson, "USER_ID", "USER_NAME");
if (ToolManager.CheckQueryString("MaterialNumber"))
{
string MaterialNumber = ToolManager.GetQueryString("MaterialNumber");
string error = string.Empty;
string FileName = Server.UrlDecode(ToolManager.GetQueryString("FileName"));
string sql = string.Format(@" select * from MaterialBlueprintProperty where MaterialNumber='{0}' and FileName='{1}' ", MaterialNumber, FileName);
if (!ToolManager.CheckQueryString("FileName"))
{
this.btnSubmit.Text = "添加";
this.txtFileName.Visible = true;
this.lbFileName.Visible = false;
this.lbMaterialNumber.Text = MaterialNumber;
this.trModifyTime.Visible = false;
this.trImportTime.Visible = false;
this.txtImportTime.Text = DateTime.Now.ToString();
}
else
{
this.btnSubmit.Text = "修改";
trFileUrl.Visible = false;
this.txtFileName.Visible = false;
this.lbFileName.Visible = true;
this.trModifyTime.Visible = false;
this.trImportTime.Visible = false;
this.drpImportPerson.Visible = false;
this.txtModifyTime.Text = DateTime.Now.ToString();
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
this.lbFileName.Text = dr["FileName"] == null ? "" : dr["FileName"].ToString();
this.txtModifyTime.Text = dr["ModifyTime"] == null ? "" : dr["ModifyTime"].ToString();
this.txtImportTime.Text = dr["ImportTime"] == null ? "" : dr["ImportTime"].ToString();
sql = string.Format(@" select USER_NAME from PM_USER where USER_ID='{0}'",
dr["ImportPerson"] == null ? "" : dr["ImportPerson"].ToString());
string importpersion = SqlHelper.GetScalar(sql);
this.lblImportPerson.Text = importpersion;
this.txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
}
}
this.lbMaterialNumber.Text = MaterialNumber;
}
else
{
Response.Write("请选择原材料！");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='废品库'", this.drpScrapPosition, "WarehouseNumber", "WarehouseName");
ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='原材料库'", this.drpMaterialPosition, "WarehouseNumber", "WarehouseName");
drpMaterialPosition.SelectedValue = "ycl";
drpScrapPosition.SelectedValue = "fpk";
LoadPage();
}
}
private void BindProduct(string documentNumber, string value)
{
string sql = string.Format(@"select distinct (mo.MaterialNumber+'^'+mo.Version) as Value,
(p.ProductName+' 【'+mo.Version+'】') as Text
from (select * from StockInventoryLogDetail where [Version] !='0') mo
inner join Product p on mo.MaterialNumber=p.ProductNumber
where mo.InventoryNumber='{0}' ", documentNumber);
ControlBindManager.BindDrp(sql, this.drpProduct, "Value", "Text");
drpProduct.SelectedValue = value;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.trCheckTime.Visible = false;
this.trCreateTime.Visible = false;
this.trAuditor.Visible = false;
string WarehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
// ScarpWarehouseLogManager.BindWarehouseName(this.drpWarehouseName);
ControlBindManager.BindDrp("select WarehouseNumber,WarehouseName from WarehouseInfo where Type='原材料库'", this.drpWarehouseName, "WarehouseNumber", "WarehouseName");
drpWarehouseName.SelectedValue = "ycl";
string error = string.Empty;
string sql = string.Format(@" select * from MarerialWarehouseLog where WarehouseNumber='{0}' ", WarehouseNumber);
if (!ToolManager.CheckQueryString("WarehouseNumber"))
{
this.btnSubmit.Text = "添加";
this.lbWarehouseNumber.Visible = false;
trWarehouseNumber.Visible = false;
}
else
{
this.btnSubmit.Text = "修改";
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
this.txtWarehouseNumber.Text = dr["WarehouseNumber"] == null ? "" : dr["WarehouseNumber"].ToString();
this.drpWarehouseName.SelectedValue = dr["WarehouseName"] == null ? "" : dr["WarehouseName"].ToString();
this.drpChangeDirection.SelectedValue = dr["ChangeDirection"] == null ? "" : dr["ChangeDirection"].ToString();
this.drpType.Items.Clear();
this.drpType.DataSource = bind();
this.drpType.DataValueField = "InOutType";
this.drpType.DataTextField = "InOutType";
this.drpType.DataBind();
this.drpType.SelectedValue = dr["Type"] == null ? "" : dr["Type"].ToString();
this.txtCreator.Text = dr["Creator"] == null ? "" : dr["Creator"].ToString();
this.txtCreateTime.Text = dr["CreateTime"] == null ? "" : dr["CreateTime"].ToString();
this.txtCheckTime.Text = dr["CheckTime"] == null ? "" : dr["CheckTime"].ToString();
this.txtAuditor.Text = dr["Auditor"] == null ? "" : dr["Auditor"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
this.btnSubmit.Text = "修改";
this.txtWarehouseNumber.Visible = false;
this.lbWarehouseNumber.Text = ToolManager.GetQueryString("WarehouseNumber");
trWarehouseNumber.Visible = true;
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
drpOdersType.Items.Add("正常订单");
drpOdersType.Items.Add("加急订单");
drpOdersType.Items.Add("维修订单");
drpOdersType.Items.Add("临时订单");
drpOdersType.Items.Add("样品订单");
drpOdersType.Items.Add("MRP订单");
drpOdersType.Items.Add("包装生产订单");
ControlBindManager.BindDrp("select CustomerId,CustomerName from Customer", drpClient, "CustomerId", "CustomerName");
//用户名称
ControlBindManager.BindDrp("select user_id, USER_NAME from PM_USER", this.drpContact, "user_id", "USER_NAME");
ControlBindManager.BindDrp("select id,makecollectionsmode from MakeCollectionsMode", this.drpMakeCollectionsMode, "id", "makecollectionsmode");
if (ToolManager.CheckQueryString("id"))
{
string odersNumber = ToolManager.GetQueryString("id");
string error = string.Empty;
string sql = string.Format(" select * from SaleOder where OdersNumber='{0}'", odersNumber);
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count <= 0)
{
Response.Write("未知订单，该订单不存在或已被删除！");
Response.End();
return;
}
DataRow dr = dt.Rows[0];
txtOrdersDate.Text = dr["OrdersDate"] == null ? "" : dr["OrdersDate"].ToString();
drpOdersType.SelectedValue = dr["OdersType"] == null ? "" : dr["OdersType"].ToString();
drpProductType.SelectedValue = dr["ProductType"] == null ? "" : dr["ProductType"].ToString();
drpIsMinusStock.SelectedValue = dr["IsMinusStock"] == null ? "" : dr["IsMinusStock"].ToString();
this.drpMakeCollectionsMode.SelectedValue = dr["MakeCollectionsMode"] == null ? "" : dr["MakeCollectionsMode"].ToString();
drpClient.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString();
drpContact.SelectedValue = dr["ContactId"] == null ? "" : dr["ContactId"].ToString();
drpStatus.SelectedValue = dr["OrderStatus"] == null ? "" : dr["OrderStatus"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
txtCustomerOrderNumber.Text = dr["CustomerOrderNumber"] == null ? "" : dr["CustomerOrderNumber"].ToString();
tdStatus.Visible = true;
btnSubmit.Text = "修改";
//txtOrderNumber.Text = odersNumber;
//txtOrderNumber.ReadOnly = true;
}
else
{
tdStatus.Visible = false;
//txtOrderNumber.ReadOnly = false;
btnSubmit.Text = "添加";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select WarehouseName from WarehouseInfo where Type='半成品库'", this.drpHalfProductPosition, "WarehouseName", "WarehouseName");
ControlBindManager.BindDrp("select WarehouseName from WarehouseInfo where Type='产成品库'", this.drpFinishedGoodsPosition, "WarehouseName", "WarehouseName");
drpFinishedGoodsPosition.SelectedValue = "产成品库";
drpHalfProductPosition.SelectedValue = "半成品库";
this.trRatedManhour.Visible = false;
this.trCostPrice.Visible = false;
LoadPage();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (ToolManager.CheckQueryString("MaterialNumber"))
{
ControlBindManager.BindDrp("select * from SupplierInfo order by SupplierName asc", drpSupplierId, "SupplierId", "SupplierName");
string MaterialNumber = ToolManager.GetQueryString("MaterialNumber");
string supplierId = Server.UrlDecode(ToolManager.GetQueryString("SupplierId"));
string error = string.Empty;
string sql = string.Format(@" select * from MaterialSupplierProperty where
MaterialNumber='{0}' and SupplierId='{1}' ", MaterialNumber, supplierId);
if (!ToolManager.CheckQueryString("SupplierId"))
{
this.btnSubmit.Text = "添加";
this.lbMaterialNumber.Text = MaterialNumber;
this.lbSupplierMaterialNumber.Visible = false;
this.txtSupplierMaterialNumber.Visible = true;
}
else
{
this.btnSubmit.Text = "修改";
this.lbSupplierMaterialNumber.Visible = true;
this.txtSupplierMaterialNumber.Visible = false;
this.drpSupplierId.Enabled = false;
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lbSupplierMaterialNumber.Text = dr["SupplierMaterialNumber"] == null ? "" : dr["SupplierMaterialNumber"].ToString();
drpSupplierId.SelectedValue = dr["SupplierId"] == null ? "" : dr["SupplierId"].ToString();
txtMinOrderQty.Text = dr["MinOrderQty"] == null ? "" : dr["MinOrderQty"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
txtPrice.Text = dr["Prcie"] == null ? "" : dr["Prcie"].ToString();
txtDeliveryCycle.Text = dr["DeliveryCycle"] == null ? "" : dr["DeliveryCycle"].ToString();
}
}
this.lbMaterialNumber.Text = MaterialNumber;
}
else
{
Response.Write("请选择原材料！");
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
drpOdersType.Items.Add("正常订单");
drpOdersType.Items.Add("加急订单");
drpOdersType.Items.Add("维修订单");
drpOdersType.Items.Add("临时订单");
drpOdersType.Items.Add("样品订单");
drpOdersType.Items.Add("MRP订单");
drpOdersType.Items.Add("包装生产订单");
ControlBindManager.BindDrp("select CustomerId,CustomerName from Customer", drpClient, "CustomerId", "CustomerName");
//用户名称
ControlBindManager.BindDrp("select user_id, USER_NAME from PM_USER", this.drpContact, "user_id", "USER_NAME");
ControlBindManager.BindDrp("select id,makecollectionsmode from MakeCollectionsMode", this.drpMakeCollectionsMode, "id", "makecollectionsmode");
}
}
private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
ControlBindManager.BindDrp(" select id,MakeCollectionsMode from MakeCollectionsMode ", this.drpMakeCollectionsModeId, "id", "MakeCollectionsMode");
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from Customer where CustomerId='{0}' ", ToolManager.GetQueryString("Id"));
//sql = string.Format(@" select * from Customer where CustomerId='{0}' ", "5");
this.trCustomerNuber.Visible = false;
Customer customer = CustomerInfoManager.ConvertDataTableToModel(sql);
this.txtCustomerNumber.Text = customer.CustomerId;
this.txtCustomerName.Text = customer.CustomerName;
this.txtRegisteredAddress.Text = customer.RegisteredAddress;
this.txtLegalPerson.Text = customer.LegalPerson;
this.txtContacts.Text = customer.Contacts;
this.txtRegisteredPhone.Text = customer.RegisteredPhone;
this.txtContactTelephone.Text = customer.ContactTelephone;
this.txtFax.Text = customer.Fax;
this.txtMobilePhone.Text = customer.MobilePhone;
this.txtZipCode.Text = customer.ZipCode;
this.txtSparePhone.Text = customer.SparePhone;
this.txtEmail.Text = customer.Email;
this.txtQQ.Text = customer.QQ;
this.txtAccountBank.Text = customer.AccountBank;
this.txtSortCode.Text = customer.SortCode;
this.txtBankAccount.Text = customer.BankAccount;
this.txtTaxNo.Text = customer.TaxNo;
this.txtWebsiteAddress.Text = customer.WebsiteAddress;
this.txtDeliveryAddress.Text = customer.DeliveryAddress;
//this.txtPaymentdays.Text = customer.Paymentdays.ToString();
//this.drpPercentageInAdvance.SelectedValue = customer.PercentageInAdvance.ToString();
this.txtRemark.Text = customer.Remark;
this.drpMakeCollectionsModeId.SelectedValue = customer.MakeCollectionsModeId;
this.txtFactoryAddress.Text = customer.FactoryAddress;
this.drpReceiveType.SelectedValue = customer.ReceiveType;
btnSubmit.Text = "修改";
}
else
{
btnSubmit.Text = "添加";
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ControlBindManager.BindDrp("select distinct USER_ID,USER_NAME from PM_USER", this.drpDeliveryPerson, "USER_ID", "USER_NAME");
if (ToolManager.CheckQueryString("id"))
{
ControlBindManager.BindDrp(@"select CustomerId,CustomerName from Customer", this.drpCustomerName, "CustomerId", "CustomerName");
string deliveryNumber = ToolManager.GetQueryString("id");
string error = string.Empty;
string sql = string.Format("select * from DeliveryBill where DeliveryNumber='{0}'", deliveryNumber);
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count <= 0)
{
Response.Write("未知送货单，该送货单不存在或已被删除！");
Response.End();
return;
}
DataRow dr = dt.Rows[0];
drpDeliveryPerson.SelectedValue = dr["DeliveryPerson"] == null ? "" : dr["DeliveryPerson"].ToString();
txtDeliveryDate.Text = dr["DeliveryDate"] == null ? "" : dr["DeliveryDate"].ToString();
drpIsConfirm.SelectedValue = dr["IsConfirm"] == null ? "" : dr["IsConfirm"].ToString();
txtRemark.Text = dr["Remark"] == null ? "" : dr["Remark"].ToString();
drpCustomerName.SelectedValue = dr["CustomerId"] == null ? "" : dr["CustomerId"].ToString();
txtTel.Text = dr["Tel"] == null ? "" : dr["Tel"].ToString();
txtContactsName.Text = dr["ContactsName"] == null ? "" : dr["ContactsName"].ToString();
drpIsConfirm.Enabled = true;
btnSubmit.Text = "修改";
}
else
{
drpIsConfirm.Enabled = false;
btnSubmit.Text = "添加";
}
}
}
private void Bind()
{
string sql = "select WarehouseNumber,WarehouseName from WarehouseInfo";
ControlBindManager.BindDrp(sql, this.drpWarehouseName, "WarehouseNumber", "WarehouseName");
}
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)
{
string sql = string.Empty;
string error = string.Empty;
if (!IsPostBack)
{
if (!ToolManager.CheckQueryString("PlanNumber"))
{
Response.Write("未知开工单号！");
Response.End();
return;
}
plannumber = ToolManager.GetQueryString("PlanNumber");
ControlBindManager.BindDrp(@"select 班组 from V_ProductPlanSub where 开工单号='" + plannumber + "'", this.drpTeam, "班组", "班组");
string team = Server.UrlDecode(ToolManager.GetQueryString("Team"));
drpTeam.SelectedValue = team;
//string ordersnumber = ToolManager.GetQueryString("OrdersNumber");
//string productnumber = ToolManager.GetQueryString("ProductNumber");
//string version = ToolManager.GetQueryString("Version");
//string rownumber = ToolManager.GetQueryString("RowNumber");
Bind();
////审核人
//sql = string.Format("select Auditor from ProductPlan where PlanNumber='{0}'", plannumber);
//dt = SqlHelper.GetTable(sql);
//if (dt.Rows.Count > 0)
//{
// lblAuditor.Text = dt.Rows[0]["Auditor"].ToString();
//}
//sql = string.Format(@"select * from V_ProductPlan where 开工单号='{0}'", plannumber);
//dt = SqlHelper.GetTable(sql);
//if (dt.Rows.Count > 0)
//{
// DataRow dr = dt.Rows[0];
// type = dr["开工单类型"] == null ? "" : dr["开工单类型"].ToString();
//}
//sql = string.Format(@"select * from V_ProductPlanSub where 开工单号='{0}' and 班组='{1}'", plannumber, team);
//dt = SqlHelper.GetTable(sql);
//if (dt.Rows.Count > 0)
//{
// DataRow dr = dt.Rows[0];
// lblFactEndTime.Text = dr["实际结束时间"] == null ? "" : dr["实际结束时间"].ToString();
// lblFactFinishManhour.Text = dr["实际完成工时"] == null ? "" : dr["实际完成工时"].ToString();
// lblFactStartTime.Text = dr["实际开始时间"] == null ? "" : dr["实际开始时间"].ToString();
// lblFactTotalManhour.Text = dr["实际总工时"] == null ? "" : dr["实际总工时"].ToString();
// lblRatedTotalManhour.Text = dr["额定总工时"] == null ? "" : dr["额定总工时"].ToString();
// lblTargetFinishManhour.Text = dr["目标完成工时"] == null ? "" : dr["目标完成工时"].ToString();
// lblTeam.Text = dr["班组"] == null ? "" : dr["班组"].ToString();
//}
// sql = string.Format(@" delete ProductPlanSubDetail where PlanNumber ='{0}' and Team='{1}'
// and OrdersNumber='{2}' and ProductNumber='{3}' and Version='{4}' and RowNumber='{5}'",
//plannumber, team, ordersnumber, productnumber, version, rownumber);
// bool result = SqlHelper.ExecuteSql(sql, ref error);
// if (result)
// {
// Tool.WriteLog(Tool.LogType.Operating, "删除开工单分表明细" + ToolManager.ReplaceSingleQuotesToBlank(plannumber), "删除成功");
// return;
// }
// else
// {
// Tool.WriteLog(Tool.LogType.Operating, "删除开工单分表明细" + ToolManager.ReplaceSingleQuotesToBlank(plannumber), "删除失败！原因" + error);
// return;
// }
}
}
