Exemplo n.º 1
0
        /// <summary>
        /// ����һ������
        /// </summary>
        /// <param name="model">model</param>
        public int AddRecord(HOrgnizationData model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("set nocount on; ");
            strSql.Append("insert into HOrgnization(");
            strSql.Append("departNo,departNm,uppDepartId,departLeader,isEffect,isDel,isrtDt,isrtEmpId,updtDt,updtEmpId,mark)");
            strSql.Append(" values (");
            strSql.Append("@departNo,@departNm,@uppDepartId,@departLeader,@isEffect,@isDel,@isrtDt,@isrtEmpId,@updtDt,@updtEmpId,@mark)");
            strSql.Append("; select @@identity; set nocount off; ");
            SqlParameter[] parameters = {
                    new SqlParameter("@departNo", SqlDbType.NVarChar,10),
                    new SqlParameter("@departNm", SqlDbType.NVarChar,50),
                    new SqlParameter("@uppDepartId", SqlDbType.Int),
                    new SqlParameter("@departLeader", SqlDbType.Int),
                    new SqlParameter("@isEffect", SqlDbType.Bit),
                    new SqlParameter("@isDel", SqlDbType.Bit),
                    new SqlParameter("@isrtDt", SqlDbType.DateTime),
                    new SqlParameter("@isrtEmpId", SqlDbType.Int),
                    new SqlParameter("@updtDt", SqlDbType.DateTime),
                    new SqlParameter("@updtEmpId", SqlDbType.Int),
                    new SqlParameter("@mark", SqlDbType.NVarChar,500)
                };
            parameters[0].Value = model.departNo;
            parameters[1].Value = model.departNm;
            parameters[2].Value = model.uppDepartId;
            parameters[3].Value = model.departLeader;
            parameters[4].Value = model.isEffect;
            parameters[5].Value = model.isDel;
            parameters[6].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
            parameters[7].Value = model.isrtEmpId;
            parameters[8].Value = model.updtDt == string.Empty ? null : model.updtDt;
            parameters[9].Value = model.updtEmpId;
            parameters[10].Value = model.mark;

            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;
        }
Exemplo n.º 2
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        HOrgnizationData model = new HOrgnizationData();
        HOrgnizationBB orgnizationBB = new HOrgnizationBB();
        try
        {
            if (this.State == "1")
            {
                this.SetModel(ref model);
                model.departNo = "";
                model.isrtDt = DateTime.Now.ToString();
                model.isrtEmpId = this.currentUser.empId;
                model.isDel = false;
                this.IdValue = orgnizationBB.AddRecord(model);
            }
            else if (this.State == "2")
            {
                model = orgnizationBB.GetModel(this.IdValue);
                this.SetModel(ref model);
                model.updtDt = DateTime.Now.ToString();
                model.updtEmpId = this.currentUser.empId;
                orgnizationBB.ModifyRecord(model);
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            orgnizationBB.Dispose();
        }

        Response.Redirect("HOrgnizationList.aspx?itemNo=" + this.itemNo + "&pTypeNo=main", false);
    }
Exemplo n.º 3
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
            {
                this.IdValue = Convert.ToInt32(Request.Params["id"]);
            }
            if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty)
            {
                this.State = Request.Params["state"].ToString();
                switch (this.State)
                {
                    case "1":   //add
                        break;
                    case "2":   //update
                        //���ؿؼ�
                        HOrgnizationBB orgnizationBB = new HOrgnizationBB();
                        HOrgnizationData orgnizationData = new HOrgnizationData();
                        try
                        {
                            orgnizationData = orgnizationBB.GetModel(this.IdValue);

                            this.ShowInfo(this.IdValue);
                        }
                        finally
                        {
                            orgnizationBB.Dispose();
                        }
                        break;
                    default:
                        break;
                }
            }
        }
    }
Exemplo n.º 4
0
 private void SetModel(ref HOrgnizationData model)
 {
     model.departNo = this.departNo.Text;
     model.departNm = this.departNm.Text;
     if (this.uppDepartId.Value != "")
     {
         model.uppDepartId = Convert.ToInt32(this.uppDepartId.Value);
     }
     else
     {
         model.uppDepartId = 0;
     }
     if (this.departLeader.Value != "")
     {
         model.departLeader = Convert.ToInt32(this.departLeader.Value);
     }
     else
     {
         model.departLeader = 0;
     }
     model.isEffect = this.isEffect.Checked;
     model.mark = this.mark.Text;
 }
