コード例 #1
0
        /// <summary>
        /// 删除
        /// </summary>
        public override void EntityDelete()
        {
            FabricWHOutFormRule rule   = new FabricWHOutFormRule();
            FabricWHOutForm     entity = EntityGet();

            rule.RDelete(entity);
        }
コード例 #2
0
        /// <summary>
        /// 撤销提交
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public override void btnSubmitCancel_Click(object sender, EventArgs e)
        {
            try
            {
                //if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增))
                //{
                //    this.ShowMessage("你没有此操作权限");
                //    return;
                //}
                if (HTDataID == 0)
                {
                    this.ShowMessage("请选择要操作的记录");
                    return;
                }

                if (!CheckCorrect())
                {
                    return;
                }

                FabricWHOutFormRule rule = new FabricWHOutFormRule();
                rule.RSubmit(HTDataID, (int)ConfirmFlag.未提交);

                FCommon.AddDBLog(this.Text, FormStatus.撤消提交.ToString(), "ID:" + HTDataID, "");
                this.SetPosStatus(HTDataID);
            }
            catch (Exception E)
            {
                this.ShowMessage(E.Message);
            }
        }
コード例 #3
0
        //private void CreateCheckBox()
        //{
        //    //查询条件
        //    string condition = "";
        //    if (m_WHID != "")
        //    {
        //        condition += " AND WHID=" + SysString.ToDBString(m_WHID);
        //    }
        //    condition += " AND ItemCode=" + SysString.ToDBString(m_ItemCode);
        //    condition += " AND ColorNum=" + SysString.ToDBString(m_ColorNum);
        //    condition += " AND ColorName=" + SysString.ToDBString(m_ColorName);
        //    condition += " AND BoxStatusID=" + SysString.ToDBString((int)EnumBoxStatus.入库);
        //    condition += Condition2;

        //    //分区,缸号,批次
        //    string sql = "SELECT SectionID,JarNum,Batch FROM WH_PackBox ";
        //    sql += "WHERE 1=1 ";
        //    sql += condition;
        //    sql += " GROUP BY SectionID,JarNum,Batch";
        //    DataTable dtitemtype = SysUtils.Fill(sql);
        //    int XSIZE = 10;
        //    int YSIZE = 10;
        //    for (int i = 0; i < dtitemtype.Rows.Count; i++)
        //    {

        //        XSIZE = 10;
        //        string Context =SysConvert.ToInt32(i + 1).ToString()+ "、区:" + SysConvert.ToString(dtitemtype.Rows[i]["SectionID"]) + "、缸号:" + SysConvert.ToString(dtitemtype.Rows[i]["JarNum"]) + "、批次:" + SysConvert.ToString(dtitemtype.Rows[i]["Batch"]);
        //        string Name = SysConvert.ToInt32(i + 1).ToString();
        //        DevExpress.XtraEditors.CheckEdit chk = new DevExpress.XtraEditors.CheckEdit();
        //        groupControlMainten.Controls.Add(chk);
        //        chk.Location = new System.Drawing.Point(XSIZE, YSIZE);
        //        chk.Properties.Caption = Context;
        //        chk.Size = new System.Drawing.Size(320, 19);
        //        chk.Name = Name;
        //        chk.ForeColor = System.Drawing.Color.Black;
        //        chk.Tag = SysConvert.ToInt32(i + 1).ToString();
        //        chk.Font = new System.Drawing.Font("宋体", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(100)));

        //        DevExpress.XtraEditors.CheckEdit chkAll = new DevExpress.XtraEditors.CheckEdit();
        //        groupControlMainten.Controls.Add(chkAll);
        //        chkAll.Location = new System.Drawing.Point(XSIZE + 330, YSIZE);
        //        chkAll.Properties.Caption = "全选";
        //        chkAll.Size = new System.Drawing.Size(60, 19);
        //        chkAll.CheckedChanged += new System.EventHandler(chkAll_CheckedChanged);
        //        chkAll.Name = Name + "chk";
        //        chkAll.ForeColor = System.Drawing.Color.Black;
        //        chkAll.Tag = SysConvert.ToInt32(i + 1).ToString();
        //        chkAll.Font = new System.Drawing.Font("宋体", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(100)));

        //        //创建合计匹数/数量
        //        Label lbl = new Label();
        //        groupControlMainten.Controls.Add(lbl);
        //        lbl.Size = new System.Drawing.Size(150, 19);
        //        lbl.Location = new System.Drawing.Point(XSIZE + 450, YSIZE);
        //        lbl.Text = "";
        //        lbl.Name = "Label" + SysConvert.ToInt32(i + 1).ToString();
        //        lbl.ForeColor = System.Drawing.Color.Black;
        //        lbl.Tag = SysConvert.ToInt32(i + 1).ToString();
        //        lbl.Font = new System.Drawing.Font("宋体", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(100)));

        //        //创建选择匹数/数量
        //        Label lbl2 = new Label();
        //        groupControlMainten.Controls.Add(lbl2);
        //        lbl2.Size = new System.Drawing.Size(150, 19);
        //        lbl2.Location = new System.Drawing.Point(XSIZE + 600, YSIZE);
        //        lbl2.Text = "";
        //        lbl2.Name = "Label" + SysConvert.ToInt32(i + 1).ToString();
        //        lbl2.ForeColor = System.Drawing.Color.Black;
        //        lbl2.Tag = SysConvert.ToInt32(i + 1).ToString() + "lbl";
        //        lbl2.Font = new System.Drawing.Font("宋体", 11F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(100)));



        //        sql = "SELECT ID,Qty FROM WH_PackBox WHERE ISNULL(JarNum,'')=" + SysString.ToDBString(SysConvert.ToString(dtitemtype.Rows[i]["JarNum"]));
        //        sql += " AND ISNULL(Batch,'')=" + SysString.ToDBString(SysConvert.ToString(dtitemtype.Rows[i]["Batch"]));
        //        sql += " AND ISNULL(SectionID,'')=" + SysString.ToDBString(SysConvert.ToString(dtitemtype.Rows[i]["SectionID"]));
        //        sql += condition;
        //        DataTable dtsql = SysUtils.Fill(sql);
        //        int Num = 0;
        //        if (dtsql.Rows.Count <= 10)
        //        {
        //            Num = 1;
        //        }
        //        else
        //        {
        //            if (dtsql.Rows.Count % 10 == 0)
        //            {
        //                Num = dtsql.Rows.Count / 10;

        //            }
        //            else
        //            {
        //                Num = (dtsql.Rows.Count / 10) + 1;
        //            }
        //        }

        //        int ToolTip = 0;
        //        int PieceQty = 0;
        //        decimal Qty = 0;
        //        for (int j = 0; j < Num; j++)
        //        {
        //            XSIZE = 50;
        //            YSIZE = YSIZE + 25;
        //            for (int k = 1; k <= 10; k++)
        //            {

        //                int Index = k + j * 10;
        //                if (Index <= dtsql.Rows.Count)
        //                {
        //                    DataRow dr = dtsql.Rows[Index - 1];
        //                    DevExpress.XtraEditors.CheckEdit chk2 = new DevExpress.XtraEditors.CheckEdit();
        //                    groupControlMainten.Controls.Add(chk2);
        //                    chk2.Location = new System.Drawing.Point(XSIZE, YSIZE);
        //                    chk2.Properties.Caption = "" + SysConvert.ToInt32(ToolTip + 1).ToString() + ">" + SysConvert.ToString(dr["Qty"]);
        //                    chk2.Size = new System.Drawing.Size(82, 19);
        //                    chk2.CheckedChanged += new System.EventHandler(chk2_CheckedChanged);
        //                    chk2.Name = SysConvert.ToInt32(dr["ID"]).ToString();
        //                    chk2.Tag = SysConvert.ToInt32(i + 1);
        //                    chk2.ToolTip = ToolTip.ToString();
        //                    chk2.ForeColor = System.Drawing.Color.Black;
        //                    XSIZE = XSIZE + 80;

        //                    ToolTip++;
        //                    PieceQty++;
        //                    Qty += SysConvert.ToDecimal(dr["Qty"]);
        //                }

        //            }
        //        }

        //        lbl.Text = "合计:" + PieceQty.ToString() + " / " + Qty.ToString();
        //        YSIZE = YSIZE + 35;
        //    }



        //}


        ///// <summary>
        ///// 全选
        ///// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //private void chkAll_CheckedChanged(object sender, EventArgs e)
        //{
        //    try
        //    {
        //        DevExpress.XtraEditors.CheckEdit chk = (DevExpress.XtraEditors.CheckEdit)sender;
        //        foreach (Control c in groupControlMainten.Controls)
        //        {
        //            if (c is DevExpress.XtraEditors.CheckEdit)
        //            {

        //                if (((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString())
        //                {
        //                    ((DevExpress.XtraEditors.CheckEdit)c).Checked = chk.Checked;
        //                }


        //            }
        //        }
        //    }
        //    catch (Exception E)
        //    {
        //        this.ShowMessage(E.Message);
        //    }

        //}

        ///// <summary>
        ///// 子节点选择
        ///// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //private void chk2_CheckedChanged(object sender, EventArgs e)
        //{
        //    try
        //    {

        //        #region shift选择

        //        DevExpress.XtraEditors.CheckEdit chk = (DevExpress.XtraEditors.CheckEdit)sender;
        //        bool Find = false;
        //        int firstRow = 0;
        //        int endRow = 0;
        //        foreach (Control c in groupControlMainten.Controls)
        //        {
        //            if (c is DevExpress.XtraEditors.CheckEdit)
        //            {
        //                if (((DevExpress.XtraEditors.CheckEdit)c).Checked && ((DevExpress.XtraEditors.CheckEdit)c).ToolTip != chk.ToolTip)
        //                {
        //                    firstRow = SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip);
        //                    Find = true;
        //                    break;
        //                }
        //            }
        //        }

        //        foreach (Control c in groupControlMainten.Controls)
        //        {
        //            if (c is DevExpress.XtraEditors.CheckEdit)
        //            {
        //                if (((DevExpress.XtraEditors.CheckEdit)c).Checked && ((DevExpress.XtraEditors.CheckEdit)c).ToolTip != chk.ToolTip)
        //                {
        //                    endRow = SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip);
        //                }
        //            }
        //        }

        //        if ((Control.ModifierKeys & Keys.Shift) == Keys.Shift && Find)
        //        {
        //            int RID1 = 0;
        //            int RID2 = 0;

        //            if (chk.Checked)
        //            {
        //                if (firstRow > SysConvert.ToInt32(chk.ToolTip))
        //                {
        //                    RID1 = SysConvert.ToInt32(chk.ToolTip);
        //                    RID2 = firstRow;
        //                }
        //                else
        //                {
        //                    RID1 = firstRow;
        //                    RID2 = SysConvert.ToInt32(chk.ToolTip);
        //                }
        //                foreach (Control c in groupControlMainten.Controls)
        //                {
        //                    if (c is DevExpress.XtraEditors.CheckEdit)
        //                    {
        //                        if (SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip) >= RID1 && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip) <= RID2
        //                            && ((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString() && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).Name) > 100)
        //                        {
        //                            ((DevExpress.XtraEditors.CheckEdit)c).Checked = true;
        //                        }
        //                    }
        //                }
        //            }
        //            else
        //            {
        //                if (endRow > SysConvert.ToInt32(chk.ToolTip))
        //                {
        //                    RID1 = SysConvert.ToInt32(chk.ToolTip);
        //                    RID2 = endRow;
        //                }
        //                else
        //                {
        //                    RID1 = endRow;
        //                    RID2 = SysConvert.ToInt32(chk.ToolTip);
        //                }
        //                foreach (Control c in groupControlMainten.Controls)
        //                {
        //                    if (c is DevExpress.XtraEditors.CheckEdit)
        //                    {
        //                        if (SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip) >= RID1 && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).ToolTip) <= RID2
        //                            && ((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString() && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).Name) > 100)
        //                        {
        //                            ((DevExpress.XtraEditors.CheckEdit)c).Checked = false;
        //                        }
        //                    }
        //                }
        //            }
        //        }

        //        #endregion

        //        #region 显示选择的匹数和数量

        //        int PieceQty = 0;
        //        decimal Qty = 0;
        //        foreach (Control c in groupControlMainten.Controls)
        //        {
        //            if (c is DevExpress.XtraEditors.CheckEdit && ((DevExpress.XtraEditors.CheckEdit)c).Tag != null)
        //            {
        //                if (((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString() && ((DevExpress.XtraEditors.CheckEdit)c).Checked && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).Name) > 100)
        //                {
        //                    PieceQty++;
        //                    string[] TQty = ((DevExpress.XtraEditors.CheckEdit)c).Text.Split('>');
        //                    Qty += SysConvert.ToDecimal(TQty[1]);


        //                }
        //            }
        //        }

        //        foreach (Control c in groupControlMainten.Controls)
        //        {
        //            if (c is Label && ((Label)c).Tag != null)
        //            {
        //                if (((Label)c).Tag.ToString() == chk.Tag.ToString() + "lbl")
        //                {
        //                    ((Label)c).Text = "  选择:" + PieceQty.ToString() + " / " + Qty.ToString();
        //                }
        //            }
        //        }

        //        #endregion

        //        #region 如有一个选择,则父节点勾上

        //        if (PieceQty > 0)
        //        {
        //            foreach (Control c in groupControlMainten.Controls)
        //            {
        //                if (c is DevExpress.XtraEditors.CheckEdit && ((DevExpress.XtraEditors.CheckEdit)c).Tag != null && !((DevExpress.XtraEditors.CheckEdit)c).Name.Contains("chk"))
        //                {
        //                    if (((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString() && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).Name) < 100)
        //                    {
        //                        ((DevExpress.XtraEditors.CheckEdit)c).Checked = true;
        //                    }
        //                }
        //            }
        //        }
        //        else
        //        {
        //            foreach (Control c in groupControlMainten.Controls)
        //            {
        //                if (c is DevExpress.XtraEditors.CheckEdit && ((DevExpress.XtraEditors.CheckEdit)c).Tag != null && !((DevExpress.XtraEditors.CheckEdit)c).Name.Contains("chk"))
        //                {
        //                    if (((DevExpress.XtraEditors.CheckEdit)c).Tag.ToString() == chk.Tag.ToString() && SysConvert.ToInt32(((DevExpress.XtraEditors.CheckEdit)c).Name) < 100)
        //                    {
        //                        ((DevExpress.XtraEditors.CheckEdit)c).Checked = false;
        //                    }
        //                }
        //            }
        //        }
        //        #endregion



        //        if (chk.Checked)
        //        {
        //            chk.ForeColor = System.Drawing.Color.White;

        //        }
        //        else
        //        {
        //            chk.ForeColor = System.Drawing.Color.Black;
        //        }



        //    }
        //    catch (Exception E)
        //    {
        //        this.ShowMessage(E.Message);
        //    }

        //}
        #endregion

        #region  钮事件

        /// <summary>
        /// 保存事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string IDText = "";
                for (int i = 0; i < ucFabLoad1.UCSelectDataSource.Rows.Count; i++)
                {
                    if (IDText != "")
                    {
                        IDText += ",";
                    }
                    IDText += ucFabLoad1.UCSelectDataSource.Rows[i]["ID"].ToString();
                }

                if (m_PackType == (int)EnumPackType.仓库单据)
                {
                    IOFormDtsPackRule rul = new IOFormDtsPackRule();
                    rul.RAdd(m_ID, IDText);
                }
                else if (m_PackType == (int)EnumPackType.发货单据)
                {
                    FHFormDtsPackRule rul = new FHFormDtsPackRule();
                    rul.RAdd(m_ID, IDText);
                }
                else if (m_PackType == (int)EnumPackType.扣料单据)
                {
                    FabricWHOutFormRule rul = new FabricWHOutFormRule();
                    rul.RAdd(m_ID, IDText);
                }
                else if (m_PackType == (int)EnumPackType.扣料单据)
                {
                    DBFormDtsPackRule rul = new DBFormDtsPackRule();
                    rul.RAdd(m_ID, IDText);
                }


                m_SaveFlag = true;
                this.ShowInfoMessage("保存成功");
                this.Close();
            }
            catch (Exception E)
            {
                this.ShowMessage(E.Message);
            }
        }
