bool frm_CommonProcessSubmit(CustomFlowForm form, string advise)
        {
            FM_InstitutionProcess lnqProcess = (FM_InstitutionProcess)form.ResultInfo;

            if (!CheckData(lnqProcess))
            {
                return(false);
            }

            MessageDialog.ShowPromptMessage("请选择相关部门");

            FormDataTableCheck frmCheck = new FormDataTableCheck(UniversalFunction.GetAllDeptInfo());

            if (frmCheck.ShowDialog() == DialogResult.OK)
            {
                List <string> list = DataSetHelper.ColumnsToList_Distinct(frmCheck._DtResult, "部门代码");

                if (!m_serverInstitution.AddInfo(lnqProcess, list, out m_strErr))
                {
                    MessageDialog.ShowPromptMessage(m_strErr);
                    return(false);
                }
            }
            else
            {
                MessageDialog.ShowPromptMessage("请选择相关部门");
                return(false);
            }

            return(true);
        }
示例#2
0
        private void btnCourse_Click(object sender, EventArgs e)
        {
            if (cmbYearValue.Text.Trim().Length == 0)
            {
                MessageDialog.ShowPromptMessage("请选择【培训年份】");
                return;
            }

            FormDataTableCheck frm = new FormDataTableCheck(_ServiceCollect.GetCourseInfo(Convert.ToInt32(cmbYearValue.Text)));

            frm._BlDateTimeControlShow = false;
            frm._BlIsCheckBox          = false;

            if (frm.ShowDialog() == DialogResult.OK)
            {
                int courseID = Convert.ToInt32(frm._DtResult.Rows[0]["课程ID"]);
                View_HR_Train_Course courseInfo = _ServiceBasic.GetSingleCourseInfo(courseID);

                if (courseInfo != null)
                {
                    chbIsOutSide.Checked = (bool)courseInfo.外训;
                    txtClassHour.Text    = courseInfo.预计课时.ToString();
                    txtLecturer.Text     = courseInfo.推荐讲师;
                    numFund.Value        = (decimal)courseInfo.预计经费;
                    txtCourse.Text       = courseInfo.课程名;
                    txtCourse.Tag        = courseInfo.课程ID;
                    btnCourse.Tag        = frm._DtResult.Rows[0]["ID"].ToString();
                }
            }
        }
        private void btnShortcutSelect_Click(object sender, EventArgs e)
        {
            DataTable          tempTable = m_serverThreePacketsOfTheRepair.GetShortcutDetail(m_lnqBill.ProductType);
            FormDataTableCheck fdc       = new FormDataTableCheck(tempTable);

            if (fdc.ShowDialog() == DialogResult.OK)
            {
                List <View_YX_ThreePacketsOfTheRepairList> tempList =
                    m_serverThreePacketsOfTheRepair.GetShortcutDetailList(fdc._DtResult, out m_strErr);

                if (m_strErr != null && m_strErr.Trim().Length > 0)
                {
                    MessageDialog.ShowPromptMessage(m_strErr + "库存不足");
                }

                if (tempList != null)
                {
                    DataTable dt = (DataTable)dataGridView1.DataSource;

                    foreach (View_YX_ThreePacketsOfTheRepairList item in tempList)
                    {
                        bool flag = false;

                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            if (dt.Rows[i]["物品ID"].ToString() == item.物品ID.ToString() &&
                                dt.Rows[i]["批次号"].ToString() == item.批次号)
                            {
                                dt.Rows[i]["领用数量"] = Convert.ToDecimal(dt.Rows[i]["领用数量"]) + Convert.ToDecimal(item.领用数量);
                                flag = true;
                                break;
                            }
                        }

                        if (!flag)
                        {
                            DataRow dr = dt.NewRow();

                            dr["图号型号"]    = item.图号型号;
                            dr["物品名称"]    = item.物品名称;
                            dr["规格"]      = item.规格;
                            dr["批次号"]     = item.批次号;
                            dr["领用数量"]    = item.领用数量;
                            dr["单位"]      = item.单位;
                            dr["单价"]      = item.单价;
                            dr["金额"]      = item.金额;
                            dr["策略金额"]    = item.策略金额;
                            dr["备注"]      = item.备注;
                            dr["物品ID"]    = item.物品ID;
                            dr["单据号"]     = m_lnqBill.Bill_ID;
                            dr["是否为客户责任"] = item.是否为客户责任;

                            dt.Rows.Add(dr);
                        }
                    }

                    RefreshInfo(dt);
                }
            }
        }
        private void btnBatchCreate_Click(object sender, EventArgs e)
        {
            FormDataTableCheck frm =
                new FormDataTableCheck(m_goodsServer.GetBatchCreatList("领料", ServerTime.Time.AddDays(-20), ServerTime.Time));

            frm.OnFormDataTableCheckFind += new GlobalObject.DelegateCollection.FormDataTableCheckFindDelegate(frm_OnFormDataTableCheckFind1);
            frm._BlDateTimeControlShow    = true;

            if (frm.ShowDialog() == DialogResult.OK)
            {
                string strBillIDGather = "";

                foreach (DataRow dr in frm._DtResult.Rows)
                {
                    strBillIDGather += "'" + dr["领料单号"].ToString() + "',";
                }

                strBillIDGather = "(" + strBillIDGather.Remove(strBillIDGather.Length - 1) + ")";

                if (!m_goodsServer.BatchCreateList("领料", m_billNo, strBillIDGather, out m_error))
                {
                    MessageDialog.ShowPromptMessage(m_error);
                }
                else
                {
                    MessageDialog.ShowPromptMessage("生成成功");
                    this.Close();
                }

                m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
                RefreshDataGridView(m_queryGoodsInfo);
            }
        }
        private void btnGreenLight_Click(object sender, EventArgs e)
        {
            string error = null;

            Hashtable hsTable = new Hashtable();

            hsTable.Add("@BillNo", dgv_Show.CurrentRow.Cells["DJH"].Value.ToString());

            DataTable tempTable = GlobalObject.DatabaseServer.QueryInfoPro("S_Marketing_GreenLightInfo", hsTable, out error);

            FormDataTableCheck frm = new FormDataTableCheck(tempTable);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                if (frm._DtResult != null && frm._DtResult.Rows.Count > 0)
                {
                    List <ProductsCode_GreenLight> lstInfo = new List <ProductsCode_GreenLight>();

                    foreach (DataRow dr in frm._DtResult.Rows)
                    {
                        ProductsCode_GreenLight tempInfo = new ProductsCode_GreenLight();

                        tempInfo.F_Id        = Guid.NewGuid().ToString();
                        tempInfo.UserID      = BasicInfo.LoginID;
                        tempInfo.CreateTime  = ServerTime.Time;
                        tempInfo.GoodsID     = Convert.ToInt32(dr["物品ID"]);
                        tempInfo.ProductCode = dr["箱号"].ToString();

                        lstInfo.Add(tempInfo);
                    }

                    m_findSellIn.AddList_ProductCodesGreenLight(lstInfo);
                }
            }
        }