Exemplo n.º 5
0
        //*****************************************************************************
        //do it later      do it later      do it later
        //*****************************************************************************
        /// <summary>
        /// �����ϼ����Ż�ȡ�����������±���
        /// </summary>
        /// <param name="uppDepartId">�ϼ�����Id</param>
        /// <returns></returns>
        public string GetNewDepartNo(int uppDepartId)
        {
            string uppDepartNo = "";
            if (uppDepartId != 0)
            {
                HOrgnizationData orgnizationData = new HOrgnizationData();
                orgnizationData = this.GetModel(uppDepartId);
                uppDepartNo = orgnizationData.departNo;
            }

            string newDepartNo = "";
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select max(departNo) as maxDepartNo from HOrgnization");
            strSql.Append(" where isnull(uppDepartId,0) = @uppDepartId");
            if (uppDepartId != 0)
            {
                strSql.Append(" and departNo like '" + uppDepartNo + "%'");
            }

            SqlParameter[] parameters = {
                    new SqlParameter("@uppDepartId", SqlDbType.Int)
                };
            parameters[0].Value = uppDepartId;

            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["maxDepartNo"] != DBNull.Value)
                {
                    string maxDepartNo = row["maxDepartNo"].ToString().Substring(uppDepartNo.Length);
                    newDepartNo = (Convert.ToInt32(maxDepartNo) + 1).ToString("00");
                }
                else
                {
                    newDepartNo = "01";
                }
            }
            else
            {
                newDepartNo = "01";
            }
            //��Ϊ��ϵͳȨ�޿�����ʹ�ò��ű���������Ȩ�޿��ƣ����������˲��ű�����Ͻ���Ҫ�󣬱�����ϱ�׼xx��λ�����ʽ
            if (newDepartNo.Length > 2)
                throw new Exception("���ű��볬����λ���ƣ�����ϵϵͳ����Ա���������ű������");
            newDepartNo = uppDepartNo + newDepartNo;

            return newDepartNo;
        }
