/// <summary>下拉列表改变事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlPROD_NAME1_SelectedIndexChanged(object sender, EventArgs e)
{
// FineUI.DropDownList ddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList;
// string ttxtPROD_NAME1 = ddlPROD_NAME1.SelectedText;
// FineUI.TextBox txtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox;
// string ttxtPROD_ID = txtPROD_ID.Text;
txtPROD_ID.Text = ddlPROD_NAME1.SelectedValue;
var model = new PRODUCT00(x => x.PROD_ID == ddlPROD_NAME1.SelectedValue); // 读取商品主表
var model_0 = new PRODUCT01(x => x.PROD_ID == ddlPROD_NAME1.SelectedValue); //读商品子表
// FineUI.TextBox ttxtPROD_SPEC = Window2.FindControl("txtPROD_SPEC") as FineUI.TextBox;
txtPROD_SPEC.Text = model.PROD_SPEC;
// FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox;
txtPROD_UNIT.Text = model.PROD_UNIT;
// FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox;
txtU_Cost.Text = model_0.COST.ToString();
// FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox;
// txtOrder_QUAN.Text = model.Order_QUAN.ToString();
}
/// <summary>下拉列表改变事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ddlPROD_NAME1_SelectedIndexChanged(object sender, EventArgs e)
{
txtPROD_ID.Text = ddlPROD_NAME1.SelectedValue;
var model = new PRODUCT00(x => x.PROD_ID == ddlPROD_NAME1.SelectedValue); // 读取商品主表
var model_0 = new PRODUCT01(x => x.PROD_ID == ddlPROD_NAME1.SelectedValue); //读商品子表
txtPROD_SPEC.Text = model.PROD_SPEC;
txtPROD_UNIT.Text = model.PROD_UNIT;
txtU_Cost.Text = model_0.COST.ToString();
// txtOrder_QUAN.Text = model.Order_QUAN.ToString();
}
protected void ButtonOrderAdd_Click(Object sender, EventArgs e)
{
FineUI.Grid Grid4 = Window4.FindControl("PanelGrid5").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
tbxRELATE_ID.Text = Grid4.DataKeys[0][0].ToString();
foreach (int i in selections)
{
List <ConditionFun.SqlqueryCondition> order00con = new List <ConditionFun.SqlqueryCondition>();
order00con.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, OUT_BACK01Table.BK_ID, Comparison.Equals, Grid4.DataKeys[i][0].ToString(), false, false));
List <string> colList = new List <string>();
colList.Add("SHOP_ID");
colList.Add("PROD_ID");
colList.Add("QUANTITY");
colList.Add("STD_UNIT");
colList.Add("STD_CONVERT");
colList.Add("STD_QUAN");
colList.Add("STD_PRICE");
//colList.Add("COST_PRICE");
//colList.Add("");预留采购单位类别
DataTable da = OUT_BACK01Bll.GetInstence().GetDataTable(false, 0, colList, 0, 0, order00con, null);
foreach (DataRow dr in da.Rows)
{
string _shopid = dr["SHOP_ID"].ToString();
string _PROD_ID = dr["PROD_ID"].ToString();
var model = new SHOP00(x => x.SHOP_ID == _shopid);
var model2 = new PRODUCT00(x => x.PROD_ID == _PROD_ID);
int rowCount = Grid2.Rows.Count;
JObject deObject = new JObject();
deObject.Add("Id01", "0");
deObject.Add("SHOP_ID01", dr["SHOP_ID"].ToString());
deObject.Add("SHOP_NAME01", model.SHOP_NAME1);
deObject.Add("IB_ID01", tbxIB_ID.Text);
deObject.Add("SNo01", rowCount + 1);
deObject.Add("PROD_ID01", dr["PROD_ID"].ToString());
deObject.Add("PROD_NAME01", model2.PROD_NAME1);
deObject.Add("QUANTITY01", dr["QUANTITY"].ToString());
deObject.Add("STD_TYPE01", dr["STD_UNIT"].ToString());
deObject.Add("STD_UNIT01", dr["STD_UNIT"].ToString());
deObject.Add("STD_CONVERT01", dr["STD_CONVERT"].ToString());
deObject.Add("STD_QUAN01", dr["STD_QUAN"].ToString());
deObject.Add("STD_PRICE01", dr["STD_PRICE"].ToString());
deObject.Add("COST01", dr["STD_PRICE"].ToString());
deObject.Add("QUAN101", dr["STD_QUAN"].ToString());
deObject.Add("QUAN201", dr["STD_QUAN"].ToString());
deObject.Add("MEMO01", "");
deObject.Add("BAT_NO", "");
Grid2.AddNewRecord(deObject, true);
}
}
}
public void Prod_Edit(string SNos)
{
string id = SNos + "";
string order_id = hidId.Text;
if (id != "0")
{
int id_ = ConvertHelper.Cint0(SNos);
//读取资料
var model_0 = new ORDER00(x => x.ORDER_ID == order_id);
var model = new ORDER01(x => x.ORDER_ID == order_id && x.SNo == id_);
// model.SHOP_ID = model_0.SHOP_ID;//分店编号
// FineUI.DropDownList ddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList;
// FineUI.TextBox ttxtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox;
var model_ = new PRODUCT00(x => x.PROD_ID == model.PROD_ID); // 读取商品主表
var model_0_ = new PRODUCT01(x => x.PROD_ID == model.PROD_ID); //读商品子表
// FineUI.TextBox ttxtPROD_SPEC = Window2.FindControl("txtPROD_SPEC") as FineUI.TextBox;
// FineUI.TextBox ttxtON_QUAN = Window2.FindControl("txtON_QUAN") as FineUI.TextBox;
// FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox;
// FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox;
// FineUI.TextBox ttxtTotal = Window2.FindControl("txtTotal") as FineUI.TextBox;
// FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox;
// FineUI.TextBox ttxtMemo = Window2.FindControl("txtMemo") as FineUI.TextBox;
ddlPROD_NAME1.SelectedValue = model.PROD_ID + "";
// ddlPROD_NAME1.SelectedItem.Text = model_.PROD_NAME1;
txtPROD_SPEC.Text = model_.PROD_SPEC;
// txtOrder_QUAN.Text = model_.Order_QUAN.ToString();
txtPROD_ID.Text = model.PROD_ID;
txtON_QUAN.Text = ConvertHelper.Cint0(model.ON_QUAN.ToString()).ToString();
txtTotal.Text = model.QUAN1.ToString();
txtPROD_UNIT.Text = model.STD_UNIT;
txtU_Cost.Text = model.STD_PRICE.ToString();
txtMemo.Text = model.Memo;
}
}
/// <summary>
/// 读取某个固定字段的值
/// </summary>
/// <param name="conditionColName"></param>
/// <param name="value"></param>
/// <returns></returns>
public string GetModelSingleValue(string colunm, Expression <Func <PRODUCT00, bool> > expression)
{
string result = "";
try
{
var model = new PRODUCT00(expression);
switch (colunm)
{
case "PROD_ID": result = model.PROD_ID; break;
case "PROD_NAME1": result = model.PROD_NAME1.ToString(); break;
case "PROD_NAME2;": result = model.PROD_NAME2; break;
default: result = ""; break;
}
}
catch
{
result = "";
}
return(result);
}
/// <summary>
/// 更新
/// </summary>
/// <returns></returns>
public string Product00Update()
{
string result = "0";
string _id = GridViewHelper.GetSelectedKey(Grid1, true);
int id = ConvertHelper.Cint0(_id);
try
{
#region 数据验证
var sPROD_ID = PROD_ID.Text.Trim();
if (string.IsNullOrEmpty(PROD_ID.Text.Trim()))
{
PROD_ID.ShowRedStar = true;
return(PROD_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(PROD_NAME1.Text.Trim()))
{
return(PROD_NAME1.Label + "不能为空！");
}
var sPROD_KIND = PROD_KIND.SelectedValue;
if (string.IsNullOrEmpty(sPROD_KIND) || sPROD_KIND == "0")
{
return(PROD_KIND.Label + "不能为空！");
}
var sPROD_DEP = PROD_DEP.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP) || sPROD_DEP == "0")
{
return(PROD_DEP.Label + "不能为空！");
}
var sPROD_TYPE = PROD_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP))
{
return(PROD_TYPE.Label + "不能为空！");
}
var sPROD_Source = PROD_Source.SelectedValue;
if (string.IsNullOrEmpty(sPROD_Source))
{
return(PROD_Source.Label + "不能为空！");
}
var sINV_TYPE = INV_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sINV_TYPE) || sINV_TYPE == "0")
{
return(INV_TYPE.Label + "不能为空！");
}
var sSTOCK_TYPE = STOCK_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sSTOCK_TYPE) || sSTOCK_TYPE == "0")
{
return(STOCK_TYPE.Label + "不能为空！");
}
var sBOM_TYPE = BOM_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sBOM_TYPE) || sBOM_TYPE == "0")
{
return(BOM_TYPE.Label + "不能为空！");
}
var sMarginControl = MarginControl.SelectedValue;
if (string.IsNullOrEmpty(sMarginControl) || sMarginControl == "0")
{
return(MarginControl.Label + "不能为空！");
}
var sPROD_RangTYPE = PROD_RangTYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_RangTYPE) || sPROD_RangTYPE == "0")
{
return(PROD_RangTYPE.Label + "不能为空！");
}
var sPROD_iRang = PROD_iRang.Text;
if (string.IsNullOrEmpty(sPROD_iRang))
{
return(PROD_iRang.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_iRang))
{
return(PROD_iRang.Label + "必须为整数123！");
}
var sPROD_UNIT = PROD_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT) || sPROD_UNIT == "0")
{
return(PROD_UNIT.Label + "不能为空！");
}
var sPROD_CONVERT1 = PROD_CONVERT1.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "必须为整数！");
}
var sPROD_UNIT1 = PROD_UNIT1.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT1) || sPROD_UNIT1 == "0")
{
return("包装单位不能为空！");
}
var sPROD_CONVERT2 = PROD_CONVERT2.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "必须为整数！");
}
var sPROD_UNIT2 = PROD_UNIT2.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT2) || sPROD_UNIT2 == "0")
{
return("外箱单位不能为空！");
}
var sReport_UNIT = Report_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sReport_UNIT) || sReport_UNIT == "0")
{
return(Report_UNIT.Label + "不能为空！");
}
sPROD_ID = StringHelper.Left(sPROD_ID, 50);
if (!PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id != 0)
{
return(PROD_ID.Label + "不存在！请重新输入！");
}
string sPROD_NAME1 = PROD_NAME1.Text.Trim();
if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_NAME1 == sPROD_NAME1 && x.PROD_ID != sPROD_ID) && id != 0)
{
return(PROD_NAME1.Label + "与其他商品重复！请重新输入！");
}
#endregion
#region 赋值
var model = new PRODUCT00(x => x.PROD_ID == sPROD_ID);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
//if (model.PROD_ID == sPROD_ID)
//{
// model.SetIsNew(false);
//}
//else
//{
// model.SetIsNew(true);
//}
model.PROD_ID = sPROD_ID;
model.PROD_NAME1 = PROD_NAME1.Text;
model.PROD_NAME1_SPELLING = PROD_NAME1_SPELLING.Text;
model.PROD_NAME2 = PROD_NAME2.Text;
model.PROD_KIND = sPROD_KIND;
model.PROD_DEP = sPROD_DEP;
model.PROD_CATE = PROD_CATE.SelectedValue;
model.DIV_ID = DIV_ID.SelectedValue;
model.INV_TYPE = ConvertHelper.Cint(sINV_TYPE);
model.STOCK_TYPE = ConvertHelper.Cint(sSTOCK_TYPE);
model.BOM_TYPE = ConvertHelper.Cint(sBOM_TYPE);
model.MarginControl = ConvertHelper.Cint(sMarginControl);
model.PROD_RangTYPE = ConvertHelper.Cint(sPROD_RangTYPE);
model.PROD_iRang = ConvertHelper.Cint(sPROD_iRang);
model.PROD_SPEC = PROD_SPEC.Text;
model.PROD_Margin = PROD_Margin.Text;
model.PROD_BARCODE = PROD_BARCODE.Text;
model.PROD_UNIT = sPROD_UNIT;
model.PROD_UNIT1 = sPROD_UNIT1;
model.PROD_CONVERT1 = ConvertHelper.Cint(sPROD_CONVERT1);
model.PROD_UNIT2 = sPROD_UNIT2;
model.PROD_CONVERT2 = ConvertHelper.Cint(sPROD_CONVERT2);
model.Report_UNIT = ConvertHelper.Cint(sReport_UNIT);
model.PROD_MEMO = PROD_MEMO.Text;
if (id == 0)
{
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
model.CRT_DATETIME = model.CRT_DATETIME;
model.CRT_USER_ID = model.CRT_USER_ID;
}
//model.CRT_USER_ID = "";
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
//model.MOD_USER_ID = "";
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.STATUS = 0;
#endregion
////----------------------------------------------------------
////存储到数据库
model.SetIsNew(false);
//PRODUCT00Bll.GetInstence().Save(this, model, null, false, true);
result = result + "\r\n" + Product01Update();
if (!String.IsNullOrEmpty(result))
{
PRODUCT00Bll.GetInstence().Save(this, model);
PRODUCT00Bll.GetInstence().Insert_PRODUCT01(sPROD_ID, model.CRT_USER_ID);
result = "商品资料更新成功";
LoadData();
LoadData2(sPROD_ID);
}
}
catch (Exception e)
{
result = "更新失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
public void btnEditCon_Click(Object sender, EventArgs e)
{
try
{
//int Grid3RowIndex = ConvertHelper.Cint(Grid3Rowindex.Text);
string _CONTRACT_ID = tbxCONTRACT_ID.Text.ToString();
if (String.IsNullOrEmpty(_CONTRACT_ID))
{
FineUI.Alert.ShowInParent("未选择商品", FineUI.MessageBoxIcon.Information);
return;
}
FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid;
int[] selections = Grid4.SelectedRowIndexArray;
if (selections.Length == 0)
{
FineUI.Alert.ShowInParent("请选择一行", FineUI.MessageBoxIcon.Information);
return;
}
foreach (int i in selections)
{
int _Id = ConvertHelper.Cint(Grid4.DataKeys[i][0].ToString());
if (_Id > 0)
{
JObject defaultObj = new JObject();
var model = new PRODUCT00(x => x.Id == _Id);
//暂时保留后期可能优化
string _UserHashKey = Session[OnlineUsersTable.UserHashKey].ToString();
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
DataSet dsCom = (DataSet)SPs.Get_CONTRACT01_PRODUCT01(_UserHashKey, model.PROD_ID).ExecuteDataSet();
if (dsCom.Tables.Count > 0)
{
if (dsCom.Tables[0].Rows.Count > 0)
{
defaultObj.Add("Id01", 0);
defaultObj.Add("CONTRACT_ID01", _CONTRACT_ID);
defaultObj.Add("PROD_ID01", model.PROD_ID);
defaultObj.Add("PROD_NAME01", model.PROD_NAME1);
defaultObj.Add("CONTRACT_PRICE01", dsCom.Tables[0].Rows[0]["COST"].ToString());
defaultObj.Add("CONTRACT_PRICE101", dsCom.Tables[0].Rows[0]["COST1"].ToString());
defaultObj.Add("CONTRACT_PRICE201", dsCom.Tables[0].Rows[0]["COST2"].ToString());
defaultObj.Add("USABLE01", true);
defaultObj.Add("Meno01", "");
defaultObj.Add("CRT_USER_ID01", OlUser.Manager_LoginName);
defaultObj.Add("CRT_DATETIME01", DateTime.Now.ToString());
defaultObj.Add("MOD_USER_ID01", OlUser.Manager_LoginName);
defaultObj.Add("MOD_DATETIME01", DateTime.Now.ToString());
Grid2.AddNewRecord(defaultObj, true);
}
else
{
FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information);
}
}
else
{
FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information);
}
}
}
}
catch (Exception err)
{
FineUI.Alert.ShowInParent("添加失败:" + err.Message, FineUI.MessageBoxIcon.Information);
}
}
/// <summary>
/// 数据保存
/// </summary>
/// <returns></returns>
public override string Save()
{
string result = string.Empty;
int id = ConvertHelper.Cint0(hidId.Text);
try
{
#region 数据验证
var sPROD_ID = PROD_ID.Text.Trim();
if (string.IsNullOrEmpty(PROD_ID.Text.Trim()))
{
PROD_ID.ShowRedStar = true;
return(PROD_ID.Label + "不能为空！");
}
if (string.IsNullOrEmpty(PROD_NAME1.Text.Trim()))
{
return(PROD_NAME1.Label + "不能为空！");
}
var sPROD_KIND = PROD_KIND.SelectedValue;
if (string.IsNullOrEmpty(sPROD_KIND) || sPROD_KIND == "0")
{
return(PROD_KIND.Label + "不能为空！");
}
var sPROD_DEP = PROD_DEP.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP) || sPROD_DEP == "0")
{
return(PROD_DEP.Label + "不能为空！");
}
var sPROD_TYPE = PROD_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_DEP))
{
return(PROD_TYPE.Label + "不能为空！");
}
var sPROD_Source = PROD_Source.SelectedValue;
if (string.IsNullOrEmpty(sPROD_Source))
{
return(PROD_Source.Label + "不能为空！");
}
var sINV_TYPE = INV_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sINV_TYPE) || sINV_TYPE == "0")
{
return(INV_TYPE.Label + "不能为空！");
}
var sSTOCK_TYPE = STOCK_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sSTOCK_TYPE) || sSTOCK_TYPE == "0")
{
return(STOCK_TYPE.Label + "不能为空！");
}
var sBOM_TYPE = BOM_TYPE.SelectedValue;
if (string.IsNullOrEmpty(sBOM_TYPE) || sBOM_TYPE == "0")
{
return(BOM_TYPE.Label + "不能为空！");
}
var sMarginControl = MarginControl.SelectedValue;
if (string.IsNullOrEmpty(sMarginControl) || sMarginControl == "0")
{
return(MarginControl.Label + "不能为空！");
}
var sPROD_RangTYPE = PROD_RangTYPE.SelectedValue;
if (string.IsNullOrEmpty(sPROD_RangTYPE) || sPROD_RangTYPE == "0")
{
return(PROD_RangTYPE.Label + "不能为空！");
}
var sPROD_iRang = PROD_iRang.Text;
if (string.IsNullOrEmpty(sPROD_iRang))
{
return(PROD_iRang.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_iRang))
{
return(PROD_iRang.Label + "必须为整数123！");
}
var sPROD_UNIT = PROD_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT) || sPROD_UNIT == "0")
{
return(PROD_UNIT.Label + "不能为空！");
}
var sPROD_CONVERT1 = PROD_CONVERT1.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT1))
{
return(PROD_CONVERT1.Label + "必须为整数！");
}
var sPROD_UNIT1 = PROD_UNIT1.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT1) || sPROD_UNIT1 == "0")
{
return("包装单位不能为空！");
}
var sPROD_CONVERT2 = PROD_CONVERT2.Text;
if (string.IsNullOrEmpty(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPROD_CONVERT2))
{
return(PROD_CONVERT2.Label + "必须为整数！");
}
var sPROD_UNIT2 = PROD_UNIT2.SelectedValue;
if (string.IsNullOrEmpty(sPROD_UNIT2) || sPROD_UNIT2 == "0")
{
return("外箱单位不能为空！");
}
var sReport_UNIT = Report_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sReport_UNIT) || sReport_UNIT == "0")
{
return(Report_UNIT.Label + "不能为空！");
}
var sOrder_UNIT = Order_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sOrder_UNIT) || sOrder_UNIT == "0")
{
return(Order_UNIT.Label + "不能为空！");
}
var sOrder_Quan = Order_QUAN.Text;
if (string.IsNullOrEmpty(sOrder_Quan) || sOrder_Quan == "0")
{
return(Order_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sOrder_Quan))
{
return(Order_QUAN.Label + "必须为整数！");
}
var sPurchase_UNIT = Purchase_UNIT.SelectedValue;
if (string.IsNullOrEmpty(sPurchase_UNIT) || sPurchase_UNIT == "0")
{
return(Purchase_UNIT.Label + "不能为空！");
}
var sPurchase_QUAN = Purchase_QUAN.Text;
if (string.IsNullOrEmpty(sPurchase_QUAN))
{
return(Purchase_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sPurchase_QUAN))
{
return(Purchase_QUAN.Label + "必须为整数！");
}
var sSAFE_QUAN = SAFE_QUAN.Text;
if (string.IsNullOrEmpty(sSAFE_QUAN))
{
return(SAFE_QUAN.Label + "不能为空！");
}
if (!ConvertHelper.IsInt(sSAFE_QUAN))
{
return(SAFE_QUAN.Label + "必须为整数！");
}
sPROD_ID = StringHelper.Left(sPROD_ID, 50);
if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id == 0)
{
return(PROD_ID.Label + "已存在！请重新输入！");
}
//var sMeno = StringHelper.Left(UNIT_MENO.Text, 40);
//if (UNIT_MENO.Text.Trim().Length > 40)
//{
// return UNIT_MENO.Label + "超长！";
//}
#endregion
#region 赋值
var model = new PRODUCT00(x => x.Id == id);
var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
model.PROD_ID = sPROD_ID;
model.PROD_NAME1 = PROD_NAME1.Text;
model.PROD_NAME2 = PROD_NAME2.Text;
model.PROD_KIND = sPROD_KIND;
model.PROD_DEP = sPROD_DEP;
model.PROD_CATE = PROD_CATE.SelectedValue;
model.DIV_ID = DIV_ID.SelectedValue;
model.INV_TYPE = ConvertHelper.Cint(sINV_TYPE);
model.STOCK_TYPE = ConvertHelper.Cint(sSTOCK_TYPE);
model.BOM_TYPE = ConvertHelper.Cint(sBOM_TYPE);
model.MarginControl = ConvertHelper.Cint(sMarginControl);
model.PROD_RangTYPE = ConvertHelper.Cint(sPROD_RangTYPE);
model.PROD_iRang = ConvertHelper.Cint(sPROD_iRang);
model.PROD_SPEC = PROD_SPEC.Text;
model.PROD_Margin = PROD_Margin.Text;
model.PROD_BARCODE = PROD_BARCODE.Text;
model.PROD_UNIT = sPROD_UNIT;
model.PROD_UNIT1 = sPROD_UNIT1;
model.PROD_CONVERT1 = ConvertHelper.Cint(sPROD_CONVERT1);
model.PROD_UNIT2 = sPROD_UNIT2;
model.PROD_CONVERT2 = ConvertHelper.Cint(sPROD_CONVERT2);
model.Report_UNIT = ConvertHelper.Cint(sReport_UNIT);
model.PROD_MEMO = PROD_MEMO.Text;
if (id == 0)
{
model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.CRT_USER_ID = OlUser.Manager_LoginName;
}
else
{
model.CRT_DATETIME = model.CRT_DATETIME;
model.CRT_USER_ID = model.CRT_USER_ID;
}
//model.CRT_USER_ID = "";
model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.MOD_USER_ID = OlUser.Manager_LoginName;
//model.MOD_USER_ID = "";
model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
model.STATUS = 0;
#endregion
////----------------------------------------------------------
////存储到数据库
PRODUCT00Bll.GetInstence().Save(this, model);
}
catch (Exception e)
{
result = "保存失败！";
//出现异常，保存出错日志信息
CommonBll.WriteLog(result, e);
}
return(result);
}
