private void onload()
{
string sql = string.Empty;
string error = string.Empty;
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select mt.MaterialNumber,mt.MaterialName,mt.Description,
mk.Kind,mt.Type,mt.Brand,mt.StockSafeQty,mt.ProcurementPrice,
(select WarehouseName from WarehouseInfo where WarehouseNumber=mt.MaterialPosition) as MaterialPosition,
mt.MinPacking,
mt.MinOrderQty,mt.ScrapPosition,mt.Remark
from MarerialInfoTable mt left join MarerialKind mk on mt.Kind=mk.Id where MaterialNumber='{0}' ", ToolManager.GetQueryString("Id"));
Model.MarerialInfoTable materialinfotable = MarerialInfoTableManager.ConvertDataTableToModel(sql);
this.lbMaterialNumber.InnerText = materialinfotable.MaterialNumber;
this.lbMaterialName.InnerText = materialinfotable.MaterialName;
this.lbDescription.InnerText = materialinfotable.Description;
this.lbKind.InnerText = materialinfotable.Kind;
this.lbType.InnerText = materialinfotable.Type;
this.lbBrand.InnerText = materialinfotable.Brand;
this.lbStockSafeQty.InnerText = materialinfotable.StockSafeQty.ToString();
this.lbProcurementPrice.InnerText = materialinfotable.ProcurementPrice.ToString();
this.lbMaterialPosition.InnerText = materialinfotable.MaterialPosition;
this.lbMinPacking.InnerText = materialinfotable.MinPacking;
this.lbMinOrderQty.InnerText = materialinfotable.MinOrderQty;
this.lbScrapPosition.InnerText = materialinfotable.ScrapPosition;
this.lbRemark.InnerText = materialinfotable.Remark;
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string error = string.Empty;
bool result = MarerialInfoTableManager.BatchAddMaterialInfo(FU_Excel, Server, ref error);
lbMsg.Text = result == true ? "导入成功！" : "导入失败！原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "导入原材料信息", "导入成功！");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "导入原材料信息", "导入失败！原因" + error);
return;
}
//DataSet ds = ToolManager.ImpExcel(this.FU_Excel, Server);
//if (ds == null)
//{
// lbMsg.Text = "选择的文件为空或不是标准的Excel文件！";
// return;
//}
//List<MarerialInfoTable> marerialinfotables = new List<MarerialInfoTable>();
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
//MarerialInfoTable marerialinfotable = new MarerialInfoTable();
//marerialinfotable.MaterialNumber = dr["原材料编号"] == null ? "" : dr["原材料编号"].ToString();
//marerialinfotable.MaterialName = dr["名称"] == null ? "" : dr["名称"].ToString();
//marerialinfotable.Description = dr["描述"]== null ? "" : dr["描述"].ToString();
//marerialinfotable.Type = dr["类别"] == null ? "" : dr["类别"].ToString();
//marerialinfotable.Brand = dr["品牌"] == null ? "" : dr["品牌"].ToString();
//if (dr["库存安全值"] == null)
//{
// marerialinfotable.StockSafeQty = 0;
//}
//else {
// marerialinfotable.StockSafeQty = Convert.ToInt32(dr["库存安全值"].ToString());
//}
//if (dr["采购价格"] == null )
//{
// marerialinfotable.ProcurementPrice = Convert.ToDecimal(0.00);
//}
//else
//{
// marerialinfotable.ProcurementPrice = Convert.ToDecimal(dr["采购价格"].ToString());
//}
//marerialinfotable.MaterialPosition = dr["原材料仓位"] == null ? "" : dr["原材料仓位"].ToString();
//marerialinfotable.MinPacking = dr["最小包装"] == null ? "" : dr["最小包装"].ToString();
//marerialinfotable.MinOrderQty = dr["最小起订量"] == null ? "" : dr["最小起订量"].ToString();
//marerialinfotable.ScrapPosition = dr["废品仓位"] == null ? "" : dr["废品仓位"].ToString();
//marerialinfotable.Remark = dr["备注"]== null ? "" : dr["备注"].ToString();
//marerialinfotables.Add(marerialinfotable);
//}
// bool result = MarerialInfoTableManager.BatchAddData(marerialinfotables, ref error);
}
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");
}
}
private void LoadPage()
{
string sql = string.Empty;
string error = string.Empty;
//MarerialInfoTableManager.BindKind(drpKind);
//ControlBindManager.BindDrp(" select type from MareriaType", drpType, "type", "type");
//MarerialInfoTableManager.BindWarehouseName(drpMaterialPosition);
if (ToolManager.CheckQueryString("Id"))
{
sql = string.Format(@" select * from MarerialInfoTable where MaterialNumber='{0}' ", Server.UrlDecode(ToolManager.GetQueryString("Id")));
//sql = string.Format(@" select * from MarerialInfoTable where MaterialNumber='{0}' ", "test2");
this.trMaterialNumber.Visible = false;
MarerialInfoTable marerialinfotable = MarerialInfoTableManager.ConvertDataTableToModel(sql);
this.txtMaterialNumber.Text = marerialinfotable.MaterialNumber;
this.txtMaterialName.Text = marerialinfotable.MaterialName;
this.txtDescription.Text = marerialinfotable.Description;
this.txtUnit.Text = marerialinfotable.Unit;
this.txtNumberProperties.Text = marerialinfotable.NumberProperties;
this.txtKind.Text = marerialinfotable.Kind;
this.txtType.Text = marerialinfotable.Type;
//MarerialInfoTableManager.BindType(drpKind, drpType);
//this.drpType.SelectedValue = marerialinfotable.Type;
this.txtBrand.Text = marerialinfotable.Brand;
//this.txtStockSafeQty.Text = marerialinfotable.StockSafeQty.ToString();
this.txtProcurementPrice.Text = marerialinfotable.ProcurementPrice.ToString();
this.drpMaterialPosition.SelectedValue = marerialinfotable.MaterialPosition;
this.txtMinPacking.Text = marerialinfotable.MinPacking;
this.txtMinOrderQty.Text = marerialinfotable.MinOrderQty;
this.drpScrapPosition.SelectedValue = marerialinfotable.ScrapPosition;
this.txtRemark.Text = marerialinfotable.Remark;
this.txtCargo.Text = marerialinfotable.Cargo;
this.txtCargoType.Text = marerialinfotable.CargoType;
btnSubmit.Text = "修改";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Regex r = new Regex(@"[\u4e00-\u9fa5]+");
Match mc = r.Match(txtMaterialNumber.Text.Trim());
if (mc.Length != 0)
{
lbSubmit.Text = "注意：原材料编号禁止输入中文";
lbSubmit.Focus();
return;
}
string error = string.Empty;
Model.MarerialInfoTable marerialinfotable = new MarerialInfoTable();
marerialinfotable.MaterialNumber = this.txtMaterialNumber.Text.Trim();
marerialinfotable.MaterialName = this.txtMaterialName.Text.Trim();
marerialinfotable.Description = this.txtDescription.Text.Trim();
marerialinfotable.Kind = this.txtKind.Text;
marerialinfotable.Type = this.txtType.Text;
marerialinfotable.Brand = this.txtBrand.Text.Trim();
marerialinfotable.Cargo = this.txtCargo.Text.Trim();
marerialinfotable.CargoType = this.txtCargoType.Text.Trim();
marerialinfotable.NumberProperties = this.txtNumberProperties.Text.Trim();
marerialinfotable.Unit = this.txtUnit.Text.Trim();
bool result = false;
//if (this.txtStockSafeQty.Text.Trim().Length > 0 && this.txtProcurementPrice.Text.Trim().Length > 0)
//{
// marerialinfotable.StockSafeQty = Convert.ToInt32(this.txtStockSafeQty.Text.Trim());
// marerialinfotable.ProcurementPrice = Convert.ToDecimal(this.txtProcurementPrice.Text.Trim());
//}
//else
//{
// lbSubmit.Text = "原材料信息不完整！";
// return;
//}
marerialinfotable.StockSafeQty = 0;
marerialinfotable.ProcurementPrice = Convert.ToDecimal(this.txtProcurementPrice.Text.Trim());
marerialinfotable.MaterialPosition = this.drpMaterialPosition.SelectedValue;
marerialinfotable.MinPacking = this.txtMinPacking.Text.Trim();
marerialinfotable.MinOrderQty = this.txtMinOrderQty.Text.Trim();
marerialinfotable.ScrapPosition = this.drpScrapPosition.SelectedValue.Trim();
marerialinfotable.Remark = this.txtRemark.Text.Trim();
if (btnSubmit.Text.Equals("添加"))
{
result = MarerialInfoTableManager.AddMarerialInfoTable(marerialinfotable, ref error);
lbSubmit.Text = result == true ? "添加成功！" : "添加失败，原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "增加原材料信息" + marerialinfotable.MaterialNumber, "增加成功");
ToolCode.Tool.ResetControl(this.Controls);
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "增加原材料信息" + marerialinfotable.MaterialNumber, "增加失败！原因" + error);
return;
}
}
else
{
result = MarerialInfoTableManager.EditMarerialInfoTable(marerialinfotable, ref error);
lbSubmit.Text = result == true ? "修改成功！" : "修改失败：原因：" + error;
if (result)
{
Tool.WriteLog(Tool.LogType.Operating, "编辑原材料信息" + marerialinfotable.MaterialNumber, "编辑成功");
return;
}
else
{
Tool.WriteLog(Tool.LogType.Operating, "编辑原材料信息" + marerialinfotable.MaterialNumber, "编辑失败！原因" + error);
return;
}
}
}
