Пример #1
0
        /// <summary>
        /// 反结帐操作
        /// </summary>
        private void UnCheckOut()
        {
            string strSQL = "";

            DataLib.DataHelper myHelper = new DataLib.DataHelper();

            DataSet ds = myHelper.GetDs("select * from t_Period where F_Year = " + intYear.ToString() + " and F_Month = " + intMonth.ToString());

            if (ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show(this, "本期还没结帐,不能进行此操作!", "提示");
                return;
            }
            if (MessageBox.Show(this, "真的要对当前月份进行会计反结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            ds = myHelper.GetDs("select isnull(max(Aid),0) + 1 as F_MaxID from t_Period");
            decimal decID = Convert.ToDecimal(ds.Tables[0].Rows[0][0]);

            if (myHelper.ExecuteSQL("delete from t_Period where F_Year = " + intYear.ToString() + " and F_Month = " + intMonth.ToString()) == 0)
            {
                strSQL = "delete from t_cwCheckOut where F_Year = " + intYear.ToString() + " and F_Month = " + intMonth.ToString();

                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    MessageBox.Show(this, "本期反结帐帐成功!!", "提示");
                    Close();
                }
            }
        }
Пример #2
0
        protected override void DataDel()
        {
            base.DataDel();
            frmDelLog myDelLog = new frmDelLog();

            if (myDelLog.ShowDialog() == DialogResult.OK)
            {
                DataLib.DataHelper myHeler = new DataLib.DataHelper();
                if (myDelLog.ckAll.Checked == true)
                {
                    if (myHeler.ExecuteSQL("truncate table t_UserLog") == 0)
                    {
                        BindData();
                    }
                }
                else
                {
                    string strStart = myDelLog.deStart.EditValue.ToString() + " 00:00:00";
                    string strEnd   = myDelLog.deEnd.EditValue.ToString() + " 23:59:59";
                    if (myHeler.ExecuteSQL("delete from t_UserLog where F_Time >= '" + strStart + "' and F_Time <='" + strEnd + "'") == 0)
                    {
                        BindData();
                    }
                }
            }
            myDelLog.Dispose();
        }
Пример #3
0
        private void sbOK_Click(object sender, EventArgs e)
        {
            if (txtID.Text.Length == 0)
            {
                MessageBox.Show(this, "编码不能为空!!", "提示");
                txtID.Focus();
                return;
            }

            if (txtName.Text.Length == 0)
            {
                MessageBox.Show(this, "名称不能为空!!", "提示");
                txtName.Focus();
                return;
            }

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (strID == "")
            {
                myHelper.ExecuteSQL("insert into t_Assist values('" + strType + "','" + txtID.Text + "','" + txtName.Text + "')");
            }
            else
            {
                myHelper.ExecuteSQL("update t_Assist set F_Name = '" + txtName.Text + "' where F_Type = '" + strType + "' and F_ID = '" + strID + "'");
            }

            this.DialogResult = DialogResult.OK;
        }
Пример #4
0
        /// <summary>
        /// 结帐操作
        /// </summary>
        private void CheckOut()
        {
            if (MessageBox.Show(this, "真的要对当前月份进行会计结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }
            string strSQL = "";

            DataLib.DataHelper myHelper = new DataLib.DataHelper();

            DataSet ds = myHelper.GetDs("select top 1 * from t_Certificate where isnull(F_Record,0) = 0 and Year(F_Date) = " + intYear.ToString() + " and Month(F_Date) = " + intMonth.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                MessageBox.Show(this, "本期存在未登帐的凭证,请先登帐,再进行此操作!", "提示");
                return;
            }

            ds = myHelper.GetDs("select isnull(max(Aid),0) + 1 as F_MaxID from t_Period");
            decimal decID = Convert.ToDecimal(ds.Tables[0].Rows[0][0]);

            if (myHelper.ExecuteSQL("insert into t_Period(Aid,F_Year,F_Month) values(" + decID.ToString() + "," + intYear.ToString() + "," + intMonth.ToString() + ")") == 0)
            {
                strSQL = "insert into t_cwCheckOut(F_Year,F_Month,F_Subject,F_Debit,F_Credit) select " + intYear.ToString() + "," + intMonth.ToString() + ",b.F_Subject,sum(b.F_Debit),sum(b.F_Credit)";
                strSQL = strSQL + " from t_Certificate a,t_CertificateDetail b where a.F_ID = b.F_ID and Year(a.F_Date) = " + intYear.ToString() + " and Month(a.F_Date) = " + intMonth.ToString();
                strSQL = strSQL + " group by b.F_Subject";

                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    MessageBox.Show(this, "本月结帐帐成功!!", "提示");
                    Close();
                }
            }
        }
Пример #5
0
        /// <summary>
        /// 库存反结帐
        /// </summary>
        private void UnStoreCheck()
        {
            string   strSQL   = "";
            DateTime dtValue  = Convert.ToDateTime(dtMonth.EditValue);
            string   strYear  = dtValue.Year.ToString();
            string   strMonth = dtValue.Month.ToString().PadLeft(2, '0');
            string   strValue = strYear + strMonth;

            strSQL = "select top 1 * from t_StorageCheck where F_Month = '" + strValue + "'";
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            DataSet            ds       = myHelper.GetDs(strSQL);

            if (ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show("本月还没进行库存结帐,不能反结帐!!");
                return;
            }

            if (MessageBox.Show(this, "真的要对本月进行库存反结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            strSQL = "delete from t_StorageCheck where F_Month = '" + strValue + "'";
            if (myHelper.ExecuteSQL(strSQL) == 0)
            {
                strSQL = "delete from t_CheckMonth where F_Month = '" + strValue + "'";
                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    MessageBox.Show("反结帐成功!!");
                }
            }
        }
Пример #6
0
        private void AutoGenClass()
        {
            if (lupClass.GetValue() == null)
            {
                MessageBox.Show(this, "请先选择班次!", "提示");
                lupClass.Focus();
                return;
            }
            if (MessageBox.Show(this, "真的要重新生成排班吗,这将覆盖现在的结果,真的要这样做吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }
            DataTable dt = (DataTable)gridEmp.DataSource;

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            foreach (DataRow dr in dt.Rows)
            {
                int iDays = DateTime.DaysInMonth(mkMonth.Value.Year, mkMonth.Value.Month);
                for (int i = 1; i <= iDays; i++)
                {
                    DateTime dtDate = new DateTime(mkMonth.Value.Year, mkMonth.Value.Month, i);
                    string   strSQL = "insert into t_ArrangeClass(F_Month,F_ID,F_Day,F_Class) values('" + mkMonth.Text + "','" + dr["F_ID"].ToString() + "','" + dtDate.ToString() + "','" + lupClass.GetValue().ToString() + "')";
                    myHelper.ExecuteSQL(strSQL);
                }
            }
            DataRow drm = viewEmp.GetDataRow(viewEmp.FocusedRowHandle);

            DataBind(drm["F_ID"].ToString());
        }
Пример #7
0
        /*
         * private void BindFactory()
         * {
         *  DataLib.DataHelper myHelper = new DataLib.DataHelper();
         *  DataSet ds = myHelper.GetDs("select F_ID,F_Name from t_Factory");
         *  lupFactory.Properties.DataSource = ds.Tables[0].DefaultView;
         *  lupFactory.Properties.DisplayMember = "F_Name";
         *  lupFactory.Properties.ValueMember = "F_ID";
         * }
         */

        private void BtnOK_Click(object sender, EventArgs e)
        {
            SetInfo();
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            DataSet            ds       = myHelper.GetDs("select a.*,b.F_View,isnull(b.F_Salesman,0) as F_Salesman from t_User a,t_UserGroup b where a.F_Group = b.F_Group and a.F_ID = '" + txtUID.Text + "' and a.F_Psw = '" + txtPsw.Text + "'");

            if (ds.Tables[0].Rows.Count == 0)
            {
                MessageBox.Show(this, "密码错误,请查证!!", "提示");
                txtPsw.SelectAll();
                txtPsw.Focus();
                base.DialogResult = DialogResult.None;
                return;
            }

            myHelper.ExecuteSQL("update t_User set F_Login = 1 where F_ID = '" + txtUID.Text + "'");

            DataLib.SysVar.IniWriteValue("Database", "Account", lupAccount.EditValue.ToString(), "C:\\Set.ini");
            DataSet dsTmp = myHelper.GetDs("select * from t_CompanyInfo");

            DataLib.SysVar.strUID         = txtUID.Text;
            DataLib.SysVar.strUName       = txtUName.Text;
            DataLib.SysVar.strUGroup      = ds.Tables[0].Rows[0]["F_Group"].ToString();
            DataLib.SysVar.blnSaleMan     = Convert.ToBoolean(ds.Tables[0].Rows[0]["F_Salesman"]);
            DataLib.SysVar.blnInit        = Convert.ToBoolean(dsTmp.Tables[0].Rows[0]["F_Use"]);
            DataLib.SysVar.strCompany     = dsTmp.Tables[0].Rows[0]["F_Company"].ToString();
            DataLib.SysVar.blnView        = Convert.ToBoolean(ds.Tables[0].Rows[0]["F_View"]);
            DataLib.SysVar.blnStorageFlag = DataLib.SysVar.GetParmValue("F_N10");
            DataLib.SysVar.strAccount     = lupAccount.Text;
        }
Пример #8
0
        private void sbOK_Click(object sender, EventArgs e)
        {
            if (textEdit1.Text.Length == 0)
            {
                MessageBox.Show(this, "用户组不能为空!!");
                return;
            }

            int iFlag = 0;

            if (checkEdit1.Checked == true)
            {
                iFlag = 1;
            }

            string strSQL = "";

            if (strGroup == "")
            {
                strSQL = string.Format("insert into t_UserGroup(F_Group,F_View,F_Salesman) values('{0}',{1},{2})", textEdit1.Text, 0, iFlag);
            }
            else
            {
                strSQL = string.Format("update t_UserGroup set F_Group = '{0}',F_Salesman = {1} where F_Group = '{2}'", textEdit1.Text, iFlag, strGroup);
            }

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL(strSQL) == 0)
            {
                this.DialogResult = DialogResult.OK;
            }
        }
Пример #9
0
        /// <summary>
        /// 删除
        /// </summary>
        protected override void Del()
        {
            base.Del();
            if (gvList.FocusedRowHandle < 0)
            {
                return;
            }
            DataRow dr = gvList.GetDataRow(gvList.FocusedRowHandle);

            /*
             * if (Convert.ToBoolean(dr["F_Check"]) == true)
             * {
             *  MessageBox.Show(this, "不能删除已审核的记录!!", "提示");
             *  return;
             * }
             */
            if (MessageBox.Show(this, "真的要删除选定记录吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL("delete from t_AssetReduce where Aid = '" + dr["Aid"].ToString() + "'") == 0)
            {
                gvList.DeleteRow(gvList.FocusedRowHandle);
            }
        }
Пример #10
0
        private void btnSQL_Click(object sender, EventArgs e)
        {
            if (gridView1.RowCount == 0)
            {
                return;
            }
            DataRow dr   = gridView1.GetDataRow(gridView1.FocusedRowHandle);
            string  sSQL = "select isnull(F_SQL,'') as F_SQL from t_ReportFormat where F_FormName = '" + sFormName + "' and F_ReportName = '" + dr["F_ReportName"].ToString() + "'";

            DataLib.DataHelper myHelper  = new DataLib.DataHelper();
            DataSet            ds        = myHelper.GetDs(sSQL);
            string             sPrintSQL = "";

            if (ds.Tables[0].Rows.Count > 0)
            {
                sPrintSQL = ds.Tables[0].Rows[0][0].ToString();
            }
            frmPrintSQL F = new frmPrintSQL();

            F.sBillID    = this.sBillID;
            F.meSQL.Text = sPrintSQL;
            if (F.ShowDialog() == DialogResult.OK)
            {
                sSQL = string.Format("update t_ReportFormat set F_SQL = '{0}' where F_FormName = '{1}' and F_ReportName = '{2}'", F.meSQL.Text, sFormName, dr["F_ReportName"].ToString());
                myHelper.ExecuteSQL(sSQL);
            }
            F.Dispose();
        }
Пример #11
0
        private void sbOK_Click(object sender, EventArgs e)
        {
            if (textEdit2.Text.Length == 0)
            {
                MessageBox.Show("请输入类别编码!!", "揭示");
                textEdit2.Focus();
                return;
            }

            if (textEdit3.Text.Length == 0)
            {
                MessageBox.Show("请输入类别名称!!", "揭示");
                textEdit3.Focus();
                return;
            }
            string strID  = textEdit1.Text + textEdit2.Text;
            string strSQL = "";

            if (strCID == "")
            {
                strSQL = "insert into t_Class(F_UPID,F_ID,F_Name,F_Tag,F_Table,F_Key) values('" + strPID + "','" + strID + "','" + textEdit3.Text + "','0','" + strTable + "','" + strKey + "')";
            }
            else
            {
                strSQL = "update t_Class set F_Name = '" + textEdit3.Text + "' where F_ID = '" + strCID + "'";
            }


            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL(strSQL) == 0)
            {
                this.DialogResult = DialogResult.OK;
            }
        }
Пример #12
0
        /// <summary>
        /// 删除
        /// </summary>
        protected override void Del()
        {
            if (gvList.FocusedRowHandle < 0)
            {
                return;
            }
            DataRow dr = gvList.GetDataRow(gvList.FocusedRowHandle);

            if (Convert.ToBoolean(dr["F_Check"]) == true)
            {
                MessageBox.Show(this, "不能删除已审核的单据!!", "提示");
                return;
            }
            if (MessageBox.Show(this, "真的要删除选定单据吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL("delete from t_Certificate where F_ID = " + dr["F_ID"].ToString()) == 0)
            {
                BindData();
            }

            base.Del();
        }
Пример #13
0
        private void sbOK_Click(object sender, EventArgs e)
        {
            if (textEdit1.Text != textEdit2.Text)
            {
                MessageBox.Show("校验新密码错!!", "提示");
                textEdit2.Focus();
                return;
            }

            if (textEdit1.Text.Length == 0)
            {
                if (MessageBox.Show(this, "你要将本用户密码设为空吗!!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
                {
                    textEdit1.Focus();
                    return;
                }
            }
            string strSQL = "update t_User set F_Psw = '" + textEdit1.Text + "' where F_ID = '" + strID + "'";

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL(strSQL) == 0)
            {
                Close();
            }
        }
Пример #14
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (txtReport.txtEdit.Text == "")
            {
                MessageBox.Show("报表名称不能为空!!", "提示");
                txtReport.Focus();
                return;
            }

            string sSQL = "";

            if (sReportName == "")
            {
                sSQL = string.Format("insert into t_ReportFormat(F_FormName,F_ReportName) values('{0}','{1}')", sFormName, txtReport.txtEdit.Text);
            }
            else
            {
                sSQL = string.Format("update t_ReportFormat set F_ReportName = '{0}' where F_FormName = '{1}' and F_ReportName = {2}", txtReport.txtEdit.Text, sFormName, sReportName);
            }

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL(sSQL) == 0)
            {
                this.DialogResult = DialogResult.OK;
            }
        }
Пример #15
0
        private void Add(object sender, EventArgs e)
        {
            if (comboBoxEdit1.SelectedIndex < 0)
            {
                MessageBox.Show(this, "请选择审核步骤!", "提示");
                return;
            }

            if (lookUpEdit2.EditValue == DBNull.Value)
            {
                MessageBox.Show(this, "请选择审核人!", "提示");
                return;
            }

            if (comboBoxEdit3.SelectedIndex < 0)
            {
                MessageBox.Show(this, "请选择下一步!", "提示");
                return;
            }

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            string             sSQL     = string.Format("insert into t_MultCheck(F_BillType,F_CheckLevel,F_CheckMan,F_NextLevel) values('{0}',{1},'{2}',{3})", comboBoxEdit2.Text, comboBoxEdit1.Text, lookUpEdit2.EditValue, comboBoxEdit3.Text);

            if (myHelper.ExecuteSQL(sSQL) == 0)
            {
                DataBind(comboBoxEdit2.Text);
            }
        }
Пример #16
0
        private void sbOK_Click(object sender, EventArgs e)
        {
            string strSQL = "";

            if (txtName.Text.Length == 0)
            {
                MessageBox.Show("报表名称不能为空!!", "提示");
                txtName.Focus();
                return;
            }

            if (cbType.Text.Length == 0)
            {
                MessageBox.Show("报表名称不能为空!!", "提示");
                cbType.Focus();
                return;
            }
            DataLib.DataHelper myHelper = new DataLib.DataHelper();

            if (pFlag == false)
            {
                strSQL = "insert into t_UserReport(F_Name,F_Type) values('" + txtName.Text + "','" + cbType.Text + "')";
            }
            else
            {
                strSQL = "update t_UserReport set F_Name = '" + txtName.Text + "',F_Type = '" + cbType.Text + "' where F_Name = '" + strName + "'";
            }

            if (myHelper.ExecuteSQL(strSQL) == 0)
            {
                this.DialogResult = DialogResult.OK;
            }
        }
Пример #17
0
        private void DoKQ(DataRow dr, string dField, string tField)
        {
            DateTime dtTime = Convert.ToDateTime(dr["F_Time"]);


            string strSQL = @" if not Exists (select * from t_CardRecord
                                    where YEAR(F_Date) = " + dtTime.Year.ToString() + @"
                                    and MONTH(F_Date) = " + dtTime.Month.ToString() + @"
                                    and DAY(F_Date) = " + dtTime.Day.ToString() + @"
                                    and F_ID = '" + dr["F_EmpID"].ToString() + @"')
                                   begin
                                     insert into t_CardRecord(F_Date,F_ID," + dField + ") values('" + dtTime.ToString() + "','" + dr["F_EmpID"].ToString() + "','" + dr[tField].ToString() + @"')
                                   end
                                   else
                                   begin
                                     update t_CardRecord set " + dField + " = '" + dr[tField].ToString() + "' where YEAR(F_Date) = " + dtTime.Year.ToString() + @"
                                     and MONTH(F_Date) = " + dtTime.Month.ToString() + @"
                                     and DAY(F_Date) = " + dtTime.Day.ToString() + @"
                                     and F_ID = '" + dr["F_EmpID"].ToString() + @"'
                                   end  

                                   update t_RealCard set F_Flag = 1 where Aid = " + dr["Aid"].ToString();

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            myHelper.ExecuteSQL(strSQL);
        }
Пример #18
0
        private void DelRow(object sender, EventArgs e)
        {
            if (viewField.FocusedRowHandle < 0)
            {
                return;
            }

            DataRow dr = viewField.GetDataRow(viewField.FocusedRowHandle);

            if (Convert.ToBoolean(dr["F_Sys"]) == true)
            {
                MessageBox.Show(this, "不能删除系统预设字段!", "提示");
                return;
            }
            if (MessageBox.Show(this, "真的要删除选定的数据列吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            string strSQL = "";

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (dr["F_Type"].ToString() == "计算字段")
            {
                strSQL = "delete from t_SysField where F_TableName = '" + dr["F_TableName"].ToString() + "' and F_FieldName = '" + dr["F_FieldName"].ToString() + "'";
                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    viewField.DeleteRow(viewField.FocusedRowHandle);
                    RefreshField(tvTable.SelectedNode.Tag.ToString());
                }
            }
            else
            {
                strSQL = "exec sp_uDropColumn '" + dr["F_TableName"].ToString() + "','" + dr["F_FieldName"].ToString() + "'";

                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    strSQL = "delete from t_SysField where F_TableName = '" + dr["F_TableName"].ToString() + "' and F_FieldName = '" + dr["F_FieldName"].ToString() + "'";
                    if (myHelper.ExecuteSQL(strSQL) == 0)
                    {
                        viewField.DeleteRow(viewField.FocusedRowHandle);
                        RefreshField(tvTable.SelectedNode.Tag.ToString());
                    }
                }
            }
        }
Пример #19
0
        /// <summary>
        /// 应收款结帐
        /// </summary>
        private void AcceptCheck()
        {
            string   strSQL  = "";
            DateTime dtValue = Convert.ToDateTime("1900-1-1");
            //DateTime dtValue = Convert.ToDateTime(deAccept.EditValue);
            string strYear  = dtValue.Year.ToString();
            string strMonth = dtValue.Month.ToString().PadLeft(2, '0');
            string strValue = strYear + strMonth;

            strSQL = "select top 1 * from t_AcceptCheck where F_Month = '" + strValue + "'";
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            DataSet            ds       = myHelper.GetDs(strSQL);

            if (ds.Tables[0].Rows.Count > 0)
            {
                MessageBox.Show("本月已结过帐!!");
                return;
            }
            ds.Dispose();

            if (MessageBox.Show(this, "真的要对本月进行收款结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            //deAccept.Enabled = false;
            //lbAccept.Visible = true;
            //groupBox3.Update();
            try
            {
                /*
                 * ds = myHelper.GetDs("sp_noAcceptCheck '" + dtValue.ToString() + "'");
                 *
                 * if (ds.Tables[0].Rows.Count > 0)
                 * {
                 *  MessageBox.Show("本月存在未审核的单据");
                 *  frmNoCheck myNoCheck = new frmNoCheck();
                 *  myNoCheck.dtValue = dtValue;
                 *  myNoCheck.ShowDialog();
                 *  myNoCheck.Dispose();
                 *  return;
                 * }
                 * ds.Dispose();
                 */
                //strSQL = "sp_AcceptCheck '" + dePay.EditValue.ToString() + "'";
                strSQL = "";
                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    MessageBox.Show("结帐操作成功!!");
                }
            }
            finally
            {
                //deAccept.Enabled = true;
                //lbAccept.Visible = false;
            }
        }
Пример #20
0
        /// <summary>
        /// 删除原数据
        /// </summary>
        /// <returns></returns>
        private int DelData()
        {
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            StreamReader       sr       = File.OpenText(strPath + "t_SQL.txt");
            string             strSQL   = sr.ReadToEnd();

            sr.Dispose();
            return(myHelper.ExecuteSQL(strSQL));
        }
Пример #21
0
        /// <summary>
        /// 库存结帐
        /// </summary>
        private void StoreCheck()
        {
            string   strSQL   = "";
            DateTime dtValue  = Convert.ToDateTime(dtMonth.EditValue);
            string   strYear  = dtValue.Year.ToString();
            string   strMonth = dtValue.Month.ToString().PadLeft(2, '0');
            string   strValue = strYear + strMonth;

            strSQL = "select top 1 * from t_StorageCheck where F_Month = '" + strValue + "'";
            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            DataSet            ds       = myHelper.GetDs(strSQL);

            if (ds.Tables[0].Rows.Count > 0)
            {
                MessageBox.Show("本月已结过帐!!");
                return;
            }
            ds.Dispose();

            if (MessageBox.Show(this, "真的要对本月进行库存结帐吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            dtMonth.Enabled = false;
            lbFlag.Visible  = true;
            groupBox1.Update();
            try
            {
                ds = myHelper.GetDs("sp_noCheck '" + dtValue.ToString() + "'");

                if (ds.Tables[0].Rows.Count > 0)
                {
                    MessageBox.Show("本月存在未审核的单据");
                    frmNoCheck myNoCheck = new frmNoCheck();
                    myNoCheck.dtValue = dtValue;
                    myNoCheck.ShowDialog();
                    myNoCheck.Dispose();
                    return;
                }
                ds.Dispose();

                strSQL = "sp_StorageCheck '" + dtMonth.EditValue.ToString() + "'";

                if (myHelper.ExecuteSQL(strSQL) == 0)
                {
                    MessageBox.Show("结帐操作成功!!");
                }
            }
            finally
            {
                dtMonth.Enabled = true;
                lbFlag.Visible  = false;
            }
        }
Пример #22
0
        private void AddOtherField()
        {
            int iCheck = 0;

            if (ckNull.Checked == true)
            {
                iCheck = 1;
            }
            string strSQL = string.Format("insert into t_SysField values('{0}','{1}','{2}','{3}','{4}','{5}',{6},'{7}','{8}','{9}',{10},{11},'{12}','{13}','{14}')", strModuleName, strTableText, strTableName, txtFielText.Text, txtField.Text, cbType.Text, msLength.Text, txtDefault.Text, richTextBox1.Text, strExpress, iCheck.ToString(), 0, richTextBox2.Text, txtDispField.Text, txtValueField.Text);

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            myHelper.ExecuteSQL(strSQL);
        }
Пример #23
0
 private void btnOK_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show(this, "真的要启用财务系统吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
     {
         return;
     }
     DataLib.DataHelper myHelper = new DataLib.DataHelper();
     if (myHelper.ExecuteSQL("update t_CompanyInfo set F_cwInit = 1,F_cwInitDate = '" + DateTime.Now + "'") == 0)
     {
         MessageBox.Show(this, "财务系统启用成功!!", "提示");
     }
     btnOK.Enabled = false;
 }
Пример #24
0
 protected override void CheckBill()
 {
     //base.CheckBill();
     if (MessageBox.Show(this, "真的要审核本单吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
     {
         return;
     }
     DataLib.DataHelper myHelper = new DataLib.DataHelper();
     if (myHelper.ExecuteSQL("update " + strMTable + " set F_ReCheck = 1,F_ReCheckMan = '" + DataLib.SysVar.strUName + "',F_ReCheckDate = '" + DataLib.SysVar.GetDate().ToString() + "' where F_BillID = '" + editControl1.GetValue().ToString() + "'") == 0)
     {
         SetStatus(3);
     }
 }
Пример #25
0
 /// <summary>
 /// 生成当月工资
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void sbGen_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show(this, "真的要生成本月工资吗,这将刷新当前结果,慎用!!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
     {
         DataLib.DataHelper myHelper = new DataLib.DataHelper();
         string             strSQL   = "";
         strSQL = "sp_GenGroupWage '" + GetDate() + "'";
         if (myHelper.ExecuteSQL(strSQL) == 0)
         {
             DataBind();
         }
     }
 }
Пример #26
0
 private void BankIni()
 {
     if (MessageBox.Show(this, "启用期初后将不能再修改,真的要启用银行期初吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
     {
         return;
     }
     DataLib.DataHelper myHelper = new DataLib.DataHelper();
     if (myHelper.ExecuteSQL("update t_CashInit set F_BankIni = " + spinEdit1.Value.ToString() + ",F_Bank = 1") == 0)
     {
         spinEdit1.Enabled = false;
         sbOK.Enabled      = false;
         MessageBox.Show(this, "银行期初启用成功!!", "提示");
     }
 }
Пример #27
0
 /// <summary>
 /// 生成当月工资
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 private void sbGen_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show(this, "真的要生成本月工资吗,这将刷新当前结果,慎用!!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
     {
         DataLib.DataHelper myHelper = new DataLib.DataHelper();
         string             strSQL   = "";
         int intMonth = cbMonth.SelectedIndex + 1;
         strSQL = "s_CalWage " + spYear.Text + "," + intMonth.ToString();
         if (myHelper.ExecuteSQL(strSQL) == 0)
         {
             DataBind();
         }
     }
 }
Пример #28
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAddTime F = new frmAddTime();

            if (F.ShowDialog() == DialogResult.OK)
            {
                DataLib.DataHelper myHelper = new DataLib.DataHelper();
                if (myHelper.ExecuteSQL("insert into t_SetTime(F_Time) values('" + F.meTime.Text + "')") == 0)
                {
                    DataBind();
                }
            }
            F.Dispose();
        }
Пример #29
0
 private void sbDel_Click(object sender, EventArgs e)
 {
     if (gvMain.FocusedRowHandle < 0)
     {
         return;
     }
     if (MessageBox.Show(this, "真的要删除选定用户吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
     {
         return;
     }
     DataLib.DataHelper myHelper = new DataLib.DataHelper();
     if (myHelper.ExecuteSQL("delete from t_AddType where F_Name = '" + gvMain.GetRowCellValue(gvMain.FocusedRowHandle, "F_Name").ToString() + "'") == 0)
     {
         gvMain.DeleteRow(gvMain.FocusedRowHandle);
     }
 }
Пример #30
0
        private void Del()
        {
            if (lvModule.SelectedItems.Count == 0)
            {
                return;
            }
            if (MessageBox.Show(this, "真的要删选定模块吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
            {
                return;
            }

            DataLib.DataHelper myHelper = new DataLib.DataHelper();
            if (myHelper.ExecuteSQL("delete from t_UserModule where F_Parent = '" + tvParent.SelectedNode.Text + "' and F_ModuleName = '" + lvModule.SelectedItems[0].Text + "'") != -1)
            {
                lvModule.SelectedItems[0].Remove();
            }
        }