protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//divAdd.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Add");
//divDelete.Visible = ToolCode.Tool.GetUserMenuFunc("L0301", "Delete");
if (!ToolManager.CheckQueryString("Id"))
{
Response.Write("请选择原材料！");
Response.End();
return;
}
string error = string.Empty;
string sql = " select * from MarerialInfoTable where materialnumber='" + ToolManager.GetQueryString("Id") + "'";
DataTable dt = DAL.SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count <= 0)
{
Response.Write("已删除该原材料编号！请刷新后重新选择原材料！");
Response.End();
return;
}
//删除
if (ToolManager.CheckQueryString("ids"))
{
string temp = MaterialCustomerPropertyManager.DeleteData(ToolManager.GetQueryString("ids"));
string id = ToolManager.GetQueryString("Id");
bool restult = temp == "1" ? true : false;
if (restult)
{
Tool.WriteLog(Tool.LogType.Operating, "删除原材料客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除成功");
Response.Write(temp);
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "删除原材料客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除失败！原因" + temp);
Response.Write(temp);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPageMaterialCustomer("AddOrEditMaterialCustomerProperty.aspx", "btnSearch", "260", "600");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!ToolManager.CheckQueryString("id"))
{
Response.Write("请选择包编码！");
Response.End();
return;
}
string error = string.Empty;
string sql = " select * from PackageInfo where PackageNumber='" + ToolManager.GetQueryString("id") + "'";
DataTable dt = DAL.SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count <= 0)
{
Response.Write("已删除该包编码！请刷新后重新选择包编码！");
Response.End();
return;
}
//删除
if (ToolManager.CheckQueryString("ids"))
{
string id = ToolManager.GetQueryString("id");
string temp = MaterialCustomerPropertyManager.Delete(id, ToolManager.GetQueryString("ids"));
bool restult = temp == "1" ? true : false;
if (restult)
{
Tool.WriteLog(Tool.LogType.Operating, "删除包客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除成功");
Response.Write(temp);
Response.End();
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "删除包客户信息" + ToolManager.ReplaceSingleQuotesToBlank(id), "删除失败！原因" + temp);
Response.Write(temp);
Response.End();
return;
}
}
//查询
if (ToolManager.CheckQueryString("pageIndex"))
{
GetPageMaterialCustomer("AddOrEditPackageInfoCustomerProperty.aspx", "btnSearch", "260", "600");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Check();
HasOdersNumber();
string error = string.Empty;
string sql = string.Empty;
DataTable dt;
string OdersNumber = ToolManager.GetQueryString("OdersNumber");
string sn = txtSN.Text.Trim();
string productNumber = string.Empty;
//string customerMareial = txtCustomerMarerial.SelectedValue;
string customerMareial = txtUniversalNumber.Text;
//string productModel = txtProductModel.Text.Trim();
string rowNumber = txtRowNumber.Text.Trim();
string quantity = Request.Form["txtQuantity"].ToString();
int qty = string.IsNullOrEmpty(quantity) ? 0 : Convert.ToInt32(quantity);
string unitPrice = txtUnitPrice.Text;
decimal uprice = string.IsNullOrEmpty(unitPrice) ? 0 : Convert.ToDecimal(unitPrice);
string delivery = txtDelivery.Text.Trim();
string remark = txtRemark.Text.Trim();
string receiveone = txtReceiveOne.Text.Trim().Equals("") ? "0" : txtReceiveOne.Text.Trim();
string receivetwo = txtReceiveTwo.Text.Trim().Equals("") ? "0" : txtReceiveTwo.Text.Trim();
bool result = false;
decimal totalPrice = 0;
try
{
Convert.ToDouble(receiveone);
Convert.ToDouble(receivetwo);
}
catch (Exception ex)
{
lbSubmit.Text = "收款一和收款二都必须输入整数或小数！";
return;
}
if (btnSubmit.Text.Equals("添加"))
{
if (HasDbRowNumber(OdersNumber, rowNumber))
{
lbSubmit.Text = "已有此行号请重新填写,行号在整个订单内不能重复";
//BindCustomer(productNumber, customerMareial);
return;
}
if (drpType.SelectedValue == "供应商物料编号")
{
sql = string.Format(@"select top 1 MaterialNumber from MaterialSupplierProperty where SupplierMaterialNumber='{0}'", txtUniversalNumber.Text.Trim());
if (SqlHelper.GetScalar(sql).Equals(""))
{
lbSubmit.Text = "未知的供应商物料编号！";
return;
}
else
{
productNumber = SqlHelper.GetScalar(sql);
}
}
if (drpType.SelectedValue == "客户物料编号")
{
string mNumber = MaterialCustomerPropertyManager.GetMaterialNumberByOderNumberAndCustomerMN(
txtUniversalNumber.Text.Trim(), OdersNumber);
//sql = string.Format(@"select top 1 MaterialNumber from MaterialCustomerProperty where CustomerMaterialNumber='{0}'", txtUniversalNumber.Text.Trim());
if (string.IsNullOrEmpty(mNumber))
{
lbSubmit.Text = "未知的客户物料编号！";
return;
}
else
{
productNumber = mNumber;
}
}
if (drpType.SelectedValue == "瑞普迪编号")
{
sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where MaterialNumber='{0}'", txtUniversalNumber.Text.Trim());
if (SqlHelper.GetScalar(sql).Equals(""))
{
lbSubmit.Text = "未知的瑞普迪编号！";
return;
}
else
{
productNumber = SqlHelper.GetScalar(sql);
}
}
if (drpType.SelectedValue == "物料描述")
{
sql = string.Format(@"select top 1 MaterialNumber from MarerialInfoTable where Description='{0}'", txtUniversalNumber.Text.Trim());
if (SqlHelper.GetScalar(sql).Equals(""))
{
lbSubmit.Text = "未知的物料描述！";
return;
}
else
{
productNumber = SqlHelper.GetScalar(sql);
}
}
sql = string.Format(@"select Description,Brand from MarerialInfoTable where MaterialNumber='{0}'", productNumber);
dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
brand = dt.Rows[0]["Brand"].ToString();
description = dt.Rows[0]["Description"].ToString();
}
sql = string.Format(@"select * from [V_FindPriceForNewForTrading]
where 原材料编号='{0}' and 客户编号=( select CustomerId from SaleOder where OdersNumber='{1}')", productNumber, OdersNumber);
dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
sql = string.Format(@"select 单价 from V_FindLastNewPriceForTradingQuoteDetail
where 原材料编号='{0}' and customerId=( select CustomerId from SaleOder where OdersNumber='{1}')", productNumber, OdersNumber);
unitPrice = SqlHelper.GetScalar(sql);
qty = string.IsNullOrEmpty(quantity) ? 0 : Convert.ToInt32(quantity);
txtUnitPrice.Text = unitPrice;
uprice = string.IsNullOrEmpty(unitPrice) ? 0 : Convert.ToDecimal(unitPrice);
totalPrice = qty * uprice;
}
sql = string.Format(@"
select * from TradingOrderDetail where OdersNumber ='{0}' and ProductNumber='{1}' and RowNumber='{2}'", OdersNumber, productNumber, rowNumber);
dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
lbSubmit.Text = "已有此记录请重新填写！";
//BindCustomer(productNumber, customerMareial);
return;
}
sql = string.Format(@" insert into TradingOrderDetail (OdersNumber,SN,ProductNumber,RowNumber ,CustomerMaterialNumber,MaterialName
,Brand,Quantity,NonDeliveryQty,DeliveryQty,UnitPrice,TotalPrice,Delivery,CreateTime,Remark,ReceiveOne,ReceiveTwo)
values('{0}',{1},'{2}','{3}','{4}','{5}','{6}',{7},{8},{9},{10},{11},'{12}','{13}','{14}','{15}','{16}')"
, OdersNumber, sn, productNumber, rowNumber, customerMareial, description, brand, qty, qty, 0
, uprice, totalPrice, delivery, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), remark, receiveone, receivetwo);
result = SqlHelper.ExecuteSql(sql, ref error);
lbSubmit.Text = result == true ? "添加成功！" : "添加失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "增加贸易销售订单明细" + OdersNumber, "增加成功");
//BindCustomer(productNumber, customerMareial);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "增加贸易销售订单明细" + OdersNumber, "增加失败！原因" + error);
//BindCustomer(productNumber, customerMareial);
return;
}
}
else
{
HasDeleted();
unitPrice = txtUnitPrice.Text.Trim();
totalPrice = qty * uprice;
string rownumber = ToolManager.GetQueryString("RowNumber");
sql = string.Format(@"
select * from TradingOrderDetail where OdersNumber ='{0}' and ProductNumber='{1}' and rownumber='{2}' and rownumber!='{3}'", OdersNumber, productNumber, delivery, rownumber);
dt = SqlHelper.GetTable(sql, ref error);
if (dt.Rows.Count > 0)
{
lbSubmit.Text = "已有此记录请重新填写！";
//BindCustomer(productNumber, customerMareial);
return;
}
sql = string.Format(@" update TradingOrderDetail set SN={0},
Quantity={1},NonDeliveryQty={2},UnitPrice={3},TotalPrice ={4}
,Delivery='{5}',Remark ='{6}',ReceiveOne='{10}',ReceiveTwo='{11}' where OdersNumber ='{7}' and RowNumber='{8}' and ProductNumber='{9}' ", sn,
qty, qty, uprice, totalPrice, delivery, remark, lblOdersNumber.Text, rownumber, txtMarerial.Text, receiveone, receivetwo);
result = SqlHelper.ExecuteSql(sql, ref error);
lbSubmit.Text = result == true ? "修改成功！" : "修改失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑贸易销售订单明细" + lblOdersNumber.Text, "编辑成功");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑贸易销售订单明细" + lblOdersNumber.Text, "编辑失败！原因" + error);
//BindCustomer(productNumber, customerMareial);
return;
}
}
}
private DataTable GetTable()
{
Dictionary <string, Dictionary <string, string> > marerialCustomerNames = MaterialCustomerPropertyManager.GetMarerialCustomerNames();
DataTable dtResult = SqlHelper.GetTable(GetSql());
dtResult.Columns.Add("CustomerNames");
foreach (DataRow dr in dtResult.Rows)
{
if (marerialCustomerNames.ContainsKey(dr["原材料编号"].ToString().Trim()))
{
dr["CustomerNames"] = GetCustomerNames(marerialCustomerNames, dr["原材料编号"].ToString().Trim());;
}
}
string customerName = txtCustomerName.Text.Trim();
if (!string.IsNullOrEmpty(customerName))
{
DataRow[] tempRows = dtResult.Select("CustomerNames like '%" + customerName + "%'");
if (tempRows != null && tempRows.Length > 0)
{
dtResult = tempRows.CopyToDataTable <DataRow>();
}
else
{
dtResult.Rows.Clear();
}
}
if (dtResult != null && dtResult.Rows != null && dtResult.Rows.Count > 0)
{
double sumStockQty = Convert.ToDouble(dtResult.Compute("sum(库存数量)", "true"));
double sumStockPrice = Convert.ToDouble(dtResult.Compute("sum(库存金额)", "true"));
DataRow sumRow = dtResult.NewRow();
sumRow["库存数量"] = sumStockQty;
sumRow["库存金额"] = sumStockPrice;
dtResult.Rows.Add(sumRow);
}
return(dtResult);
}
