Exemple #1
0
        public int UpdataEmpInfo(EmpPostModel empPostModel)
        {

            SqlParameter[] para = new SqlParameter[] {

                new SqlParameter("@CodeSenderAddress",SqlDbType.Int),
                new SqlParameter("@TerritorialID",SqlDbType.Int),
                new SqlParameter("@WorkTime",SqlDbType.Int),
                new SqlParameter("@Remark",SqlDbType.NVarChar,200)
            };

            para[0].Value = empPostModel.CodeSenderAddress;
            para[1].Value = empPostModel.TerritorialID;
            para[2].Value = empPostModel.WorkTime;
            para[3].Value = empPostModel.Remark;

            return dbacc.ExecuteSql("zjw_EmpPost_UpData", para);
        }
Exemple #2
0
        private void btnAddOrModify_Click(object sender, EventArgs e)
        {
            if (ValidateEmp())
            {
                EmpPostModel empPostModel = new EmpPostModel();
                
                int intWorkTime;

                try
                {
                    empPostModel.CodeSenderAddress = Convert.ToInt32(txt_CodeSenderAddress.Text.Trim());
                    empPostModel.TerritorialID = Convert.ToInt32(ddlAreaNameAdd.SelectedValue.ToString());
                }
                catch
                {
                    return;
                }
                try
                {
                    intWorkTime = Convert.ToInt32(txt_Hour.Text.Trim()) * 3600 + Convert.ToInt32(txt_Minute.Text.Trim()) * 60 + Convert.ToInt32(txt_Second.Text.Trim());
                }
                catch 
                {
                    intWorkTime = 3600;
                }

                empPostModel.WorkTime = intWorkTime;
                empPostModel.Remark = txtRemark.Text.Trim();

                if (PanelModify.CaptionTitle.Equals("添加员工岗位信息"))          //添加
                {
                    if (epbll.InsertEmpInfo(empPostModel) > 0)
                    {
                        MessageBox.Show("添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        
                        if (!New_DBAcess.IsDouble)
                        {
                            GetEmpPostInfo();
                        }
                        else
                        {
                            timer1.Stop();
                            timer1.Start();
                        }
                    }
                    else
                    {
                        MessageBox.Show("添加失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                }
                else                                            //修改
                {
                    if (epbll.UpDataEmpInfo(empPostModel) > 0)
                    {
                        MessageBox.Show("修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                        
                        if (!New_DBAcess.IsDouble)
                        {
                            GetEmpPostInfo();
                        }
                        else
                        {
                            timer1.Stop();
                            timer1.Start();
                        }
                    }
                    else
                    {
                        MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                    }
                }
            }
        }
Exemple #3
0
        public int UpDataEmpInfo(EmpPostModel empPostModel)
        {

            return epdal.UpdataEmpInfo(empPostModel);
        }
Exemple #4
0
        public int InsertEmpInfo(EmpPostModel empPostModel)
        {

            return epdal.InsertEmpInfo(empPostModel);
        }