示例#6
0
        private void btnCollect_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbYear.Text.Trim().Length == 0)
                {
                    throw new Exception("请选择【计划年份】");
                }

                FormDataTableCheck frm = new FormDataTableCheck(_ServiceSurvey.GetBillInfo_Year(Convert.ToInt32(cmbYear.Text)));

                frm._BlDateTimeControlShow = false;
                frm._BlIsCheckBox          = true;

                if (frm.ShowDialog() == DialogResult.OK)
                {
                    if (frm._DtResult != null && frm._DtResult.Rows.Count > 0)
                    {
                        List <string> lstBillNo = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");
                        _ServiceCollect.GenerateCollectPlan_Year(lstBillNo, Convert.ToInt32(cmbYear.Text));
                        RefreshViewCourse(CE_HR_Train_PlanType.年度培训计划, Convert.ToInt32(cmbYear.Text), null);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageDialog.ShowPromptMessage(ex.Message);
            }
        }
        private void btnSelectDepartment_Click(object sender, EventArgs e)
        {
            IDepartmentServer service = ServerModule.ServerModuleFactory.GetServerModule <IDepartmentServer>();

            DataTable dtTemp = new DataTable();

            dtTemp.Columns.Add("部门编码");

            if (txtApplicableDepartment.Text.Trim().Length > 0)
            {
                foreach (string str in txtApplicableDepartment.Tag.ToString().Split(',').ToList())
                {
                    DataRow dr = dtTemp.NewRow();
                    dr["部门编码"] = str;
                    dtTemp.Rows.Add(dr);
                }
            }

            List <string> lstTemp = new List <string>();

            lstTemp.Add("部门编码");

            FormDataTableCheck frm = new FormDataTableCheck(service.GetDepartment_Finance(), dtTemp, lstTemp);

            frm._BlDateTimeControlShow = false;
            frm._BlIsCheckBox          = true;

            if (frm.ShowDialog() == DialogResult.OK)
            {
                txtApplicableDepartment.Text = "";
                txtApplicableDepartment.Tag  = "";

                foreach (DataRow dr in frm._DtResult.Rows)
                {
                    txtApplicableDepartment.Text += dr["部门名称"].ToString() + ",";
                    txtApplicableDepartment.Tag  += dr["部门编码"].ToString() + ",";
                }

                if (txtApplicableDepartment.Text.Trim().Length > 0)
                {
                    txtApplicableDepartment.Text =
                        txtApplicableDepartment.Text.Substring(0, txtApplicableDepartment.Text.Length - 1);
                    txtApplicableDepartment.Tag =
                        txtApplicableDepartment.Tag.ToString().Substring(0, txtApplicableDepartment.Tag.ToString().Length - 1);
                }
            }
        }
