protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["CMD_WH_AREA_ID"] != null)
{
dtArea = bll.FillDataTable("Cmd.SelectArea", new DataParameter[] { new DataParameter("{0}", "AreaCode='" + Request.QueryString["CMD_WH_AREA_ID"] + "'") });
if (this.dtArea.Rows.Count > 0)
{
this.txtWHID.Text = dtArea.Rows[0]["WarehouseCode"].ToString();
this.txtAreaID.Text = dtArea.Rows[0]["AreaCode"].ToString();
this.txtWhName.Text = bll.GetFieldValue("CMD_Warehouse", "WarehouseName", "WarehouseCode='" + this.txtWHID.Text + "'");
this.txtAreaCode.Text = dtArea.Rows[0]["AreaCode"].ToString();
this.txtAreaName.Text = dtArea.Rows[0]["AreaName"].ToString();
this.txtMemo.Text = dtArea.Rows[0]["MEMO"].ToString();
}
}
else if (Request.QueryString["WHCODE"] != null)
{
this.txtWHID.Text = Request.QueryString["WHCODE"];
this.txtWhName.Text = bll.GetFieldValue("CMD_Warehouse", "WarehouseName", "WarehouseCode='" + this.txtWHID.Text + "'");
this.txtAreaID.Text = "";
this.txtAreaCode.Text = bll.GetNewID("CMD_Area", "AreaCode", "1=1");
}
SetTextReadOnly(this.txtAreaCode, this.txtWhName, this.txtWHID);
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindDropDownList();
if (Request.QueryString["CMD_CELL_ID"] != null)
{
dtCell = bll.FillDataTable("Cmd.SelectCell", new DataParameter[] { new DataParameter("{0}", "CellCode='" + Request.QueryString["CMD_CELL_ID"] + "'") });
this.txtCELLID.Text = dtCell.Rows[0]["CellCode"].ToString();
this.txtShelfID.Text = dtCell.Rows[0]["ShelfCode"].ToString();
this.txtAreaID.Text = dtCell.Rows[0]["AreaCode"].ToString();
this.txtShelfName.Text = bll.GetFieldValue("CMD_Shelf", "ShelfName", "ShelfCode='" + this.txtShelfID.Text + "'");
ddlAreaCode.SelectedValue = this.txtAreaID.Text;
this.txtCellCode.Text = dtCell.Rows[0]["CellCode"].ToString();
this.txtCellName.Text = dtCell.Rows[0]["CellName"].ToString();
this.ddlActive.SelectedValue = dtCell.Rows[0]["IsActive"].ToString();
this.txtCellRows.Text = dtCell.Rows[0]["CellRow"].ToString();
this.txtCellCols.Text = dtCell.Rows[0]["CellColumn"].ToString();
this.ddlLock.SelectedValue = dtCell.Rows[0]["IsLock"].ToString();
this.txtMemo.Text = dtCell.Rows[0]["MEMO"].ToString();
int count = bll.GetRowCount("View_CMD_CELL_ALL", "CellCode='" + this.txtCELLID.Text + "' and PalletCode!=''");
if (count > 0)
{
this.btnSave.Enabled = false;
}
}
else if (Request.QueryString["SHELFCODE"] != null)
{
this.txtShelfID.Text = Request.QueryString["SHELFCODE"];
this.txtAreaID.Text = bll.GetFieldValue("CMD_Shelf", "AreaCode", "ShelfCode='" + this.txtShelfID.Text + "'");
this.txtShelfName.Text = bll.GetFieldValue("CMD_Shelf", "ShelfName", "ShelfCode='" + this.txtShelfID.Text + "'");
this.ddlAreaCode.SelectedValue = this.txtAreaID.Text;
int RowCount = bll.GetRowCount("CMD_WH_CELL", string.Format("SHELF_CODE='{0}'", Request.QueryString["SHELFCODE"])) + 1;
this.txtCellCode.Text = Request.QueryString["SHELFCODE"] + RowCount.ToString().PadLeft(3, '0');
this.txtCellCols.Text = RowCount.ToString();
this.txtCELLID.Text = "";
//this.txtEGroup.Text = "0";
//this.txtECom.Text = "0";
//this.txtEAddress.Text = "0";
}
SetTextReadOnly(this.txtCellName, this.txtCellCode, this.txtShelfName, this.txtCellCols, this.txtCellRows);
}
else
{
}
}
protected void btnCheck_Click(object sender, EventArgs e)
{
DataParameter[] paras = new DataParameter[4];
if (this.btnCheck.Text == "审核")
{
paras[0] = new DataParameter("@Checker", Session["EmployeeCode"].ToString());
paras[1] = new DataParameter("{0}", "getdate()");
paras[2] = new DataParameter("@State", 1);
}
else
{
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State > 1)
{
JScript.Instance.ShowMessage(this.updatePanel, this.txtID.Text + " 单号已经作业，不能进行反审。");
return;
}
paras[0] = new DataParameter("@Checker", "");
paras[1] = new DataParameter("{0}", "null");
paras[2] = new DataParameter("@State", 0);
}
paras[3] = new DataParameter("@BillID", this.txtID.Text);
bll.ExecNonQuery("WMS.UpdateCheckBillMaster", paras);
AddOperateLog("入库单 ", btnCheck.Text + " " + txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
protected void btnUnTask_Click(object sender, EventArgs e)
{
BLL.BLLBase bll = new BLL.BLLBase();
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State < 2)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号还未作业，不能进行取消作业。");
return;
}
if (State > 2)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + "单号已经执行，不能再进行取消作业。");
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpCancelOutStockTask", new DataParameter[] { new DataParameter("@BillID", strID), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("入库单", "入库取消作业单号：" + this.txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
catch (Exception ex)
{
JScript.ShowMessage(this.updatePanel, ex.Message);
}
}
protected void btnCheck_Click(object sender, EventArgs e)
{
List <string> Comd = new List <string>();
Comd.Insert(0, "WMS.UpdateMoveCellLock");
Comd.Insert(1, "WMS.UpdateCellLock");
Comd.Insert(2, "WMS.UpdateCheckBillMaster");
List <DataParameter[]> paras = new List <DataParameter[]>();
if (this.btnCheck.Text == "审核")
{
DataTable dtSub = (DataTable)ViewState[FormID + "_View_dgViewSub1"];
for (int i = 0; i < dtSub.Rows.Count; i++)
{
int count = 0;
count = bll.GetRowCount("Cmd_Cell", string.Format("CellCode='{0}' and (IsLock=1 or ProductCode!='{1}')", dtSub.Rows[i]["CellCode"], dtSub.Rows[i]["ProductCode"]));
if (count > 0)
{
JScript.ShowMessage(this.updatePanel, "货位 " + dtSub.Rows[i]["CellCode"].ToString() + "已经被其它单据锁定，不能移库！");
return;
}
count = bll.GetRowCount("Cmd_Cell", string.Format("CellCode='{0}' and (IsLock=1 or IsActive=0)", dtSub.Rows[i]["NewCellCode"]));
if (count > 0)
{
JScript.ShowMessage(this.updatePanel, "货位 " + dtSub.Rows[i]["NewCellCode"].ToString() + "已经被其它单据锁定，不能移库！");
return;
}
}
paras.Insert(0, new DataParameter[] { new DataParameter("@Lock", 1), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(1, new DataParameter[] { new DataParameter("@Lock", 1), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(2, new DataParameter[] { new DataParameter("@Checker", Session["EmployeeCode"].ToString()), new DataParameter("{0}", "getdate()"),
new DataParameter("@State", 1), new DataParameter("@BillID", this.txtID.Text) });
}
else
{
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", this.txtID.Text)));
if (State > 1)
{
JScript.ShowMessage(this.updatePanel, this.txtID.Text + " 单号已经作业，不能进行反审。");
return;
}
paras.Insert(0, new DataParameter[] { new DataParameter("@Lock", 0), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(1, new DataParameter[] { new DataParameter("@Lock", 0), new DataParameter("{0}", string.Format("BillID='{0}'", this.txtID.Text.Trim())) });
paras.Insert(2, new DataParameter[] { new DataParameter("@Checker", ""), new DataParameter("{0}", "null"),
new DataParameter("@State", 0), new DataParameter("@BillID", this.txtID.Text) });
}
bll.ExecTran(Comd.ToArray(), paras);
AddOperateLog("移库单 ", btnCheck.Text + " " + txtID.Text);
DataTable dt = bll.FillDataTable("WMS.SelectBillMaster", new DataParameter[] { new DataParameter("{0}", string.Format("BillID='{0}'", strID)) });
BindData(dt);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strColorCode = "'-1',";
BLL.BLLBase bll = new BLL.BLLBase();
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect"));
if (cb != null && cb.Checked)
{
string hk = this.GridView1.Rows[i].Cells[1].Text;
//判断能否删除
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", hk)));
if (State == 0)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号还未审核不能作业，请审核后，再进行盘库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
if (State > 1)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号已经作业，不能再进行盘库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
strColorCode += "'" + hk + "',";
}
}
strColorCode += "'-1'";
if (strColorCode.Replace("'-1','-1'", "").Trim().Length == 0)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, "请选择单据！");
SetGridViewEmptyRow(GridView1, (DataTable)ViewState[FormID + "_MainFormData"]);
BindDataSub(this.hdnRowValue.Value);
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpInventoryStockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("盘库单", "盘库作业单号：" + strColorCode.Replace("'-1',", "").Replace(",'-1'", ""));
DataTable dt = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
SetBindDataSub(dt);
}
catch (Exception ex)
{
BindDataSub(this.hdnRowValue.Value);
JScript.Instance.ShowMessage(this.UpdatePanel1, ex.Message);
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strColorCode = "'-1',";
BLL.BLLBase bll = new BLL.BLLBase();
for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
CheckBox cb = (CheckBox)(this.GridView1.Rows[i].FindControl("cbSelect"));
if (cb != null && cb.Checked)
{
string hk = this.GridView1.Rows[i].Cells[1].Text;
//判断能否删除
int State = int.Parse(bll.GetFieldValue("WMS_BillMaster", "State", string.Format("BillID='{0}'", hk)));
if (State == 0)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号还未审核不能作业，请审核后，再进行入库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
if (State > 1)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, GridView1.Rows[i].Cells[2].Text + "单号已经作业，不能再进行入库作业。");
BindDataSub(this.hdnRowValue.Value);
return;
}
strColorCode += "'" + hk + "',";
}
}
strColorCode += "'-1'";
if (strColorCode.Replace("'-1','-1'", "").Trim().Length == 0)
{
JScript.Instance.ShowMessage(this.UpdatePanel1, "请选择单据！");
SetGridViewEmptyRow(GridView1, (DataTable)ViewState[FormID + "_MainFormData"]);
BindDataSub(this.hdnRowValue.Value);
return;
}
try
{
bll.ExecNonQueryTran("WMS.SpInstockTask", new DataParameter[] { new DataParameter("@strWhere", strColorCode), new DataParameter("@UserName", Session["EmployeeCode"].ToString()) });
AddOperateLog("入库单", "入库作业单号：" + strColorCode.Replace("'-1',", "").Replace(",'-1'", ""));
DataTable dt = SetBtnEnabled(int.Parse(ViewState["CurrentPage"].ToString()), SqlCmd, ViewState["filter"].ToString(), pageSize, GridView1, btnFirst, btnPre, btnNext, btnLast, btnToPage, lblCurrentPage, this.UpdatePanel1);
SetBindDataSub(dt);
}
catch (Exception ex)
{
BindDataSub(this.hdnRowValue.Value);
JScript.Instance.ShowMessage(this.UpdatePanel1, ex.Message);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["CMD_WH_SHELF_ID"] != null)
{
dtShelf = bll.FillDataTable("Cmd.SelectCellShelf", new DataParameter[] { new DataParameter("{0}", " ShelfCode='" + Request.QueryString["CMD_WH_SHELF_ID"] + "'") });
this.txtShelfID.Text = dtShelf.Rows[0]["ShelfCode"].ToString();
this.txtWHID.Text = dtShelf.Rows[0]["WarehouseCode"].ToString();
this.txtWhName.Text = bll.GetFieldValue("CMD_Warehouse", "WarehouseName", "WarehouseCode='" + this.txtWHID.Text + "'");
this.txtAreaID.Text = dtShelf.Rows[0]["AreaCode"].ToString();
this.txtShelfCode.Text = dtShelf.Rows[0]["ShelfCode"].ToString();
this.txtShelfName.Text = dtShelf.Rows[0]["ShelfName"].ToString();
this.txtCellRows.Text = dtShelf.Rows[0]["Rows"].ToString();
this.txtCellCols.Text = dtShelf.Rows[0]["Columns"].ToString();
this.txtMemo.Text = dtShelf.Rows[0]["MEMO"].ToString();
this.ddlActive.SelectedValue = dtShelf.Rows[0]["IsActive"].ToString();
}
else if (Request.QueryString["AREACODE"] != null)
{
this.txtAreaID.Text = Request.QueryString["AREACODE"];
this.txtWHID.Text = bll.GetFieldValue("CMD_Area", "WarehouseCode", "AreaCode='" + this.txtAreaID.Text + "'");
this.txtWhName.Text = bll.GetFieldValue("CMD_Warehouse", "WarehouseName", "WarehouseCode='" + this.txtWHID.Text + "'");
this.txtShelfID.Text = "";
int RowCount = bll.GetRowCount("CMD_WH_SHELF", string.Format("AREA_CODE='{0}'", Request.QueryString["AREACODE"])) + 1;
this.txtShelfCode.Text = Request.QueryString["AREACODE"] + RowCount.ToString().PadLeft(3, '0');
}
SetTextReadOnly(txtShelfCode, this.txtWhName, this.txtCellCols, this.txtCellRows);
}
}
private void BindDropDownList()
{
this.txtProductCode.Text = strID;
this.txtProductName.Text = bll.GetFieldValue("CMD_Product", "ProductName", "ProductCode='" + strID + "'");
this.hdnArea.Value = bll.GetFieldValue("CMD_Product", "AreaCode", "ProductCode='" + strID + "'");
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (strID == "") //新增
{
int Count = bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
if (Count > 0)
{
JScript.ShowMessage(this.Page, "该产品编号已经存在！");
return;
}
//判断车型，轮对轴号 是否重复
//Count=bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
//if (Count > 0)
//{
// WMS.App_Code.JScript.ShowMessage(this.Page, "该产品编号已经存在！");
// return;
//}
//, , , , , , , , , ,
// , , , , , , , , , , ,
// , , , , Creator, CreateDate, Updater, UpdateDate, ,
bll.ExecNonQuery("Cmd.InsertProduct", new DataParameter[] {
new DataParameter("@ProductCode", this.txtID.Text.Trim()),
new DataParameter("@ProductName", this.txtProductName.Text.Trim()),
new DataParameter("@CategoryCode", this.ddlCategoryCode.SelectedValue),
new DataParameter("@ProductEName", this.txtProductEName.Text),
new DataParameter("@FactoryID", this.ddlFactory.SelectedValue),
new DataParameter("@ModelNo", this.txtModelNo.Text.Trim()),
new DataParameter("@Spec", this.txtSpec.Text.Trim()),
new DataParameter("@Barcode", this.txtBarcode.Text.Trim()),
new DataParameter("@Propertity", this.txtPropertity.Text.Trim()),
new DataParameter("@Unit", this.txtUnit.Text.Trim()),
new DataParameter("@Length", this.txtLength.Text.Trim()),
new DataParameter("@Width", this.txtWidth.Text.Trim()),
new DataParameter("@Height", this.txtHeight.Text.Trim()),
new DataParameter("@Material", this.txtMaterial.Text.Trim()),
new DataParameter("@Weight", this.txtWeight.Text.Trim()),
new DataParameter("@Color", this.txtColor.Text.Trim()),
new DataParameter("@StandardNo", this.txtStandardNo.Text.Trim()),
new DataParameter("@PartNo", this.txtPartNo.Text.Trim()),
new DataParameter("@ValidPeriod", this.txtValidPeriod.Text.Trim()),
new DataParameter("@Description", this.txtDescription.Text.Trim()),
new DataParameter("@AreaCode", bll.GetFieldValue("CMD_ProductCategory", "AreaCode", "CategoryCode='" + this.ddlCategoryCode.SelectedValue + "'")),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
});
}
else //修改
{
//判断车型，轮对轴号 是否重复
//int Count = bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
//if (Count > 0)
//{
// WMS.App_Code.JScript.ShowMessage(this.Page, "该产品编号已经存在！");
// return;
//}
bll.ExecNonQuery("Cmd.UpdateProduct", new DataParameter[] {
new DataParameter("@ProductName", this.txtProductName.Text.Trim()),
new DataParameter("@CategoryCode", this.ddlCategoryCode.SelectedValue),
new DataParameter("@ProductEName", this.txtProductEName.Text),
new DataParameter("@FactoryID", this.ddlFactory.SelectedValue),
new DataParameter("@ModelNo", this.txtModelNo.Text.Trim()),
new DataParameter("@Spec", this.txtSpec.Text.Trim()),
new DataParameter("@Barcode", this.txtBarcode.Text.Trim()),
new DataParameter("@Propertity", this.txtPropertity.Text.Trim()),
new DataParameter("@Unit", this.txtUnit.Text.Trim()),
new DataParameter("@Length", this.txtLength.Text.Trim()),
new DataParameter("@Width", this.txtWidth.Text.Trim()),
new DataParameter("@Height", this.txtHeight.Text.Trim()),
new DataParameter("@Material", this.txtMaterial.Text.Trim()),
new DataParameter("@Weight", this.txtWeight.Text.Trim()),
new DataParameter("@Color", this.txtColor.Text.Trim()),
new DataParameter("@StandardNo", this.txtStandardNo.Text.Trim()),
new DataParameter("@PartNo", this.txtPartNo.Text.Trim()),
new DataParameter("@ValidPeriod", this.txtValidPeriod.Text.Trim()),
new DataParameter("@Description", this.txtDescription.Text.Trim()),
new DataParameter("@AreaCode", bll.GetFieldValue("CMD_ProductCategory", "AreaCode", "CategoryCode='" + this.ddlCategoryCode.SelectedValue + "'")),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("@ProductCode", this.txtID.Text.Trim())
});
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (strID == "") //新增
{
int Count = bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
if (Count > 0)
{
JScript.Instance.ShowMessage(this.Page, "该产品编号已经存在！");
return;
}
//判断车型，轮对轴号 是否重复
//Count=bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
//if (Count > 0)
//{
// WMS.App_Code.JScript.Instance.ShowMessage(this.Page, "该产品编号已经存在！");
// return;
//}
//, , , , , , , , , ,
// , , , , , , , , , , ,
// , , , , Creator, CreateDate, Updater, UpdateDate, ,
bll.ExecNonQuery("Cmd.InsertProduct", new DataParameter[] {
new DataParameter("@ProductCode", this.txtID.Text.Trim()),
new DataParameter("@ProductName", this.txtProductName.Text.Trim()),
new DataParameter("@ProductTypeCode", this.ddlProductTypeCode.SelectedValue),
new DataParameter("@TrainTypeCode", ""),
new DataParameter("@AxieNo", this.txtAxieNo.Text.Trim()),
new DataParameter("@WheelDiameter", this.txtWheelDiameter.Text.Trim()),
new DataParameter("@CCZ_Diameter", this.txtCCZ_Diameter.Text.Trim()),
new DataParameter("@FCCZ_Diameter", this.txtFCCZ_Diameter.Text.Trim()),
new DataParameter("@CCD_Diameter", this.txtCCD_Diameter.Text.Trim()),
new DataParameter("@FCCD_Diameter", this.txtFCCD_Diameter.Text.Trim()),
new DataParameter("@CCXPBZW_Size", this.txtCCXPBZW_Size.Text.Trim()),
new DataParameter("@FCCXPBZW_Size", this.txtFCCXPBZW_Size.Text.Trim()),
new DataParameter("@GearNo", this.txtGearNo.Text.Trim()),
new DataParameter("@CCLX_Flag", this.txtCCLX_Flag.Text.Trim()),
new DataParameter("@FCCLX_Flag", this.txtFCCLX_Flag.Text.Trim()),
new DataParameter("@CCLX_Year", this.txtCCLX_Year.Text.Trim()),
new DataParameter("@FCCLX_Year", this.txtFCCLX_Year.Text.Trim()),
new DataParameter("@CCLX_Factory", ""),
new DataParameter("@FCCLX_Factory", ""),
new DataParameter("@CX_Factory", this.ddlCX_Factory.SelectedValue),
new DataParameter("@CCLG_Flag", this.txtCCLG_Flag.Text.Trim()),
new DataParameter("@FCCLG_Flag", ""),
new DataParameter("@WarehouseCode", ""),
new DataParameter("@AreaCode", bll.GetFieldValue("CMD_ProductType", "AreaCode", "ProductTypeCode='" + this.ddlProductTypeCode.SelectedValue + "'")),
new DataParameter("@LDXC", this.txtLDXC.Text.Trim()),
new DataParameter("@CX_DateTime", this.txtCX_DateTime.DateValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("@IsTemp", chkTemp.Checked ? "1" :"0")
});
}
else //修改
{
//判断车型，轮对轴号 是否重复
//int Count = bll.GetRowCount("CMD_Product", string.Format("ProductCode='{0}'", this.txtID.Text));
//if (Count > 0)
//{
// WMS.App_Code.JScript.Instance.ShowMessage(this.Page, "该产品编号已经存在！");
// return;
//}
bll.ExecNonQuery("Cmd.UpdateProduct", new DataParameter[] {
new DataParameter("@ProductName", this.txtProductName.Text.Trim()),
new DataParameter("@ProductTypeCode", this.ddlProductTypeCode.SelectedValue),
new DataParameter("@TrainTypeCode", ""),
new DataParameter("@AxieNo", this.txtAxieNo.Text.Trim()),
new DataParameter("@WheelDiameter", this.txtWheelDiameter.Text.Trim()),
new DataParameter("@CCZ_Diameter", this.txtCCZ_Diameter.Text.Trim()),
new DataParameter("@FCCZ_Diameter", this.txtFCCZ_Diameter.Text.Trim()),
new DataParameter("@CCD_Diameter", this.txtCCD_Diameter.Text.Trim()),
new DataParameter("@FCCD_Diameter", this.txtFCCD_Diameter.Text.Trim()),
new DataParameter("@CCXPBZW_Size", this.txtCCXPBZW_Size.Text.Trim()),
new DataParameter("@FCCXPBZW_Size", this.txtFCCXPBZW_Size.Text.Trim()),
new DataParameter("@GearNo", this.txtGearNo.Text.Trim()),
new DataParameter("@CCLX_Flag", this.txtCCLX_Flag.Text.Trim()),
new DataParameter("@FCCLX_Flag", this.txtFCCLX_Flag.Text.Trim()),
new DataParameter("@CCLX_Year", this.txtCCLX_Year.Text.Trim()),
new DataParameter("@FCCLX_Year", this.txtFCCLX_Year.Text.Trim()),
new DataParameter("@CCLX_Factory", ""),
new DataParameter("@FCCLX_Factory", ""),
new DataParameter("@CX_Factory", this.ddlCX_Factory.SelectedValue),
new DataParameter("@CCLG_Flag", this.txtCCLG_Flag.Text.Trim()),
new DataParameter("@FCCLG_Flag", ""),
new DataParameter("@WarehouseCode", ""),
new DataParameter("@AreaCode", bll.GetFieldValue("CMD_ProductType", "AreaCode", "ProductTypeCode='" + this.ddlProductTypeCode.SelectedValue + "'")),
new DataParameter("@IsTemp", chkTemp.Checked ? "1" :"0"),
new DataParameter("@LDXC", this.txtLDXC.Text.Trim()),
new DataParameter("@CX_DateTime", this.txtCX_DateTime.DateValue),
new DataParameter("@Memo", this.txtMemo.Text.Trim()),
new DataParameter("@Creator", Session["EmployeeCode"].ToString()),
new DataParameter("@Updater", Session["EmployeeCode"].ToString()),
new DataParameter("@ProductCode", this.txtID.Text.Trim())
});
}
Response.Redirect(FormID + "View.aspx?SubModuleCode=" + SubModuleCode + "&FormID=" + Server.UrlEncode(FormID) + "&SqlCmd=" + SqlCmd + "&ID=" + Server.UrlEncode(this.txtID.Text));
}
