コード例 #1
0
        public decimal Save(Tz888.Model.TFZS.TFZS_ProjectDetaiSubModel model, bool IsSave)
        {
            int rowsAffected;

            SqlParameter[] parameters =
            {
                new SqlParameter("@id",            SqlDbType.BigInt,     8),
                new SqlParameter("@InfoID",        SqlDbType.BigInt,     8),
                new SqlParameter("@DicMainCode",   SqlDbType.Char,      30),
                new SqlParameter("@ExpressCode",   SqlDbType.Char,      30),
                new SqlParameter("@TARGET_ANSWER", SqlDbType.VarChar,  200),
                new SqlParameter("@TARGET_POINT",  SqlDbType.Decimal,    5),
                new SqlParameter("@IsSave",        SqlDbType.Bit),
                new SqlParameter("@Point",         SqlDbType.Decimal),
            };
            parameters[0].Direction = ParameterDirection.Output;
            parameters[1].Value     = model.InfoID;
            parameters[2].Value     = model.DicMainCode;
            parameters[3].Value     = model.ExpressCode;
            parameters[4].Value     = model.TARGET_ANSWER;
            parameters[5].Value     = model.TARGET_POINT;
            parameters[6].Value     = IsSave;
            parameters[7].Direction = ParameterDirection.Output;

            DbHelperSQL.RunProcedure("TFZS_ProjectDetaiSubTab_Save", parameters, out rowsAffected);
            return((decimal)parameters[7].Value);
        }
コード例 #2
0
    private decimal Save(RadioButtonList rbl, string code, bool IsSave)
    {
        Tz888.Model.TFZS.TFZS_ProjectDetaiSubModel model = new Tz888.Model.TFZS.TFZS_ProjectDetaiSubModel();
        model.id            = 0;
        model.InfoID        = this.InfoID;
        model.ExpressCode   = code;
        model.DicMainCode   = "";
        model.TARGET_ANSWER = rbl.SelectedValue.Trim();
        model.TARGET_POINT  = 0;

        Tz888.BLL.TFZS.TFZS_ProjectDetaiSubBLL bll = new Tz888.BLL.TFZS.TFZS_ProjectDetaiSubBLL();

        return(bll.Save(model, IsSave));
    }
コード例 #3
0
    private decimal Save(CheckBoxList cbl, string code, bool IsSave)
    {
        Tz888.Model.TFZS.TFZS_ProjectDetaiSubModel model = new Tz888.Model.TFZS.TFZS_ProjectDetaiSubModel();
        string Answer = "";

        for (int i = 0; cbl.Items.Count > i; i++)
        {
            if (cbl.Items[i].Selected)
            {
                Answer += cbl.Items[i].Value.Trim() + ",";
            }
        }
        model.id            = 0;
        model.InfoID        = this.InfoID;
        model.ExpressCode   = code;
        model.DicMainCode   = "";
        model.TARGET_ANSWER = Answer;
        model.TARGET_POINT  = 0;

        Tz888.BLL.TFZS.TFZS_ProjectDetaiSubBLL bll = new Tz888.BLL.TFZS.TFZS_ProjectDetaiSubBLL();

        return(bll.Save(model, IsSave));
    }