示例#8
0
        private void btnBenchCreate_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbBillType.Text.Trim().Length > 0)
                {
                    DataTable dataSource = m_serviceOutPut.GetReferenceInfo(cmbBillType.Text,
                                                                            txtApplyingDepartment.Tag == null ? null : txtApplyingDepartment.Tag.ToString(), chbIsRepeat.Checked);
                    FormDataTableCheck frm = new FormDataTableCheck(dataSource);
                    frm._BlDateTimeControlShow = false;

                    if (frm.ShowDialog() == DialogResult.OK)
                    {
                        List <string> listTemp = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");

                        string deptCode = "";
                        m_listViewDetail = m_serviceOutPut.GetReferenceListViewDetail(txtBillNo.Text, listTemp, chbIsRepeat.Checked, out deptCode);

                        if (m_listViewDetail != null)
                        {
                            txtApplyingDepartment.Text = UniversalFunction.GetDeptName(deptCode);
                            txtApplyingDepartment.Tag  = deptCode;

                            List <Business_WarehouseOutPut_Requisition> listRequisition =
                                m_serviceRequistion.GetListBillInfo(m_listViewDetail.Select(k => k.关联业务).Distinct().ToList());

                            cmbTypeDetail.DataSource = listRequisition.Select(k => k.BillTypeDetail).Distinct().ToList();
                            m_serverProductCode.InsertChangeProductCodesBillNo(listRequisition.Select(k => k.BillNo).ToList(), txtBillNo.Text);

                            customDataGridView1.Rows.Clear();
                            RefreshDataGridView(m_listViewDetail);
                        }
                    }

                    cmbBillType.Enabled = customDataGridView1.Rows.Count > 0 ? false : true;
                }
                else
                {
                    MessageDialog.ShowPromptMessage("请选择【业务类型】");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageDialog.ShowPromptMessage(ex.Message);
            }
        }
