public void ProcessRequest(HttpContext context)
{
string result = string.Empty;
string sql = string.Empty;
//取原材料或者产品
if (ToolManager.CheckQueryString("IsMaterial"))
{
//原材料
if (ToolManager.GetQueryString("IsMaterial").Equals("true"))
{
sql = string.Format(@" select top 20 MaterialNumber,MaterialName from MarerialInfoTable ");
sql += string.Format(@" where
MaterialNumber like '%{0}%' or MaterialNumber like'%{0}' or MaterialNumber like '{0}%' or
MaterialName like '%{0}%' or MaterialName like'%{0}' or MaterialName like '{0}%'
order by MaterialNumber asc", ToolManager.GetQueryString("MaterialNumber"));
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></tr>", dr["MaterialName"], dr["MaterialNumber"]);
}
}
}
else//产品
{
}
}
//取库存数量
if (ToolManager.CheckQueryString("TableName"))
{
string tableName = ToolManager.GetQueryString("TableName");
string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber"); //出入库编号
string supplierMaterialNumberStr = string.Empty; //供应商物料编号字符串
string customerMaterialNumberStr = string.Empty; //客户物料编号字符串
string qty = string.Empty; //库存数量
//原材料
if (ToolManager.GetQueryString("IsMaterialForQty").Equals("true"))
{
string materialNumber = ToolManager.GetQueryString("MaterialNumber"); //原材料编号
sql = string.Format(@"select SupplierMaterialNumber
from MaterialSupplierProperty where MaterialNumber='{0}'", materialNumber);
supplierMaterialNumberStr = ControlBindManager.GetOption(sql, "SupplierMaterialNumber", "SupplierMaterialNumber");
sql = string.Format(@"
select CustomerMaterialNumber from MaterialCustomerProperty where MaterialNumber='{0}'", materialNumber);
customerMaterialNumberStr = ControlBindManager.GetOption(sql, "CustomerMaterialNumber", "CustomerMaterialNumber");
qty = StoreroomToolManager.GetinventoryQty(materialNumber, "", "", warehouseNumber, tableName, ToolEnum.ProductType.Marerial);
result = supplierMaterialNumberStr + "^" + customerMaterialNumberStr + "^" + qty;
}
else //产品
{
}
}
context.Response.ContentType = "text/plain";
context.Response.Write(result);
}
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)
{
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)
{
ControlBindManager.BindDrp("select distinct PaymentMode from PaymentMode", this.drpPaymentMode, "PaymentMode", "PaymentMode");
LoadPage();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lbWarehouseNumber.Text = ToolManager.GetQueryString("WarehouseNumber");
Warehouse();
ControlBindManager.BindSupplier(this.drpGYSID);
}
}
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)
{
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)
{
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 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();
}
}
}
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)
{
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();
}
}
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 btnSearch_Click(object sender, EventArgs e)
{
string date = txtDate.Text;
string productNumber = txtProductNumber.Text;
string customerProductNumber = txtCustomerProductNumber.Text;
string customername = txtCustomerName.Text.Trim();
string type = Server.UrlDecode(ToolManager.GetQueryString("Type"));
string sql = string.Empty;
if (type.Equals("包装销售出库"))
{
sql = string.Format(@"select distinct vj.OdersNumber, vj.OdersNumber +' ('+vj.CustomerOrderNumber+')' as oderName
from (select * from SaleOder where ProductType ='加工' and ISNULL (CheckTime ,'')!=''
and OrderStatus ='未完成') vj left join MachineOderDetail modt on vj.OdersNumber =modt.OdersNumber
where vj.OdersType in('包装生产订单')
");
}
else
{
sql = string.Format(@"select distinct vj.OdersNumber, vj.OdersNumber +' ('+vj.CustomerOrderNumber+')' as oderName from (select * from SaleOder where ProductType ='加工' and ISNULL (CheckTime ,'')!=''
and OrderStatus ='未完成') vj left join MachineOderDetail modt on vj.OdersNumber =modt.OdersNumber
where vj.OdersType in('正常订单','加急订单') ");
}
if (!string.IsNullOrEmpty(date))
{
sql += string.Format(" and modt.LeadTime <='{0}' ", date);
}
if (!string.IsNullOrEmpty(productNumber))
{
sql += string.Format(" and modt.ProductNumber ='{0}' ", productNumber);
}
if (!string.IsNullOrEmpty(customerProductNumber))
{
//sql += string.Format(" and modt.customerProductNumber='{0}' ", customerProductNumber);
sql += string.Format(@"and vj.OdersNumber in
(select distinct so.OdersNumber from SaleOder so inner join MachineOderDetail modt
on so.OdersNumber=modt.OdersNumber
where so.ProductType ='加工' and ISNULL (so.CheckTime ,'')!=''
and so.OrderStatus ='未完成'
and modt.CustomerProductNumber = '{0}'
and modt.Status ='未完成'
)", customerProductNumber);
}
if (!string.IsNullOrEmpty(customername))
{
sql += string.Format(" and vj.CustomerId='{0}' ", customername);
}
sql += " order by vj.OdersNumber desc ";
ControlBindManager.BindListBox(sql, drpOrdersNumber, "OdersNumber", "oderName");
}
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("ChoosedVlaue"))
{
string selectedValuePid = ToolManager.GetQueryString("ChoosedVlaue");
string sql = string.Format(@" select Type from MareriaType where Pid='{0}'", selectedValuePid);
Response.Write(ControlBindManager.GetOption(sql, "Type", "Type"));
Response.End();
return;
}
//divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Add");
//divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Delete");
//divImp.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Imp");
//divExp.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Exp");
//divPrint.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Print");
}
//删除
if (ToolManager.CheckQueryString("ids"))
{
string temp = MarerialInfoTableManager.DeleteData(Server.UrlDecode(Server.UrlDecode(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"))
{
GetPage("AddOrEditMarerialInfoTable.aspx", "MarerialInfoTableDetailedList.aspx", "btnSearch", "550", "600");
}
}
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();
}
}
}
private void Search()
{
string date = txtDate.Text;
string productNumber = txtProductNumber.Text.Trim();
string customerMaterialNumber = txtCustomerMaterialNumber.Text.Trim();
string customername = txtCustomerName.Text.Trim();
string cargotype = txtCargoType.Text.Trim();
string type = Server.UrlDecode(ToolManager.GetQueryString("Type"));
string sql = string.Empty;
sql = string.Format(@"
select distinct MY.OdersNumber,MY.OdersNumber+'___'+'('+MY.customerordernumber+')' as OdersNumber_Name,
MY.CreateTime from (select * from SaleOder where ProductType ='贸易' and ISNULL (CheckTime ,'')!=''
and OrderStatus ='未完成') MY
left join TradingOrderDetail tod on MY.OdersNumber =tod.OdersNumber
inner join MarerialInfoTable mi on tod.ProductNumber=mi.MaterialNumber where 1=1");
if (!string.IsNullOrEmpty(date))
{
sql += string.Format(" and tod.Delivery <='{0}' ", date);
}
if (!string.IsNullOrEmpty(productNumber))
{
sql += string.Format(" and tod.ProductNumber ='{0}' ", productNumber);
}
if (!string.IsNullOrEmpty(customerMaterialNumber))
{
//sql += string.Format(" and tod.CustomerMaterialNumber='{0}' ", customerMaterialNumber);
sql += string.Format(@" and my.OdersNumber in (
select distinct OdersNumber from TradingOrderDetail where CustomerMaterialNumber='{0}' and Status='未完成')"
, customerMaterialNumber);
}
if (!string.IsNullOrEmpty(customername))
{
sql += string.Format(" and my.CustomerId='{0}'", customername);
}
if (!string.IsNullOrEmpty(cargotype))
{
sql += string.Format(" and mi.CargoType='{0}'", cargotype);
}
sql += " order by my.CreateTime desc ";
ControlBindManager.BindListBox(sql, drpOrdersNumber, "OdersNumber", "OdersNumber_Name");
foreach (ListItem item in drpOrdersNumber.Items)
{
item.Selected = 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");
}
}
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)
{
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();
}
}
}
private void BindCustomerNumber(HttpContext context)
{
if (ToolManager.CheckQueryString("versionP") && ToolManager.CheckQueryString("productNumberP"))
{
string error = string.Empty;
string sql = string.Format(@"
select CustomerProductNumber from ProductCustomerProperty where ProductNumber='{0}' and Version='{1}'", ToolManager.GetQueryString("productNumberP"), ToolManager.GetQueryString("versionP"));
string result = ControlBindManager.GetOption(sql, "CustomerProductNumber", "CustomerProductNumber").Trim();
sql = string.Format("select ProductName from Product where ProductNumber='{0}' and Version ='{1}'", ToolManager.GetQueryString("productNumberP"), ToolManager.GetQueryString("versionP"));
DataTable dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
string temp = dt.Rows[0]["ProductName"] == null ? "" : dt.Rows[0]["ProductName"].ToString();
result += "^" + temp;
}
context.Response.ContentType = "text/plain";
context.Response.Write(result);
context.Response.End();
return;
}
}
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 = "添加";
}
}
}
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 = "修改";
}
}
}
private void LoadPage()
{
if (!ToolManager.CheckQueryString("WarehouseNumber"))
{
Response.Write("未知出入库单");
Response.End();
return;
}
string warehouseNumber = ToolManager.GetQueryString("WarehouseNumber");
lbWarehouseNumber.Text = warehouseNumber;
string type = Server.UrlDecode(ToolManager.GetQueryString("Type"));
titleName = type;
var existNumbers = GetExistDocumentNumbers(warehouseNumber);
switch (type)
{
case "采购入库":
documentName = "采购订单";
ControlBindManager.BindListBox("select OrdersNumber,OrdersNumber+' ('+HTNumber+')' as text from CertificateOrders where OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' order by CreateTime asc", drpOrdersNumber, "OrdersNumber", "text", existNumbers);
trSaleOrder.Visible = false;
break;
case "采购退料出库":
documentName = "采购订单";
ControlBindManager.BindListBox("select OrdersNumber from CertificateOrders where OrderStatus ='未完成' and ISNULL (CheckTime ,'') !='' order by CreateTime desc", drpOrdersNumber, "OrdersNumber", "OrdersNumber", existNumbers);
break;
case "盘盈入库":
documentName = "盘点编号";
ControlBindManager.BindListBox(@"select InventoryNumber
from StockInventoryLog where ISNULL ( AuditeTime ,'')!=''", drpOrdersNumber, "InventoryNumber", "InventoryNumber", existNumbers);
break;
case "盘亏出库":
documentName = "盘点编号";
ControlBindManager.BindListBox(@"select InventoryNumber
from StockInventoryLog where ISNULL ( AuditeTime ,'')!=''", drpOrdersNumber, "InventoryNumber", "InventoryNumber", existNumbers);
break;
case "销售出库（贸易）":
documentName = "销售订单";
ControlBindManager.BindListBox(@"select OdersNumber,OdersNumber+' ('+customerordernumber+')' customerordernumber from SaleOder where ProductType ='贸易'
and OrderStatus ='未完成'
and ISNULL (CheckTime ,'') !=''
and OdersType in ('加急订单','正常订单')", drpOrdersNumber, "OdersNumber", "customerordernumber", existNumbers);
break;
case "包装出库":
documentName = "销售订单";
ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易'
and OrderStatus ='未完成'
and ISNULL (CheckTime ,'') !=''
and OdersType in ('加急订单','正常订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers);
break;
case "维修出库": documentName = "维修订单";
ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易'
and OrderStatus ='未完成'
and ISNULL (CheckTime ,'') !=''
and OdersType in ('维修订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers);
break;
case "样品出库":
documentName = "样品订单";
ControlBindManager.BindListBox(@"select OdersNumber from SaleOder where ProductType ='贸易'
and OrderStatus ='未完成'
and ISNULL (CheckTime ,'') !=''
and OdersType in ('样品订单')", drpOrdersNumber, "OdersNumber", "OdersNumber", existNumbers);
break;
case "生产退料入库":
documentName = "开工单号";
break;
case "生产出库":
documentName = "开工单号";
break;
}
}
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;
}
}
}
