Пример #1
0
        /// <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();
        }
Пример #3
0
        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;
            }
        }
        public string Product01Update(DataTable da)
        {
            string sPROD_ID    = PROD_ID.Text.ToString();
            string sPRCAREA_ID = "";

            try
            {
                if (da.Columns.Contains("PRCAREA_ID"))
                {
                    sPRCAREA_ID = da.Rows[0]["PRCAREA_ID"].ToString();
                }
                else
                {
                    return("价格区域编号" + da.Rows[0]["PRCAREA_ID"].ToString() + "更新失败");
                }
                var model = new PRODUCT01(x => x.PROD_ID == sPROD_ID && x.PRCAREA_ID == sPRCAREA_ID);
                if (model.Id > 0)
                {
                    if (model.PROD_ID != sPROD_ID || model.PRCAREA_ID != sPRCAREA_ID)
                    {
                        return("价格区域编号" + da.Rows[0]["PRCAREA_ID"].ToString() + "更新失败");
                    }
                    var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());
                    if (da.Columns.Contains("SUP_ID"))
                    {
                        model.SUP_ID = da.Rows[0]["SUP_ID"].ToString();
                    }
                    if (da.Columns.Contains("SEND_TYPE"))
                    {
                        model.SEND_TYPE = ConvertHelper.StringToByte(da.Rows[0]["SEND_TYPE"].ToString());
                    }
                    if (da.Columns.Contains("TAX_TYPE"))
                    {
                        model.TAX_TYPE = ConvertHelper.StringToByte(da.Rows[0]["TAX_TYPE"].ToString());
                    }
                    if (da.Columns.Contains("Tax"))
                    {
                        model.Tax = ConvertHelper.Cint(da.Rows[0]["Tax"].ToString());
                    }
                    if (da.Columns.Contains("SUP_COST"))
                    {
                        model.SUP_COST = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_COST"].ToString());
                    }
                    if (da.Columns.Contains("SUP_COST1"))
                    {
                        model.SUP_COST1 = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_COST1"].ToString());
                    }
                    if (da.Columns.Contains("SUP_COST2"))
                    {
                        model.SUP_COST2 = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_COST2"].ToString());
                    }
                    if (da.Columns.Contains("SUP_Return"))
                    {
                        model.SUP_Return = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_Return"].ToString());
                    }
                    if (da.Columns.Contains("SUP_Return1"))
                    {
                        model.SUP_Return1 = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_Return1"].ToString());
                    }
                    if (da.Columns.Contains("SUP_Return2"))
                    {
                        model.SUP_Return2 = ConvertHelper.StringToDecimal(da.Rows[0]["SUP_Return2"].ToString());
                    }

                    if (da.Columns.Contains("U_Cost"))
                    {
                        model.U_Cost = ConvertHelper.StringToDecimal(da.Rows[0]["U_Cost"].ToString());
                    }
                    if (da.Columns.Contains("U_Cost1"))
                    {
                        model.U_Cost1 = ConvertHelper.StringToDecimal(da.Rows[0]["U_Cost1"].ToString());
                    }
                    if (da.Columns.Contains("U_Cost2"))
                    {
                        model.U_Cost2 = ConvertHelper.StringToDecimal(da.Rows[0]["U_Cost2"].ToString());
                    }
                    if (da.Columns.Contains("U_Ret_COST"))
                    {
                        model.U_Ret_COST = ConvertHelper.StringToDecimal(da.Rows[0]["U_Ret_COST"].ToString());
                    }
                    if (da.Columns.Contains("U_Ret_COST1"))
                    {
                        model.U_Ret_COST1 = ConvertHelper.StringToDecimal(da.Rows[0]["U_Ret_COST1"].ToString());
                    }
                    if (da.Columns.Contains("U_Ret_COST2"))
                    {
                        model.U_Ret_COST2 = ConvertHelper.StringToDecimal(da.Rows[0]["U_Ret_COST2"].ToString());
                    }

                    if (da.Columns.Contains("T_COST"))
                    {
                        model.T_COST = ConvertHelper.StringToDecimal(da.Rows[0]["T_COST"].ToString());
                    }
                    if (da.Columns.Contains("T_COST1"))
                    {
                        model.T_COST1 = ConvertHelper.StringToDecimal(da.Rows[0]["T_COST1"].ToString());
                    }
                    if (da.Columns.Contains("T_COST2"))
                    {
                        model.T_COST2 = ConvertHelper.StringToDecimal(da.Rows[0]["T_COST2"].ToString());
                    }
                    if (da.Columns.Contains("T_Ret_COST"))
                    {
                        model.T_Ret_COST = ConvertHelper.StringToDecimal(da.Rows[0]["T_Ret_COST"].ToString());
                    }
                    if (da.Columns.Contains("T_Ret_COST1"))
                    {
                        model.T_Ret_COST1 = ConvertHelper.StringToDecimal(da.Rows[0]["T_Ret_COST1"].ToString());
                    }
                    if (da.Columns.Contains("T_Ret_COST2"))
                    {
                        model.T_Ret_COST2 = ConvertHelper.StringToDecimal(da.Rows[0]["T_Ret_COST2"].ToString());
                    }

                    if (da.Columns.Contains("COST"))
                    {
                        model.COST = ConvertHelper.StringToDecimal(da.Rows[0]["COST"].ToString());
                    }
                    if (da.Columns.Contains("COST1"))
                    {
                        model.COST1 = ConvertHelper.StringToDecimal(da.Rows[0]["COST1"].ToString());
                    }
                    if (da.Columns.Contains("COST2"))
                    {
                        model.COST2 = ConvertHelper.StringToDecimal(da.Rows[0]["COST2"].ToString());
                    }
                    if (da.Columns.Contains("ENABLE"))
                    {
                        if (da.Rows[0]["ENABLE"].ToString() == "True")
                        {
                            model.ENABLE = 1;
                        }
                        else
                        {
                            model.ENABLE = 0;
                        }
                    }
                    if (da.Columns.Contains("VISIBLE"))
                    {
                        if (da.Rows[0]["VISIBLE"].ToString() == "True")
                        {
                            model.VISIBLE = 1;
                        }
                        else
                        {
                            model.VISIBLE = 0;
                        }
                    }
                    if (da.Columns.Contains("BOM_ID"))
                    {
                        model.BOM_ID = da.Rows[0]["BOM_ID"].ToString();
                        //if (!String.IsNullOrEmpty(da.Rows[0]["BOM_ID"].ToString()))
                        //{
                        //    model.BOM_ID = da.Rows[0]["BOM_ID"].ToString();
                        //}
                        //else
                        //{
                        //    return "默认配方编码出错,更新失败";
                        //}
                    }

                    if (da.Columns.Contains("ORDER_UNIT"))
                    {
                        model.ORDER_UNIT = ConvertHelper.StringToByte(da.Rows[0]["ORDER_UNIT"].ToString());
                    }

                    if (da.Columns.Contains("ORDER_QUAN"))
                    {
                        model.ORDER_QUAN = ConvertHelper.StringToByte(da.Rows[0]["ORDER_QUAN"].ToString());
                    }

                    if (da.Columns.Contains("Purchase_UNIT"))
                    {
                        model.Purchase_UNIT = ConvertHelper.StringToByte(da.Rows[0]["Purchase_UNIT"].ToString());
                    }

                    if (da.Columns.Contains("Purchase_QUAN"))
                    {
                        model.Purchase_QUAN = ConvertHelper.StringToByte(da.Rows[0]["Purchase_QUAN"].ToString());
                    }

                    if (da.Columns.Contains("SAFE_QUAN"))
                    {
                        model.SAFE_QUAN = ConvertHelper.StringToByte(da.Rows[0]["SAFE_QUAN"].ToString());
                    }

                    if (da.Columns.Contains("PROD_PRICE"))
                    {
                        model.PROD_PRICE = ConvertHelper.StringToByte(da.Rows[0]["PROD_PRICE"].ToString());
                    }

                    model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
                    model.MOD_USER_ID  = OlUser.Manager_LoginName;
                    model.SetIsNew(false);
                    PRODUCT01Bll.GetInstence().Save(this, model);
                    return("");
                }
                else
                {
                    return("价格区域编号" + da.Rows[0]["rPRCAREA_ID"].ToString() + "更新失败");
                }
            }
            catch (Exception err)
            {
                return("价格区域编号" + da.Rows[0]["rPRCAREA_ID"].ToString() + "更新失败!失败原因:" + err.Message);
            }
        }