示例#9
0
        private void btnSetUser_Click(object sender, EventArgs e)
        {
            if (txtCourse.Text.Trim().Length == 0)
            {
                MessageDialog.ShowPromptMessage("请选择【课程】");
                return;
            }

            FormDataTableCheck frm = new FormDataTableCheck(_ServiceCollect.GetUserInfo(btnCourse.Tag.ToString()));

            frm._BlDateTimeControlShow = false;
            frm._BlIsCheckBox          = true;

            if (frm.ShowDialog() == DialogResult.OK)
            {
                List <string> lstWork = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "工号");
                btnSetUser.Tag = lstWork;
            }
        }
        private void btn_PostRel_Set_Click(object sender, EventArgs e)
        {
            DataTable     sourceTable = new DataTable();
            DataTable     checkTable  = new DataTable();
            List <string> lstkeys     = new List <string>();

            if (rb_PostRel_CourseToPost.Checked)
            {
                sourceTable = _ServiceBasicInfo.GetPostInfo(null);
                checkTable  = (DataTable)dgv_PostRel_Post.DataSource;
                lstkeys.Add("岗位编号");

                FormDataTableCheck frm = new FormDataTableCheck(sourceTable, checkTable, lstkeys);
                frm._BlDateTimeControlShow = false;
                frm._BlIsCheckBox          = true;

                if (frm.ShowDialog() == DialogResult.OK)
                {
                    _ServiceBasicInfo.Operation_PostRelation_CourseToPost(frm._DtResult,
                                                                          Convert.ToInt32(dgv_PostRel_Course.CurrentRow.Cells["课程ID4"].Value));
                    dgv_PostRel_Course_CellEnter(null, null);
                }
            }
            else if (rb_PostRel_PostToCourse.Checked)
            {
                sourceTable = _ServiceBasicInfo.GetCourseInfo(null);
                checkTable  = (DataTable)dgv_PostRel_Course.DataSource;
                lstkeys.Add("课程ID");

                FormDataTableCheck frm = new FormDataTableCheck(sourceTable, checkTable, lstkeys);
                frm._BlDateTimeControlShow = false;
                frm._BlIsCheckBox          = true;

                if (frm.ShowDialog() == DialogResult.OK)
                {
                    _ServiceBasicInfo.Operation_PostRelation_PostToCourse(frm._DtResult,
                                                                          Convert.ToInt32(dgv_PostRel_Post.CurrentRow.Cells["岗位编号"].Value));
                    dgv_PostRel_Post_CellEnter(null, null);
                }
            }
        }