コード例 #4
0
        /// <summary>
        /// 新增已存在事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        public override void btnInsertExist_Click(object sender, EventArgs e)
        {
            try
            {
                FabricWHOutFormRule rule = new FabricWHOutFormRule();
                string o_ErrMsg;
                if (!rule.RAddCheck(MainID, out o_ErrMsg))
                {
                    this.ShowMessage(o_ErrMsg);
                    return;
                }

                base.btnInsertExist_Click(sender, e);
            }
            catch (Exception E)
            {
                this.ShowMessage(E.Message);
            }
        }
コード例 #5
0
        /// <summary>
        /// 修改
        /// </summary>
        public override void EntityUpdate()
        {
            FabricWHOutFormRule rule   = new FabricWHOutFormRule();
            FabricWHOutForm     entity = EntityGet();

            FabricWHOutFormDts[] entitydts = EntityDtsGet();
            //decimal TotalQty = 0;
            //decimal TotalAmount = 0;
            //for (int i = 0; i < entitydts.Length; i++)
            //{
            //    TotalQty += SysConvert.ToDecimal(entitydts[i].Qty);
            //    TotalAmount += SysConvert.ToDecimal(entitydts[i].Amount);
            //}
            //entity.TotalQty = TotalQty;
            //entity.TotalAmount = TotalAmount;
            entity.SubmitFlag = this.HTSubmitFlagUpdateGet();

            rule.RUpdate(entity, entitydts);
        }