Exemple #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model">model</param>
        public int AddRecord(LWareData model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("set nocount on; ");
            strSql.Append("insert into LWare(");
            strSql.Append(@"wareNo,wareNm,wareType,wareSortNo,isDel,isrtEmpId,isrtDt,updtEmpId,updtDt)");
            strSql.Append(" values (");
            strSql.Append(@"@wareNo,@wareNm,@wareType,@wareSortNo,@isDel,@isrtEmpId,@isrtDt,@updtEmpId,@updtDt)");
            strSql.Append("; select @@identity; set nocount off; ");
            SqlParameter[] parameters = {
                    new SqlParameter("@wareNo", SqlDbType.VarChar,20),
                    new SqlParameter("@wareNm", SqlDbType.NVarChar,50),
                    new SqlParameter("@wareType", SqlDbType.NVarChar,20),
                    new SqlParameter("@wareSortNo", SqlDbType.VarChar,20),
                    new SqlParameter("@isDel", SqlDbType.Bit),
                    new SqlParameter("@isrtEmpId", SqlDbType.Int),
                    new SqlParameter("@isrtDt", SqlDbType.DateTime),
                    new SqlParameter("@updtEmpId", SqlDbType.Int),
                    new SqlParameter("@updtDt", SqlDbType.DateTime)
                };
            parameters[0].Value = model.wareNo;
            parameters[1].Value = model.wareNm;
            parameters[2].Value = model.wareType;
            parameters[3].Value = model.wareSortNo;
            parameters[4].Value = model.isDel;
            parameters[5].Value = model.isrtEmpId;
            parameters[6].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
            parameters[7].Value = model.updtEmpId;
            parameters[8].Value = model.updtDt == string.Empty ? null : model.updtDt;

            int id = 0;
            try
            {
                object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);

                if (ret != null && ret != DBNull.Value)
                {
                    id = Convert.ToInt32(ret);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return id;
        }
    /// <summary>
    /// 数据保存
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string strInfo = "";

        if (!this.ValidateData(out strInfo))
        {
            strInfo = strInfo.Replace("\"", "'").Replace("\n", "");
            this.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + strInfo + "');", true);
            return;
        }

        LWareData model = new LWareData();
        LWareBB wareBB = new LWareBB();

        try
        {
            if (this.State == "1")
            {
                this.SetModel(ref model);
                model.isrtDt = DateTime.Now.ToString();
                model.isrtEmpId = this.currentUser.empId;
                this.IdValue = wareBB.AddRecord(model);
            }
            else if (this.State == "2")
            {
                model = wareBB.GetModel(this.IdValue);
                this.SetModel(ref model);
                model.updtDt = DateTime.Now.ToString();
                model.updtEmpId = this.currentUser.empId;
                wareBB.ModifyRecord(model);
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            wareBB.Dispose();
        }

        Response.Redirect("LWareList.aspx?&itemno=" + this.itemNo + "&pTypeNo=main", false);
    }