示例#11
0
        private void btnSel_Click(object sender, EventArgs e)
        {
            Dictionary <CE_GoodsAttributeName, string> dic = new Dictionary <CE_GoodsAttributeName, string>();

            dic.Add(CE_GoodsAttributeName.自制件, "True");
            IEnumerable <F_GoodsPlanCost> iEnum = UniversalFunction.GetGoodsInfoList_Attribute(dic);

            DepotManagementDataContext ctx = CommentParameter.DepotDataContext;

            IQueryable iq = (from a in ctx.View_F_GoodsPlanCost
                             where iEnum.Select(k => k.ID).ToList().Contains(a.序号)
                             select a).AsQueryable <View_F_GoodsPlanCost>();

            DataTable tempTable = GlobalObject.GeneralFunction.ConvertToDataTable(iq);

            List <string> lstKeys = new List <string>();

            lstKeys.Add("序号");

            FormDataTableCheck frm = new FormDataTableCheck(tempTable, _ApplicableGoods, lstKeys);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                _ApplicableGoods = frm._DtResult;

                txtApplyToProductCode.Text = "";
                txtApplyToProductName.Text = "";

                foreach (DataRow dr in _ApplicableGoods.Rows)
                {
                    txtApplyToProductCode.Text += dr["图号型号"].ToString() + "、";
                    txtApplyToProductName.Text += dr["物品名称"].ToString() + "、";
                }

                txtApplyToProductCode.Text = txtApplyToProductCode.Text.Substring(0, txtApplyToProductCode.Text.Length - 1);
                txtApplyToProductName.Text = txtApplyToProductName.Text.Substring(0, txtApplyToProductName.Text.Length - 1);
            }
        }
        private void btnBenchCreate_Click(object sender, EventArgs e)
        {
            try
            {
                if (cmbBillType.Text.Trim().Length > 0)
                {
                    switch (GlobalObject.GeneralFunction.StringConvertToEnum <CE_InPutBusinessType>(cmbBillType.Text))
                    {
                    case CE_InPutBusinessType.生产采购:
                    case CE_InPutBusinessType.普通采购:
                    case CE_InPutBusinessType.委外采购:
                    case CE_InPutBusinessType.样品采购:

                        IQueryable <View_B_OrderFormInfo> findOrderFormInfo;
                        IOrderFormInfoServer orderFormServer = ServerModule.ServerModuleFactory.GetServerModule <IOrderFormInfoServer>();

                        if (!orderFormServer.GetAllOrderFormInfo(BasicInfo.ListRoles, BasicInfo.LoginID, out findOrderFormInfo, out m_strError))
                        {
                            MessageDialog.ShowErrorMessage(m_strError);
                            return;
                        }

                        DataTable          dataSource = GlobalObject.GeneralFunction.ConvertToDataTable <View_B_OrderFormInfo>(findOrderFormInfo);
                        FormDataTableCheck frm        = new FormDataTableCheck(dataSource);

                        frm._BlDateTimeControlShow = false;

                        if (frm.ShowDialog() == DialogResult.OK)
                        {
                            List <string> listTemp = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "订单号");

                            m_listViewDetail = m_serviceRequistion.GetListViewDetail_OrderForm(txtBillNo.Text, listTemp);
                            RefreshDataGridView(m_listViewDetail);
                        }

                        foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
                        {
                            ((DataGridViewTextBoxShowCell)dgvr.Cells["图号型号"]).m_EndSql =
                                " and 序号 in ( select GoodsID from B_OrderFormGoods where OrderFormNumber = '"
                                + dgvr.Cells["关联业务"].Value.ToString() + "')";
                            ((DataGridViewTextBoxShowCell)dgvr.Cells["批次号"]).ReadOnly = true;
                            ((DataGridViewTextBoxShowCell)dgvr.Cells["供应商"]).ReadOnly = true;
                        }

                        break;

                    default:
                        break;
                    }

                    cmbBillType.Enabled = customDataGridView1.Rows.Count > 0 ? false : true;
                }
                else
                {
                    MessageDialog.ShowPromptMessage("请选择【业务类型】");
                    return;
                }
            }
            catch (Exception ex)
            {
                MessageDialog.ShowPromptMessage(ex.Message);
                return;
            }
        }
        private void btnMaterialsTransfer_Click(object sender, EventArgs e)
        {
            if (m_lnqWSCode == null)
            {
                return;
            }

            FormDataTableCheck frm =
                new FormDataTableCheck(m_serverMaterials.GetMaterialsTransferInfo(m_lnqWSCode.WSCode));

            frm.OnFormDataTableCheckFind += new GlobalObject.DelegateCollection.FormDataTableCheckFindDelegate(frm_OnFormDataTableCheckFind);
            frm._BlDateTimeControlShow    = true;

            if (frm.ShowDialog() == DialogResult.OK)
            {
                List <string> listRequisition = DataSetHelper.ColumnsToList_Distinct(frm._DtResult, "单据号");

                DataTable tempTable =
                    m_serverMaterials.SumMaterialsTransferGoods(listRequisition,
                                                                (int)CE_SubsidiaryOperationType.物料转换后, (int)CE_SubsidiaryOperationType.领料退库,
                                                                m_lnqWSCode.WSCode);

                foreach (DataRow dr in tempTable.Rows)
                {
                    S_MaterialListReturnedInTheDepot goods = new S_MaterialListReturnedInTheDepot();

                    goods.Bill_ID = m_billNo;
                    goods.GoodsID = Convert.ToInt32(dr["物品ID"]);

                    StoreQueryCondition condition = new StoreQueryCondition();

                    condition.GoodsID   = Convert.ToInt32(txtCode.Tag);
                    condition.BatchNo   = dr["批次号"].ToString();
                    condition.StorageID = m_strStorage;

                    S_Stock tempStock = m_serverStock.GetStockInfo(condition);

                    if (tempStock != null)
                    {
                        goods.Provider        = tempStock.Provider;
                        goods.ProviderBatchNo = tempStock.ProviderBatchNo;
                    }
                    else
                    {
                        goods.Provider        = "";
                        goods.ProviderBatchNo = "";
                    }

                    goods.BatchNo        = dr["批次号"].ToString();
                    goods.ReturnedAmount = Convert.ToDecimal(dr["数量"]);
                    goods.Remark         = txtRemark.Text;
                    goods.ShelfArea      = "";
                    goods.ColumnNumber   = "";
                    goods.LayerNumber    = "";

                    //产品状态 设置 2012.3.30 by cjb
                    if (cmbProductStatus.Text.Trim() != "")
                    {
                        if (cmbProductStatus.Text.Trim() == "已返修")
                        {
                            goods.RepairStatus = true;
                        }
                        else
                        {
                            goods.RepairStatus = false;
                        }
                    }

                    if (!m_goodsServer.AddGoods(goods, out m_error))
                    {
                        MessageDialog.ShowErrorMessage(m_error);
                        return;
                    }
                }

                m_queryGoodsInfo = m_goodsServer.GetGoods(m_billNo);
                RefreshDataGridView(m_queryGoodsInfo);
            }
        }
