示例#1
0
        public DataSet Order_Input_M_Item_Data(string MakerItemCD)
        {
            DataSet ds = new DataSet();
            BaseDL  dl = new BaseDL();

            if (!string.IsNullOrWhiteSpace(MakerItemCD))
            {
                string[]       itemcd = MakerItemCD.Split(',');
                SqlParameter[] prms   = new SqlParameter[9];
                for (int i = 0; i < itemcd.Count(); i++)
                {
                    prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
                    {
                        Value = itemcd[i].ToString()
                    };
                }
                for (int i = itemcd.Count(); i < 8; i++)
                {
                    prms[i] = new SqlParameter("@MakerItemCD" + i, SqlDbType.VarChar)
                    {
                        Value = ""
                    };
                }
                prms[8] = new SqlParameter("@CompanyCD", SqlDbType.VarChar)
                {
                    Value = "1001"
                };
                ds = dl.SelectDataSet("OrderInput_M_Item_Select", prms);
            }

            return(ds);
        }
示例#2
0
        public DataSet _GetReportData(string OrderID)
        {
            DataSet      ds  = new DataSet();
            SqlParameter prm = new SqlParameter();

            if (OrderID == null)
            {
                prm = new SqlParameter("@OrderID", SqlDbType.VarChar)
                {
                    Value = DBNull.Value
                };
            }
            else
            {
                prm = new SqlParameter("@OrderID", SqlDbType.VarChar)
                {
                    Value = OrderID
                };
            }

            ds = dl.SelectDataSet("Order_History_Report", prm);
            return(ds);
        }