Exemple #3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// <param name="model">model</param>
        public bool ModifyRecord(LWareData model)
        {
            bool ret = false;
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update LWare set ");
            strSql.Append("wareNo=@wareNo,");
            strSql.Append("wareNm=@wareNm,");
            strSql.Append("wareType=@wareType,");
            strSql.Append("wareSortNo=@wareSortNo,");
            strSql.Append("isDel=@isDel,");
            strSql.Append("isrtEmpId=@isrtEmpId,");
            strSql.Append("isrtDt=@isrtDt,");
            strSql.Append("updtEmpId=@updtEmpId,");
            strSql.Append("updtDt=@updtDt");
            strSql.Append(" where id = @id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int),
                    new SqlParameter("@wareNo", SqlDbType.VarChar,20),
                    new SqlParameter("@wareNm", SqlDbType.NVarChar,50),
                    new SqlParameter("@wareType", SqlDbType.NVarChar,20),
                    new SqlParameter("@wareSortNo", SqlDbType.VarChar,20),
                    new SqlParameter("@isDel", SqlDbType.Bit),
                    new SqlParameter("@isrtEmpId", SqlDbType.Int),
                    new SqlParameter("@isrtDt", SqlDbType.DateTime),
                    new SqlParameter("@updtEmpId", SqlDbType.Int),
                    new SqlParameter("@updtDt", SqlDbType.DateTime)
                };
            parameters[0].Value = model.id;
            parameters[1].Value = model.wareNo;
            parameters[2].Value = model.wareNm;
            parameters[3].Value = model.wareType;
            parameters[4].Value = model.wareSortNo;
            parameters[5].Value = model.isDel;
            parameters[6].Value = model.isrtEmpId;
            parameters[7].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
            parameters[8].Value = model.updtEmpId;
            parameters[9].Value = model.updtDt == string.Empty ? null : model.updtDt;

            try
            {
                SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
                ret = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ret;
        }
Exemple #4
0
        /// <summary>
        /// 得到一个model
        /// </summary>
        /// <param name="id">主键值</param>
        /// <returns>model</returns>
        public LWareData GetModel(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"select id,wareNo,wareNm,wareType,wareSortNo,isDel,isrtEmpId,isrtDt,updtEmpId,updtDt from LWare");
            strSql.Append(" where id = @id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int)
                };
            parameters[0].Value = id;

            LWareData model = new LWareData();
            DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                if (row["id"] != DBNull.Value)
                {
                    model.id = Convert.ToInt32(row["id"]);
                }
                if (row["wareNo"] != DBNull.Value)
                {
                    model.wareNo = Convert.ToString(row["wareNo"]);
                }
                if (row["wareNm"] != DBNull.Value)
                {
                    model.wareNm = Convert.ToString(row["wareNm"]);
                }
                if (row["wareType"] != DBNull.Value)
                {
                    model.wareType = Convert.ToString(row["wareType"]);
                }
                if (row["wareSortNo"] != DBNull.Value)
                {
                    model.wareSortNo = Convert.ToString(row["wareSortNo"]);
                }
                if (row["isDel"] != DBNull.Value)
                {
                    model.isDel = Convert.ToBoolean(row["isDel"]);
                }
                if (row["isrtEmpId"] != DBNull.Value)
                {
                    model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]);
                }
                if (row["isrtDt"] != DBNull.Value)
                {
                    model.isrtDt = Convert.ToString(row["isrtDt"]);
                }
                if (row["updtEmpId"] != DBNull.Value)
                {
                    model.updtEmpId = Convert.ToInt32(row["updtEmpId"]);
                }
                if (row["updtDt"] != DBNull.Value)
                {
                    model.updtDt = Convert.ToString(row["updtDt"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }
    /// <summary>
    /// 删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDel_Click(object sender, EventArgs e)
    {
        bool retChecked = false;
        LWareBB wareBB = new LWareBB();

        try
        {
            //获取选中的数据Id
            foreach (GridViewRow gvrow in this.grid.Rows)
            {
                CheckBox chkId = (CheckBox)gvrow.FindControl("chkId");
                if (chkId.Checked == true)
                {
                    retChecked = true;
                    int id = int.Parse(chkId.ValidationGroup);
                    LWareData wareModel = new LWareData();

                    wareModel = wareBB.GetModel(id);
                    wareModel.isDel = true;
                    wareModel.updtDt = System.DateTime.Now.ToString();
                    wareModel.updtEmpId = this.currentUser.empId;
                    wareBB.ModifyRecord(wareModel);
                }
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            wareBB.Dispose();
        }

        if (retChecked)
        {
            this.BindGrid();
        }
    }
 /// <summary>
 /// 实体类赋值
 /// </summary>
 /// <param name="model">实体类实例</param>
 private void SetModel(ref LWareData model)
 {
     model.wareNo = this.tbWareNo.Text.Trim();
     model.wareNm = this.tbWareNm.Text.Trim();
     model.wareType = this.ddlWareType.SelectedValue;
     model.wareSortNo = this.ddlWareSort.SelectedValue;
 }
Exemple #7
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model">model</param>
 public bool ModifyRecord(LWareData model)
 {
     return this.wareDB.ModifyRecord(model);
 }
Exemple #8
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 /// <param name="model">model</param>
 public int AddRecord(LWareData model)
 {
     return this.wareDB.AddRecord(model);
 }