Exemplo n.º 6
0
        /// <summary>
        /// ����һ������
        /// </summary>
        /// <param name="model">model</param>
        public bool ModifyRecord(HOrgnizationData model)
        {
            bool ret = false;
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update HOrgnization set ");
            strSql.Append("departNo=@departNo,");
            strSql.Append("departNm=@departNm,");
            strSql.Append("uppDepartId=@uppDepartId,");
            strSql.Append("departLeader=@departLeader,");
            strSql.Append("isEffect=@isEffect,");
            strSql.Append("isDel=@isDel,");
            strSql.Append("isrtDt=@isrtDt,");
            strSql.Append("isrtEmpId=@isrtEmpId,");
            strSql.Append("updtDt=@updtDt,");
            strSql.Append("updtEmpId=@updtEmpId,");
            strSql.Append("mark=@mark");
            strSql.Append(" where departId = @departId ");
            SqlParameter[] parameters = {
                    new SqlParameter("@departId", SqlDbType.Int),
                    new SqlParameter("@departNo", SqlDbType.NVarChar,10),
                    new SqlParameter("@departNm", SqlDbType.NVarChar,50),
                    new SqlParameter("@uppDepartId", SqlDbType.Int),
                    new SqlParameter("@departLeader", SqlDbType.Int),
                    new SqlParameter("@isEffect", SqlDbType.Bit),
                    new SqlParameter("@isDel", SqlDbType.Bit),
                    new SqlParameter("@isrtDt", SqlDbType.DateTime),
                    new SqlParameter("@isrtEmpId", SqlDbType.Int),
                    new SqlParameter("@updtDt", SqlDbType.DateTime),
                    new SqlParameter("@updtEmpId", SqlDbType.Int),
                    new SqlParameter("@mark", SqlDbType.NVarChar,500)
                };
            parameters[0].Value = model.departId;
            parameters[1].Value = model.departNo;
            parameters[2].Value = model.departNm;
            parameters[3].Value = model.uppDepartId;
            parameters[4].Value = model.departLeader;
            parameters[5].Value = model.isEffect;
            parameters[6].Value = model.isDel;
            parameters[7].Value = model.isrtDt == string.Empty ? null : model.isrtDt;
            parameters[8].Value = model.isrtEmpId;
            parameters[9].Value = model.updtDt == string.Empty ? null : model.updtDt;
            parameters[10].Value = model.updtEmpId;
            parameters[11].Value = model.mark;

            try
            {
                SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
                ret = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ret;
        }
Exemplo n.º 7
0
        /// <summary>
        /// �õ�һ��model
        /// </summary>
        /// <param name="departId">����ֵ</param>
        /// <returns>model</returns>
        public HOrgnizationData GetModel(int departId)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select departId,departNo,departNm,uppDepartId,departLeader,isEffect,isDel,isrtDt,isrtEmpId,updtDt,updtEmpId,mark from HOrgnization");
            strSql.Append(" where departId = @departId ");
            SqlParameter[] parameters = {
                    new SqlParameter("@departId", SqlDbType.Int)
                };
            parameters[0].Value = departId;

            HOrgnizationData model = new HOrgnizationData();
            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["departId"] != DBNull.Value)
                {
                    model.departId = Convert.ToInt32(row["departId"]);
                }
                if (row["departNo"] != DBNull.Value)
                {
                    model.departNo = Convert.ToString(row["departNo"]);
                }
                if (row["departNm"] != DBNull.Value)
                {
                    model.departNm = Convert.ToString(row["departNm"]);
                }
                if (row["uppDepartId"] != DBNull.Value)
                {
                    model.uppDepartId = Convert.ToInt32(row["uppDepartId"]);
                }
                if (row["departLeader"] != DBNull.Value)
                {
                    model.departLeader = Convert.ToInt32(row["departLeader"]);
                }
                if (row["isEffect"] != DBNull.Value)
                {
                    model.isEffect = Convert.ToBoolean(row["isEffect"]);
                }
                if (row["isDel"] != DBNull.Value)
                {
                    model.isDel = Convert.ToBoolean(row["isDel"]);
                }
                if (row["isrtDt"] != DBNull.Value)
                {
                    model.isrtDt = Convert.ToString(row["isrtDt"]);
                }
                if (row["isrtEmpId"] != DBNull.Value)
                {
                    model.isrtEmpId = Convert.ToInt32(row["isrtEmpId"]);
                }
                if (row["updtDt"] != DBNull.Value)
                {
                    model.updtDt = Convert.ToString(row["updtDt"]);
                }
                if (row["updtEmpId"] != DBNull.Value)
                {
                    model.updtEmpId = Convert.ToInt32(row["updtEmpId"]);
                }
                if (row["mark"] != DBNull.Value)
                {
                    model.mark = Convert.ToString(row["mark"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }
Exemplo n.º 8
0
 /// <summary>
 /// 获得当前部门
 /// </summary>
 /// <returns></returns>
 public HOrgnizationData GetCurrentDept()
 {
     HOrgnizationData departData = null;
     if (this.currentUser.nowDepartId != 0)
     {
         int departId = this.currentUser.nowDepartId;
         HOrgnizationBB departBB = new HOrgnizationBB();
         try
         {
             departData = departBB.GetModel(departId);
         }
         finally
         {
             departBB.Dispose();
         }
     }
     if (null == departData)
     {
         departData = new HOrgnizationData();
     }
     return departData;
 }
    /// <summary>
    /// ɾ��
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDel_Click(object sender, EventArgs e)
    {
        bool retChecked = false;
        HOrgnizationBB orgnizationBB = new HOrgnizationBB();
        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);
                    HOrgnizationData orgnizationData = new HOrgnizationData();
                    orgnizationData = orgnizationBB.GetModel(id);

                    orgnizationData.isDel = true;
                    orgnizationBB.ModifyRecord(orgnizationData);
                }
            }
        }
        catch (Exception ex)
        {
            this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",3);", true);
            return;
        }
        finally
        {
            orgnizationBB.Dispose();
        }

        if (retChecked)
        {
            this.BindGrid();
        }
    }
Exemplo n.º 10
0
        /// <summary>
        /// ����һ������
        /// </summary>
        /// <param name="model">model</param>
        public bool ModifyRecord(HOrgnizationData model)
        {
            //����ϼ����Ÿı䣬��ӱ������������в��ŵIJ��ű�����������
            if (model.uppDepartId != 0)
            {
                HOrgnizationData oldModel = new HOrgnizationData();
                oldModel = this.GetModel(model.departId);

                if (oldModel.uppDepartId != model.uppDepartId)
                {
                    model.departNo = this.GetNewDepartNo(model.uppDepartId);

                    this.orgnizationDB.ModifyRecord(model);

                    this.UpdateChildrenDepartNo(model.departId);
                }
                else
                {
                    this.orgnizationDB.ModifyRecord(model);
                }
            }
            else
            {
                this.orgnizationDB.ModifyRecord(model);
            }

            return true;
        }
Exemplo n.º 11
0
 /// <summary>
 /// ����һ������
 /// </summary>
 /// <param name="model">model</param>
 public int AddRecord(HOrgnizationData model)
 {
     //��ֵ���ű��
     model.departNo = this.GetNewDepartNo(model.uppDepartId);
     return this.orgnizationDB.AddRecord(model);
 }