Пример #5
0
        /// <summary>
        /// 数据保存
        /// </summary>
        /// <returns></returns>
        public override string Save()
        {
            string result  = string.Empty;
            int    id      = ConvertHelper.Cint0(hidId.Text);
            string prod_id = hidPROD_ID.Text;

            if (!String.IsNullOrEmpty(prod_id))
            {
                try
                {
                    #region 数据验证
                    var sPRCAREA_ID = PRCAREA_ID.SelectedValue;
                    if (string.IsNullOrEmpty(sPRCAREA_ID) || sPRCAREA_ID == "0")
                    {
                        return(PRCAREA_ID.Label + "不能为空!");
                    }

                    var sSUP_ID = SUP_ID.SelectedValue;
                    if (string.IsNullOrEmpty(sSUP_ID) || sSUP_ID == "0")
                    {
                        return(SUP_ID.Label + "不能为空!");
                    }

                    var sTAX_TYPE = TAX_TYPE.SelectedValue;
                    if (string.IsNullOrEmpty(sTAX_TYPE))
                    {
                        return(TAX_TYPE.Label + "不能为空!");
                    }

                    var sSEND_TYPE = SEND_TYPE.SelectedValue;
                    if (string.IsNullOrEmpty(sSEND_TYPE) || sSEND_TYPE == "0")
                    {
                        return(SEND_TYPE.Label + "不能为空!");
                    }

                    var sTax = Tax.Text;
                    if (string.IsNullOrEmpty(sTax))
                    {
                        return(Tax.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sTax))
                    {
                        return(Tax.Label + "必须为整数!");
                    }

                    var sSUP_COST = SUP_COST.Text;
                    if (string.IsNullOrEmpty(sSUP_COST))
                    {
                        return(SUP_COST.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_COST))
                    {
                        return(SUP_COST.Label + "必须为整数!");
                    }

                    var sSUP_COST1 = SUP_COST1.Text;
                    if (string.IsNullOrEmpty(sSUP_COST1))
                    {
                        return(SUP_COST1.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_COST1))
                    {
                        return(SUP_COST1.Label + "必须为整数!");
                    }

                    var sSUP_COST2 = SUP_COST2.Text;
                    if (string.IsNullOrEmpty(sSUP_COST2))
                    {
                        return(SUP_COST2.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_COST2))
                    {
                        return(SUP_COST2.Label + "必须为整数!");
                    }

                    var sSUP_Return = SUP_Return.Text;
                    if (string.IsNullOrEmpty(sSUP_Return))
                    {
                        return(SUP_Return.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_Return))
                    {
                        return(SUP_Return.Label + "必须为整数!");
                    }

                    var sSUP_Return1 = SUP_Return1.Text;
                    if (string.IsNullOrEmpty(sSUP_Return1))
                    {
                        return(SUP_Return1.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_Return1))
                    {
                        return(SUP_Return1.Label + "必须为整数!");
                    }

                    var sSUP_Return2 = SUP_Return2.Text;
                    if (string.IsNullOrEmpty(sSUP_Return2))
                    {
                        return(SUP_Return2.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sSUP_Return2))
                    {
                        return(SUP_Return2.Label + "必须为整数!");
                    }

                    var sU_Cost = U_Cost.Text;
                    if (string.IsNullOrEmpty(sU_Cost))
                    {
                        return(U_Cost.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sU_Cost))
                    {
                        return(U_Cost.Label + "必须为整数!");
                    }

                    var sU_Cost1 = U_Cost1.Text;
                    if (string.IsNullOrEmpty(sU_Cost1))
                    {
                        return(U_Cost1.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sU_Cost1))
                    {
                        return(U_Cost1.Label + "必须为整数!");
                    }

                    var sU_Cost2 = U_Cost2.Text;
                    if (string.IsNullOrEmpty(sU_Cost2))
                    {
                        return(U_Cost2.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sU_Cost2))
                    {
                        return(U_Cost2.Label + "必须为整数!");
                    }

                    var sU_Ret_COST = U_Ret_COST.Text;
                    if (string.IsNullOrEmpty(sU_Ret_COST))
                    {
                        return(U_Ret_COST.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sU_Ret_COST))
                    {
                        return(U_Ret_COST.Label + "必须为整数!");
                    }

                    var sU_Ret_COST1 = U_Ret_COST1.Text;
                    if (string.IsNullOrEmpty(sU_Ret_COST1))
                    {
                        return(U_Ret_COST1.Label + "不能为空!");
                    }

                    if (!ConvertHelper.IsInt(sU_Ret_COST1))
                    {
                        return(U_Ret_COST1.Label + "必须为整数!");
                    }

                    var sU_Ret_COST2 = U_Ret_COST2.Text;
                    if (string.IsNullOrEmpty(sU_Ret_COST2))
                    {
                        return(U_Ret_COST2.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sU_Ret_COST2))
                    {
                        return(U_Ret_COST2.Label + "必须为整数!");
                    }

                    var sT_COST = T_COST.Text;
                    if (string.IsNullOrEmpty(sT_COST))
                    {
                        return(T_COST.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_COST))
                    {
                        return(T_COST.Label + "必须为整数!");
                    }

                    var sT_COST1 = T_COST1.Text;
                    if (string.IsNullOrEmpty(sT_COST1))
                    {
                        return(T_COST1.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_COST1))
                    {
                        return(T_COST1.Label + "必须为整数!");
                    }

                    var sT_COST2 = T_COST2.Text;
                    if (string.IsNullOrEmpty(sT_COST2))
                    {
                        return(T_COST2.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_COST2))
                    {
                        return(T_COST2.Label + "必须为整数!");
                    }

                    var sT_Ret_COST = T_Ret_COST.Text;
                    if (string.IsNullOrEmpty(sT_Ret_COST))
                    {
                        return(T_Ret_COST.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_Ret_COST))
                    {
                        return(T_Ret_COST.Label + "必须为整数!");
                    }

                    var sT_Ret_COST1 = T_Ret_COST1.Text;
                    if (string.IsNullOrEmpty(sT_Ret_COST1))
                    {
                        return(T_Ret_COST1.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_Ret_COST1))
                    {
                        return(T_Ret_COST1.Label + "必须为整数!");
                    }

                    var sT_Ret_COST2 = T_Ret_COST2.Text;
                    if (string.IsNullOrEmpty(sT_Ret_COST2))
                    {
                        return(T_Ret_COST2.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sT_Ret_COST2))
                    {
                        return(T_Ret_COST2.Label + "必须为整数!");
                    }

                    var sCOST = COST.Text;
                    if (string.IsNullOrEmpty(sCOST))
                    {
                        return(COST.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sCOST))
                    {
                        return(COST.Label + "必须为整数123!");
                    }

                    var sCOST1 = COST1.Text;
                    if (string.IsNullOrEmpty(sCOST1))
                    {
                        return(COST1.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sCOST1))
                    {
                        return(COST1.Label + "必须为整数!");
                    }

                    var sCOST2 = COST2.Text;
                    if (string.IsNullOrEmpty(sCOST2))
                    {
                        return(COST2.Label + "不能为空!");
                    }
                    if (!ConvertHelper.IsInt(sCOST2))
                    {
                        return(COST2.Label + "必须为整数!");
                    }

                    var sENABLE = ENABLE.SelectedValue;
                    if (string.IsNullOrEmpty(sENABLE))
                    {
                        return(ENABLE.Label + "不能为空!");
                    }

                    var sVISIBLE = VISIBLE.SelectedValue;
                    if (string.IsNullOrEmpty(sVISIBLE))
                    {
                        return(VISIBLE.Label + "不能为空!");
                    }
                    #endregion

                    if (PRODUCT01Bll.GetInstence().Exist(x => x.PRCAREA_ID == sPRCAREA_ID && x.PROD_ID == prod_id) && id == 0)
                    {
                        return(PRCAREA_ID.Label + "已存在!请重新输入!");
                    }

                    #region 赋值

                    var model  = new PRODUCT01(x => x.Id == id);
                    var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString());

                    model.PRCAREA_ID  = sPRCAREA_ID;
                    model.PROD_ID     = prod_id;
                    model.SUP_ID      = sSUP_ID;
                    model.SEND_TYPE   = ConvertHelper.StringToByte(sSEND_TYPE);
                    model.TAX_TYPE    = ConvertHelper.StringToByte(sTAX_TYPE);
                    model.Tax         = ConvertHelper.Cint0(sTax);
                    model.SUP_COST    = ConvertHelper.Cint0(sSUP_COST);
                    model.SUP_COST1   = ConvertHelper.Cint0(sSUP_COST1);
                    model.SUP_COST2   = ConvertHelper.Cint0(sSUP_COST2);
                    model.SUP_Return  = ConvertHelper.Cint0(sSUP_Return);
                    model.SUP_Return1 = ConvertHelper.Cint0(sSUP_Return1);
                    model.SUP_Return2 = ConvertHelper.Cint0(sSUP_Return2);

                    model.U_Cost  = ConvertHelper.Cint0(sU_Cost);
                    model.U_Cost1 = ConvertHelper.Cint0(sU_Cost1);
                    model.U_Cost2 = ConvertHelper.Cint0(sU_Cost2);

                    model.U_Ret_COST  = ConvertHelper.Cint0(sU_Ret_COST);
                    model.U_Ret_COST1 = ConvertHelper.Cint0(sU_Ret_COST1);
                    model.U_Ret_COST2 = ConvertHelper.Cint0(sU_Ret_COST2);

                    model.T_COST  = ConvertHelper.Cint0(sT_COST);
                    model.T_COST1 = ConvertHelper.Cint0(sT_COST1);
                    model.T_COST2 = ConvertHelper.Cint0(sT_COST2);

                    model.T_Ret_COST  = ConvertHelper.Cint0(sT_Ret_COST);
                    model.T_Ret_COST1 = ConvertHelper.Cint0(sT_Ret_COST1);
                    model.T_Ret_COST2 = ConvertHelper.Cint0(sT_Ret_COST2);

                    model.COST  = ConvertHelper.Cint0(sCOST);
                    model.COST1 = ConvertHelper.Cint0(sCOST1);
                    model.COST2 = ConvertHelper.Cint0(sCOST2);

                    model.VISIBLE = ConvertHelper.StringToByte(VISIBLE.SelectedValue);
                    model.ENABLE  = ConvertHelper.StringToByte(ENABLE.SelectedValue);
                    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
                    ////----------------------------------------------------------
                    ////存储到数据库
                    PRODUCT01Bll.GetInstence().Save(this, model);
                }
                catch (Exception e)
                {
                    result = "保存失败!";

                    //出现异常,保存出错日志信息
                    CommonBll.WriteLog(result, e);
                }
            }
            else
            {
                result = "保存失败,商品编码为空";
            }

            return(result);
        }