示例#14
0
        private void btnInputAccountInfo_Click(object sender, EventArgs e)
        {
            if (txtSettlementCompany.Text.Trim().Length == 0)
            {
                MessageBox.Show("请选择【结算单位】");
                return;
            }

            DataTable dtTemp = _Service_Account.LeadInputAccount(txtSettlementCompany.Tag.ToString());

            DataTable tempTable = new DataTable();

            List <string> lstKeys = new List <string>();

            lstKeys.Add("挂账年月");
            lstKeys.Add("物品ID");

            foreach (string keysName in lstKeys)
            {
                tempTable.Columns.Add(keysName);
            }

            foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
            {
                DataRow drNew = tempTable.NewRow();

                drNew["挂账年月"] = dgvr.Cells["挂账年月"].Value.ToString();
                drNew["物品ID"] = Convert.ToInt32(dgvr.Cells["GoodsID"].Value);

                tempTable.Rows.Add(drNew);
            }

            FormDataTableCheck frm = new FormDataTableCheck(dtTemp, tempTable, lstKeys);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                if (frm._DtResult == null)
                {
                    return;
                }

                foreach (DataRow dr in frm._DtResult.Rows)
                {
                    bool flag = false;

                    foreach (DataGridViewRow dgvr in customDataGridView1.Rows)
                    {
                        if (dgvr.Cells["GoodsID"].Value.ToString() == dr["物品ID"].ToString() &&
                            dgvr.Cells["挂账年月"].Value.ToString() == dr["挂账年月"].ToString())
                        {
                            flag = true;
                            break;
                        }
                    }

                    if (!flag)
                    {
                        decimal price = Math.Round((decimal)dr["协议单价"] / (1 + Convert.ToDecimal(dr["税率"]) / 100) * (decimal)dr["应挂数量"], 2);

                        View_F_GoodsPlanCost goodsInfo = UniversalFunction.GetGoodsInfo((int)dr["物品ID"]);

                        customDataGridView1.Rows.Add(new object[] { dr["图号型号"].ToString(), dr["物品名称"].ToString(), dr["规格"].ToString(),
                                                                    dr["挂账年月"].ToString(), (decimal)dr["协议单价"], (int)dr["税率"], goodsInfo.单位, (decimal)dr["应挂数量"],
                                                                    (decimal)dr["应挂数量"], price, price, "", txtBillNo.Text, (int)dr["物品ID"] });
                    }
                }
            }

            SumPrice();
        }