mes-client/UAS-MES/FunctionCode/Warehouse/Warehouse_ProdDetail.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_MES.DataOperate;
using UAS_MES.PublicMethod;

namespace UAS_MES.Warehouse
{
    public partial class Warehouse_ProdDetail : Form
    {
        DataTable dbfind;

        DataHelper dh;
        LogStringBuilder sql = new LogStringBuilder();

        //页面Caller
        string caller;

        string pim_inoutno;
        string pd_piid;

        public Warehouse_ProdDetail(string pim_inoutno,string pd_piid)
        {
            dh = new DataHelper();
            InitializeComponent();
            this.pim_inoutno = pim_inoutno;
            this.pd_piid = pd_piid;
        }

        private void Warehouse_ProdDetail_Load(object sender, EventArgs e)
        {
            sql.Clear();
            sql.Append("select pd_prodcode,pr_detail,outqty ,nvl((select count(1) from prodiomac where pim_inoutno='"+pim_inoutno+"' and pim_prodcode=pd_prodcode),0) getqty ");
            sql.Append("from (select pd_prodcode,sum(pd_outqty) outqty from prodiodetail ");
            sql.Append("where pd_piid='"+pd_piid+"'group by pd_prodcode) left join product on pr_code=pd_prodcode");
            dbfind = (DataTable)dh.ExecuteSql(sql.GetString(),"select");
            BaseUtil.FillDgvWithDataTable(InOutDetailDGV, dbfind);
            for (int i = 0; i < InOutDetailDGV.Rows.Count; i++)
            {
                InOutDetailDGV.Rows[i].Cells["ungetqty"].Value = (int.Parse(InOutDetailDGV.Rows[i].Cells["outqty"].Value.ToString()) - int.Parse(InOutDetailDGV.Rows[i].Cells["getqty"].Value.ToString())).ToString();
            }
        }
    }
}