using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.Model.Stock;

using WMS.IData;using Oracle.ManagedDataAccess.Client;
using WMS.IData.IStock;
using System.Data;

namespace WMS.SqlServerData.StockData
{
    public class StorageRepData : IStorageRep
    {
        #region 获得流水号
        /// <summary>
        /// 获取流水号
        /// </summary>
        /// <returns></returns>
        public string GetNextValNum()
        {
            string strSqlSeq = "";
            strSqlSeq = "select   NEXT VALUE FOR SEQ_STOCK_STORAGEREP_ID";

            DataTable dt = SystemDataObject.Instance.GetDataTable(strSqlSeq);
            string strSEQ = "CB" + DateTime.Now.ToString("yyyyMMdd") + dt.Rows[0][0].ToString();
            return strSEQ;
        }
        #endregion



        #region 查询主表信息
        /// <summary>
        /// 查询仓库间调拨数据信息
        /// </summary>
        /// <param name="stoModel">仓库间调拨Model</param>
        /// <returns></returns>
        public DataTable GetStorageRepData(StorageRepModel stoModel)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"  select t.storep_id, --供应商补货单据编号
                               t.totalout_num, --出库总量
                               t.create_man, --创建人
                               a.Name                create_man_name, --创建人名称
                               t.confirm_man, --审核人
                               b.Name                confirm_man_name, --审核人名称      
                               t.operatorid, --用户编号
                               c.Name OPERATOR_NAME,--录入人
                               t.operatedate, --录入时间                      
                               t.create_date, --创建时间
                               t.confirm_date, --确认时间
                               t.expect_date, --预计到货时间
                               t.stostart_id, --出库仓库编号
                               s.storage_name        stostart_name, --出库仓库名称
                               t.stoend_id, --目的仓库编号
                               y.storage_name        stoend_name, --目的仓库名称
                               t.storep_status, --单据Status
                               t.remark, --备注
                               t.resion, --补货原因编号
                               sy.vc_dictionary_name RESION_NAME, --补货原因
                               t.shippers, --承运商
                               t.ori_bill, --来源单号
                               t.version, --版本号
                               t.print_count --打印次数
                          from T_STOCK_STOREP t --仓库间调拨表
                          left join T_BASE_USERINFO a --用户表
                            on t.create_man = a.user_id
                          left join T_BASE_USERINFO b --用户表
                            on t.Confirm_man = b.user_id
                            left join T_BASE_USERINFO c --用户表
                            on t.operatorid = c.user_id
                          left join T_BASE_STORAGEINFO s --仓库表
                            on t.stostart_id = s.storage_id
                          left join t_Base_Storageinfo y --仓库表
                            on t.stoend_id = y.storage_id
                          left join T_SYS_DICTIONARY_TAB sy --字典表
                            on t.resion = sy.vc_dictionary_id
                         where 1 = 1
");
            #region 查询条件
            if (!string.IsNullOrEmpty(stoModel.STOREP_ID))
            {
                strSql.Append(" and t.storep_id like'%" + stoModel.STOREP_ID + "%'");
            }
            if (!string.IsNullOrEmpty(stoModel.CREATE_MAN))
            {
                strSql.Append(" and t.CREATE_MAN like '%" + stoModel.CREATE_MAN + "%'");
            }
            if (!string.IsNullOrEmpty(stoModel.CONFIRM_MAN))
            {
                strSql.Append(" and t.CONFIRM_MAN like '%" + stoModel.CONFIRM_MAN + "%'");
            }
            //if (!string.IsNullOrEmpty(stoModel.REVIEW_MAN))
            //{
            //    strSql.Append(" and t.REVIEW_MAN like '%" + stoModel.REVIEW_MAN + "%'");
            //}
            if (!string.IsNullOrEmpty(stoModel.RESION))
            {
                strSql.Append(" and t.resion like '%" + stoModel.RESION + "%'");
            }
            if (stoModel.TIMESTART != DateTime.MinValue && stoModel.TIMEEND != DateTime.MinValue)
            {
                strSql.Append(" and   t.create_DATE between convert(varchar(100),'" + stoModel.TIMESTART.ToString("yyyy-MM-dd") + "',20) and convert(varchar(100),'" + stoModel.TIMEEND.ToString("yyyy-MM-dd") + "',20)");
            }
            strSql.Append(" order by t.create_date desc");
            #endregion

            return SystemDataObject.Instance.GetDataTable(strSql.ToString());

        }
        #endregion
        #region 查询明细表信息
        /// <summary>
        /// 查询仓库间调拨明细数据
        /// </summary>
        /// <param name="stoid">仓库间调拨ID</param>
        /// <returns></returns>
        public DataTable GetStorageRepInfoData(string stoid)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"select s.storep_id,
                               s.goods_id,
                               g.goods_name         GOODS_NAME,
                               s.goodsout_count,
                               g.cost_price,
                               s.goodsout_count*g.cost_price sum_cost_price,
                               t.vc_dictionary_name UNIT_NAME,
                               s.remark,
                               s.price,
                               s.unit,
                               s.sumprice,
                               s.shevls_num
                          from T_STOCK_STOREP_INFO s
                          left join t_Base_Goods g
                            on s.goods_id = g.goods_id
                          left join T_SYS_DICTIONARY_TAB t
                            on s.unit = t.vc_char_value
                         where 1 = 1  and t.vc_dictionary_type='vc_uom'
");
            if (!string.IsNullOrEmpty(stoid))
            {
                strSql.Append(" and s.STOREP_ID = '" + stoid + "'");
            }
            strSql.Append(" order by s.storep_id desc");
            return SystemDataObject.Instance.GetDataTable(strSql.ToString());
        }

        #endregion

        #region 同时新增 主表明细表数据
        /// <summary>
        /// 同时新增 主表和明细表数据
        /// </summary>
        /// <param name="model">主表Model</param>
        /// <param name="listmodel">明细表Model集合</param>
        public void InsertStorageRepData(StorageRepModel model, List<StorageRepInfoModel> listmodel)
        {
            StringBuilder strSql = new StringBuilder();
            List<string> addsqlstrlist = new List<string>();
            List<OracleParameter[]> addsqlpara = new List<OracleParameter[]>();


            strSql.Append("insert into T_STOCK_STOREP(");
            strSql.Append("STOREP_ID,TOTALOUT_NUM,CREATE_MAN,CONFIRM_MAN,CREATE_DATE,CONFIRM_DATE,EXPECT_DATE,STOSTART_ID,STOEND_ID,STOREP_STATUS,REMARK,VERSION,RESION,PRINT_COUNT,SHIPPERS,ORI_BILL,OPERATORID,OPERATEDATE)");
            strSql.Append(" values (");
            strSql.Append(":STOREP_ID,:TOTALOUT_NUM,:CREATE_MAN,:CONFIRM_MAN,:CREATE_DATE,:CONFIRM_DATE,:EXPECT_DATE,:STOSTART_ID,:STOEND_ID,:STOREP_STATUS,:REMARK,:VERSION,:RESION,:PRINT_COUNT,:SHIPPERS,:ORI_BILL,:OPERATORID,:OPERATEDATE)");
            OracleParameter[] parameters = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":TOTALOUT_NUM", OracleDbType.Decimal,4),
					new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CONFIRM_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CREATE_DATE", OracleDbType.Date),
					new OracleParameter(":CONFIRM_DATE", OracleDbType.Date),
					new OracleParameter(":EXPECT_DATE", OracleDbType.Date),
					new OracleParameter(":STOSTART_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOEND_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOREP_STATUS", OracleDbType.Char,1),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
					new OracleParameter(":RESION",OracleDbType.Varchar2,200),
                   new OracleParameter(":PRINT_COUNT",OracleDbType.Decimal),
                   new OracleParameter(":SHIPPERS",OracleDbType.Varchar2,50),
                   new OracleParameter(":ORI_BILL",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATORID",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATEDATE",OracleDbType.Date)
               };
            parameters[0].Value = model.STOREP_ID;
            parameters[1].Value = model.TOTALOUT_NUM;
            parameters[2].Value = model.CREATE_MAN;
            parameters[3].Value = model.CONFIRM_MAN;
           // parameters[4].Value = model.REVIEW_MAN;
            parameters[4].Value = model.CREATE_DATE;
            parameters[5].Value = model.CONFIRM_DATE;
           // parameters[7].Value = model.REVIEW_DATE;
            parameters[6].Value = model.EXPECT_DATE;
            parameters[7].Value = model.STOSTART_ID;
            parameters[8].Value = model.STOEND_ID;
            parameters[9].Value = model.STOREP_STATUS;
            parameters[10].Value = model.REMARK;
            parameters[11].Value = model.VERSION;
            parameters[12].Value = model.RESION;
            parameters[13].Value = model.PRINT_COUNT;
            parameters[14].Value = model.SHIPPERS;
            parameters[15].Value = model.ORI_BILL;
            parameters[16].Value = model.OPERATORID;
            parameters[17].Value = model.OPERATEDATE;
            addsqlstrlist.Add(strSql.ToString());
            addsqlpara.Add(parameters);

            foreach (StorageRepInfoModel info in listmodel)
            {
                strSql = new StringBuilder();
                strSql.Append("insert into T_STOCK_STOREP_INFO(");
                strSql.Append("STOREP_ID,GOODS_ID,GOODSOUT_COUNT,REMARK,VERSION,SHEVLS_NUM,PRICE,UNIT,SUMPRICE)");
                strSql.Append(" values (");
                strSql.Append(":STOREP_ID,:GOODS_ID,:GOODSOUT_COUNT,:REMARK,:VERSION,:SHEVLS_NUM,:PRICE,:UNIT,:SUMPRICE)");
                OracleParameter[] parameter = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                  	new OracleParameter(":SHEVLS_NUM", OracleDbType.Decimal,4),                
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),                    
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),                   
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),                    
                                              };
                parameter[0].Value = info.STOREP_ID;
                parameter[1].Value = info.GOODS_ID;
                parameter[2].Value = info.GOODSOUT_COUNT;
                parameter[3].Value = info.REMARK;
                parameter[4].Value = info.VERSION;
                parameter[5].Value = info.SHEVLS_NUM;
                parameter[6].Value = info.PRICE;
                parameter[7].Value = info.UNIT;
                parameter[8].Value = info.SUMPRICE;

                addsqlstrlist.Add(strSql.ToString());
                addsqlpara.Add(parameter);
                strSql.Clear();

            }
            SystemDataObject.Instance.ExecuteList(addsqlstrlist, addsqlpara);
        }
        #endregion

        #region 同时更新 主表明细表数据
        /// <summary>
        /// 同时更新 主表明细表数据
        /// </summary>
        /// <param name="model">仓库间调拨主表Model</param>
        /// <param name="listmodel">仓库间调拨明细表Model集合</param>
        public void UpdateStorageRepData(StorageRepModel model, List<StorageRepInfoModel> listmodel)
        {
            StringBuilder strSql = new StringBuilder();
            List<string> updatesqlstrlist = new List<string>();
            List<OracleParameter[]> updatesqlpara = new List<OracleParameter[]>();

            strSql.Append("update T_STOCK_STOREP set ");
            strSql.Append("TOTALOUT_NUM=:TOTALOUT_NUM,");
            strSql.Append("CREATE_MAN=:CREATE_MAN,");
            strSql.Append("CONFIRM_MAN=:CONFIRM_MAN,");
            strSql.Append("CREATE_DATE=:CREATE_DATE,");
            strSql.Append("CONFIRM_DATE=:CONFIRM_DATE,");
            strSql.Append("EXPECT_DATE=:EXPECT_DATE,");
            strSql.Append("STOSTART_ID=:STOSTART_ID,");
            strSql.Append("STOEND_ID=:STOEND_ID,");
            strSql.Append("STOREP_STATUS=:STOREP_STATUS,");
            strSql.Append("RESION=:RESION,");
            strSql.Append("REMARK=:REMARK,");
            strSql.Append("VERSION=:VERSION,");
            strSql.Append("PRINT_COUNT=:PRINT_COUNT,");
            strSql.Append("SHIPPERS=:SHIPPERS,");
            strSql.Append("OPERATORID=:OPERATORID,");
            strSql.Append("OPERATEDATE=:OPERATEDATE,");
            strSql.Append("ORI_BILL=:ORI_BILL");
            strSql.Append(" where STOREP_ID=:STOREP_ID");
            OracleParameter[] parameters = {
					
					new OracleParameter(":TOTALOUT_NUM", OracleDbType.Decimal,4),
					new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CONFIRM_MAN",OracleDbType.Varchar2,30),
					//new OracleParameter(":REVIEW_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CREATE_DATE", OracleDbType.Date),
					new OracleParameter(":CONFIRM_DATE", OracleDbType.Date),
					//new OracleParameter(":REVIEW_DATE", OracleDbType.Date),
					new OracleParameter(":EXPECT_DATE", OracleDbType.Date),
					new OracleParameter(":STOSTART_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOEND_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOREP_STATUS", OracleDbType.Char,1),
                   new OracleParameter(":RESION",OracleDbType.Varchar2,200),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":PRINT_COUNT",OracleDbType.Decimal),
                   new OracleParameter(":SHIPPERS",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATORID",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATEDATE",OracleDbType.Date),
	               new OracleParameter(":ORI_BILL",OracleDbType.Varchar2,50),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)};

            parameters[0].Value = model.TOTALOUT_NUM;
            parameters[1].Value = model.CREATE_MAN;
            parameters[2].Value = model.CONFIRM_MAN;
           // parameters[3].Value = model.REVIEW_MAN;
            parameters[3].Value = model.CREATE_DATE;
            parameters[4].Value = model.CONFIRM_DATE;
            //parameters[6].Value = model.REVIEW_DATE;
            parameters[5].Value = model.EXPECT_DATE;
            parameters[6].Value = model.STOSTART_ID;
            parameters[7].Value = model.STOEND_ID;
            parameters[8].Value = model.STOREP_STATUS;
            parameters[9].Value = model.RESION;
            parameters[10].Value = model.REMARK;
            parameters[11].Value = model.VERSION;
            parameters[12].Value = model.PRINT_COUNT;
            parameters[13].Value = model.SHIPPERS;
            parameters[14].Value = model.OPERATORID;
            parameters[15].Value = model.OPERATEDATE;
            parameters[16].Value = model.ORI_BILL;
            parameters[17].Value = model.STOREP_ID;
            updatesqlstrlist.Add(strSql.ToString());
            updatesqlpara.Add(parameters);

            foreach (StorageRepInfoModel info in listmodel)
            {
                strSql = new StringBuilder();
        
                strSql.Append("update T_STOCK_STOREP_INFO set ");
                strSql.Append("GOODSOUT_COUNT=:GOODSOUT_COUNT,");
                strSql.Append("REMARK=:REMARK,");
                strSql.Append("PRICE=:PRICE,");
                strSql.Append("UNIT=:UNIT,");
                strSql.Append("SUMPRICE=:SUMPRICE,");
                strSql.Append("VERSION=:VERSION");
                strSql.Append(" where STOREP_ID=:STOREP_ID and GOODS_ID=:GOODS_ID ");
                OracleParameter[] parameter = {
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)};

                parameter[0].Value = info.GOODSOUT_COUNT;
                parameter[1].Value = info.REMARK;
                parameter[2].Value = info.PRICE;
                parameter[3].Value = info.UNIT;
                parameter[4].Value = info.SUMPRICE;
                parameter[5].Value = info.VERSION;
                parameter[6].Value = info.STOREP_ID;
                parameter[7].Value = info.GOODS_ID;
                updatesqlstrlist.Add(strSql.ToString());
                updatesqlpara.Add(parameter);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(updatesqlstrlist, updatesqlpara);
        }
        #endregion

        #region 同时删除 主表明细表数据
        /// <summary>
        /// 同时删除 主表明细表数据
        /// </summary>
        /// <param name="listmodel"></param>
        public void DeleteStorageRepData(List<string> listmodel)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> delsqlstrlist = new List<string>();
            List<OracleParameter[]> delsqlpara = new List<OracleParameter[]>();

            foreach (string stDel in listmodel)
            {
                strSql.Append("delete from T_STOCK_STOREP ");
                strSql.Append(" where STOREP_ID=:STOREP_ID ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)};
                parameters[0].Value = stDel;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
                strSql.Clear();
            }

            foreach (string str in listmodel)
            {
                strSql = new StringBuilder();
                strSql.Append("delete from T_STOCK_STOREP_INFO ");
                strSql.Append(" where STOREP_ID=:STOREP_ID   ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)		
                                               };
                parameters[0].Value = str;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
                strSql.Clear();
            }

            //foreach (string strmes in listmodel)
            //{
            //    strSql = new StringBuilder();
            //    strSql.Append("delete from T_BASE_MESSAGE ");
            //    strSql.Append(" where RELATIVE_NUMBER=:RELATIVE_NUMBER ");
            //    OracleParameter[] parametersss = {
            //   new OracleParameter(":RELATIVE_NUMBER",OracleDbType.Varchar2)
            //};
            //    parametersss[0].Value = strmes;
            //    delsqlstrlist.Add(strSql.ToString());
            //    delsqlpara.Add(parametersss);
            //    strSql.Clear();
            //}
            SystemDataObject.Instance.ExecuteList(delsqlstrlist, delsqlpara);
        }
        #endregion







        /// <summary>
        /// 单独增加明细数据
        /// </summary>
        public void Add(List<StorageRepInfoModel> list)
        {
            StringBuilder strSql = new StringBuilder();
            List<string> sqlstrlist = new List<string>();
            List<OracleParameter[]> sqlpara = new List<OracleParameter[]>();
            foreach (StorageRepInfoModel model in list)
            {
                strSql = new StringBuilder();
                strSql = new StringBuilder();
                strSql.Append("insert into T_STOCK_STOREP_INFO(");
                strSql.Append("STOREP_ID,GOODS_ID,GOODSOUT_COUNT,REMARK,VERSION,SHEVLS_NUM,PRICE,UNIT,SUMPRICE)");
                strSql.Append(" values (");
                strSql.Append(":STOREP_ID,:GOODS_ID,:GOODSOUT_COUNT,:REMARK,:VERSION,:SHEVLS_NUM,:PRICE,:UNIT,:SUMPRICE)");
                OracleParameter[] parameter = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                  	new OracleParameter(":SHEVLS_NUM", OracleDbType.Decimal,4),                
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),                    
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),                   
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),                    
                                              };
                parameter[0].Value = model.STOREP_ID;
                parameter[1].Value = model.GOODS_ID;
                parameter[2].Value = model.GOODSOUT_COUNT;
                parameter[3].Value = model.REMARK;
                parameter[4].Value = model.VERSION;
                parameter[5].Value = model.SHEVLS_NUM;
                parameter[6].Value = model.PRICE;
                parameter[7].Value = model.UNIT;
                parameter[8].Value = model.SUMPRICE;
                sqlstrlist.Add(strSql.ToString());
                sqlpara.Add(parameter);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(sqlstrlist, sqlpara);
        }























        #region 单独更新明细数据
        /// <summary>
        /// 单独更新明细数据
        /// </summary>
        /// <param name="upFuc"></param>
        /// <param name="insertFuc"></param>
        /// <param name="delFuc"></param>
        public void NewStorageRepInfoFuc(StorageRepModel stM, List<StorageRepInfoModel> upFuc, List<StorageRepInfoModel> insertFuc, List<StorageRepInfoModel> delFuc)
        {
            List<string> sqlList = new List<string>();
            List<OracleParameter[]> paraList = new List<OracleParameter[]>();
            StringBuilder strSql = new StringBuilder();

            #region 主表
            strSql.Append("update T_STOCK_STOREP set ");
            strSql.Append("TOTALOUT_NUM=:TOTALOUT_NUM,");
            strSql.Append("CREATE_MAN=:CREATE_MAN,");
            strSql.Append("CONFIRM_MAN=:CONFIRM_MAN,");
           // strSql.Append("REVIEW_MAN=:REVIEW_MAN,");
            strSql.Append("CREATE_DATE=:CREATE_DATE,");
            strSql.Append("CONFIRM_DATE=:CONFIRM_DATE,");
            //strSql.Append("REVIEW_DATE=:REVIEW_DATE,");
            strSql.Append("EXPECT_DATE=:EXPECT_DATE,");
            strSql.Append("STOSTART_ID=:STOSTART_ID,");
            strSql.Append("STOEND_ID=:STOEND_ID,");
            strSql.Append("STOREP_STATUS=:STOREP_STATUS,");
            strSql.Append("RESION=:RESION,");
            strSql.Append("REMARK=:REMARK,");
            strSql.Append("VERSION=:VERSION,");
            strSql.Append("PRINT_COUNT=:PRINT_COUNT");
            strSql.Append(" where STOREP_ID=:STOREP_ID ");
            OracleParameter[] param = new OracleParameter[]{
					
					new OracleParameter(":TOTALOUT_NUM", OracleDbType.Decimal,4),
					new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CONFIRM_MAN",OracleDbType.Varchar2,30),
					//new OracleParameter(":REVIEW_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CREATE_DATE", OracleDbType.Date),
					new OracleParameter(":CONFIRM_DATE", OracleDbType.Date),
					//new OracleParameter(":REVIEW_DATE", OracleDbType.Date),
					new OracleParameter(":EXPECT_DATE", OracleDbType.Date),
					new OracleParameter(":STOSTART_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOEND_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOREP_STATUS", OracleDbType.Char,1),
                   new OracleParameter(":RESION",OracleDbType.Varchar2,200),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":PRINT_COUNT",OracleDbType.Decimal),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)};

            param[0].Value = stM.TOTALOUT_NUM;
            param[1].Value = stM.CREATE_MAN;
            param[2].Value = stM.CONFIRM_MAN;
            //param[3].Value = stM.REVIEW_MAN;
            param[3].Value = stM.CREATE_DATE;
            param[4].Value = stM.CONFIRM_DATE;
            //param[6].Value = stM.REVIEW_DATE;
            param[5].Value = stM.EXPECT_DATE;
            param[6].Value = stM.STOSTART_ID;
            param[7].Value = stM.STOEND_ID;
            param[8].Value = stM.STOREP_STATUS;
            param[9].Value = stM.RESION;
            param[10].Value = stM.REMARK;
            param[11].Value = stM.VERSION;
            param[12].Value = stM.PRINT_COUNT;
            param[13].Value = stM.STOREP_ID;
            sqlList.Add(strSql.ToString());
            paraList.Add(param);
            strSql.Clear();
            #endregion

            #region 明细表

            #region 删
            //明细删除
            if (delFuc.Count > 0)
            {
                foreach (StorageRepInfoModel infomodel in delFuc)
                {
                    strSql = new StringBuilder();
                    strSql.Append("delete from T_STOCK_STOREP_INFO ");
                    strSql.Append(" where STOREP_ID=:STOREP_ID and GOODS_ID=:GOODS_ID");
                    OracleParameter[] parameters = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
                   new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)
                          };
                    parameters[0].Value = infomodel.STOREP_ID;
                    parameters[1].Value = infomodel.GOODS_ID;
                    sqlList.Add(strSql.ToString());
                    paraList.Add(parameters);
                    strSql.Clear();
                }
            }
            #endregion
            #region 更
            //更新明细数据
            if (upFuc.Count > 0)
            {
                foreach (StorageRepInfoModel modelinfo in upFuc)
                {
                    strSql = new StringBuilder();
                    strSql.Append("update T_STOCK_STOREP_INFO set ");
                    strSql.Append("GOODSOUT_COUNT=:GOODSOUT_COUNT,");
                    strSql.Append("REMARK=:REMARK,");
                    strSql.Append("PRICE=:PRICE,");
                    strSql.Append("UNIT=:UNIT,");
                    strSql.Append("SUMPRICE=:SUMPRICE,");
                    strSql.Append("VERSION=:VERSION");
                    strSql.Append(" where STOREP_ID=:STOREP_ID and GOODS_ID=:GOODS_ID ");
                    OracleParameter[] parameter = {
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)};

                    parameter[0].Value = modelinfo.GOODSOUT_COUNT;
                    parameter[1].Value = modelinfo.REMARK;
                    parameter[2].Value = modelinfo.PRICE;
                    parameter[3].Value = modelinfo.UNIT;
                    parameter[4].Value = modelinfo.SUMPRICE;
                    parameter[5].Value = modelinfo.VERSION;
                    parameter[6].Value = modelinfo.STOREP_ID;
                    parameter[7].Value = modelinfo.GOODS_ID;
                    sqlList.Add(strSql.ToString());
                    paraList.Add(parameter);
                    strSql.Clear();
                }
            }
            #endregion
            #region 增
            // 新增明细数据
            if (insertFuc.Count > 0)
            {
                foreach (StorageRepInfoModel modelinfo in insertFuc)
                {
                    strSql = new StringBuilder();
                    strSql = new StringBuilder();
                    strSql.Append("insert into T_STOCK_STOREP_INFO(");
                    strSql.Append("STOREP_ID,GOODS_ID,GOODSOUT_COUNT,REMARK,VERSION,SHEVLS_NUM,PRICE,UNIT,SUMPRICE)");
                    strSql.Append(" values (");
                    strSql.Append(":STOREP_ID,:GOODS_ID,:GOODSOUT_COUNT,:REMARK,:VERSION,:SHEVLS_NUM,:PRICE,:UNIT,:SUMPRICE)");
                    OracleParameter[] parameter = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                  	new OracleParameter(":SHEVLS_NUM", OracleDbType.Decimal,4),                
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),                    
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),                   
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),                    
                                              };
                    parameter[0].Value = modelinfo.STOREP_ID;
                    parameter[1].Value = modelinfo.GOODS_ID;
                    parameter[2].Value = modelinfo.GOODSOUT_COUNT;
                    parameter[3].Value = modelinfo.REMARK;
                    parameter[4].Value = modelinfo.VERSION;
                    parameter[5].Value = modelinfo.SHEVLS_NUM;
                    parameter[6].Value = modelinfo.PRICE;
                    parameter[7].Value = modelinfo.UNIT;
                    parameter[8].Value = modelinfo.SUMPRICE;
                    sqlList.Add(strSql.ToString());
                    paraList.Add(parameter);
                    strSql.Clear();
                }
            }
            #endregion

            #endregion
            SystemDataObject.Instance.ExecuteList(sqlList, paraList);
        }
        #endregion


        /// <summary>
        /// 单独删除明细数据
        /// </summary>
        public void Delete(List<StorageRepInfoModel> list)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> sqlstrlist = new List<string>();
            List<OracleParameter[]> sqlstrpara = new List<OracleParameter[]>();
            foreach (StorageRepInfoModel model in list)
            {
                strSql = new StringBuilder();
                strSql.Append("delete from T_STOCK_STOREP_INFO ");
                strSql.Append(" where STOREP_ID=:STOREP_ID and GOODS_ID=:GOODS_ID ");
                OracleParameter[] parameters = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)			};
                parameters[0].Value = model.STOREP_ID;
                parameters[1].Value = model.GOODS_ID;
                sqlstrlist.Add(strSql.ToString());
                sqlstrpara.Add(parameters);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(sqlstrlist, sqlstrpara);
        }


























        #region 已废 查询补货操作数据信息
        //        public DataTable GetStockData()
        //        {
        //            StringBuilder strSql = new StringBuilder();
        //            strSql.Append(@"select
        //                             t.stock_id,
        //                             t.putin_id,
        //                             t.out_id,
        //                             t.storage_id,
        //                             t.area_id,
        //                             t.location_id,
        //                             t.goods_typeid,
        //                             t.goods_id,
        //                             g.goods_name,
        //                             t.goods_num,
        //                             t.operator_man,
        //                             t.operator_date,
        //                             t.operator_type,
        //                             t.remark,
        //                             t.version
        //                             from T_MI_STOCK_BACK t
        //                             left outer join T_BASE_GOODS g
        //                             on t.goods_id = g.goods_id
        //                             where 1 = 1");
        //            #region 查询条件
        //            strSql.Append("");
        //            #endregion

        //            return SystemDataObject.Instance.GetDataTable(strSql.ToString());

        //        }


        #endregion
        #region 已废 删主表
        /// <summary>
        /// 删除多条数据
        /// </summary>
        public void DeleteStorageRep(List<StorageRepModel> listmodel)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> delsqlstrlist = new List<string>();
            List<OracleParameter[]> delsqlpara = new List<OracleParameter[]>();

            foreach (StorageRepModel model in listmodel)
            {
                strSql.Append("delete from T_STOCK_STOREP ");
                strSql.Append(" where STOREP_ID=:STOREP_ID ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)			};
                parameters[0].Value = model.STOREP_ID;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(delsqlstrlist, delsqlpara);

        }
        #endregion
        #region 已废 删明细
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void DeleteStorageRepInfo(List<StorageRepInfoModel> listmodel)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> delsqlstrlist = new List<string>();
            List<OracleParameter[]> delsqlpara = new List<OracleParameter[]>();

            foreach (StorageRepInfoModel model in listmodel)
            {
                strSql.Append("delete from T_STOCK_STOREP_INFO ");
                strSql.Append(" where STOREP_ID=:STOREP_ID   ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)
                  // new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)			
                                               };
                parameters[0].Value = model.STOREP_ID;
                //parameters[1].Value = model.GOODS_ID;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
            }
            SystemDataObject.Instance.ExecuteList(delsqlstrlist, delsqlpara);

        }
        #endregion
        #region 增主表
        /// <summary>
        /// 增加仓库间调拨主表数据
        /// </summary>
        /// <param name="model">仓库间调拨Model</param>
        public void InsertStorageRep(StorageRepModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_STOCK_STOREP(");
            strSql.Append("STOREP_ID,TOTALOUT_NUM,CREATE_MAN,CONFIRM_MAN,CREATE_DATE,CONFIRM_DATE,EXPECT_DATE,STOSTART_ID,STOEND_ID,STOREP_STATUS,REMARK,VERSION,RESION,PRINT_COUNT,SHIPPERS,ORI_BILL,OPERATORID,OPERATEDATE)");
            strSql.Append(" values (");
            strSql.Append(":STOREP_ID,:TOTALOUT_NUM,:CREATE_MAN,:CONFIRM_MAN,:CREATE_DATE,:CONFIRM_DATE,:EXPECT_DATE,:STOSTART_ID,:STOEND_ID,:STOREP_STATUS,:REMARK,:VERSION,:RESION,:PRINT_COUNT,:SHIPPERS,:ORI_BILL,:OPERATORID,:OPERATEDATE)");
            OracleParameter[] parameters = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":TOTALOUT_NUM", OracleDbType.Decimal,4),
					new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CONFIRM_MAN",OracleDbType.Varchar2,30),
					//new OracleParameter(":REVIEW_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CREATE_DATE", OracleDbType.Date),
					new OracleParameter(":CONFIRM_DATE", OracleDbType.Date),
					//new OracleParameter(":REVIEW_DATE", OracleDbType.Date),
					new OracleParameter(":EXPECT_DATE", OracleDbType.Date),
					new OracleParameter(":STOSTART_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOEND_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOREP_STATUS", OracleDbType.Char,1),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
					new OracleParameter(":RESION",OracleDbType.Varchar2,200),
                   new OracleParameter(":PRINT_COUNT",OracleDbType.Decimal),
                   new OracleParameter(":SHIPPERS",OracleDbType.Varchar2,50),
                   new OracleParameter(":ORI_BILL",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATORID",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATEDATE",OracleDbType.Date)   
                                           };
            parameters[0].Value = model.STOREP_ID;
            parameters[1].Value = model.TOTALOUT_NUM;
            parameters[2].Value = model.CREATE_MAN;
            parameters[3].Value = model.CONFIRM_MAN;
           // parameters[4].Value = model.CONFIRM_MAN;
            parameters[4].Value = model.CREATE_DATE;
            parameters[5].Value = model.CONFIRM_DATE;
           // parameters[7].Value = model.REVIEW_DATE;
            parameters[6].Value = model.EXPECT_DATE;
            parameters[7].Value = model.STOSTART_ID;
            parameters[8].Value = model.STOEND_ID;
            parameters[9].Value = model.STOREP_STATUS;
            parameters[10].Value = model.REMARK;
            parameters[11].Value = model.VERSION;
            parameters[12].Value = model.RESION;
            parameters[13].Value = model.PRINT_COUNT;
            parameters[14].Value = model.SHIPPERS;
            parameters[15].Value = model.ORI_BILL;
            parameters[16].Value = model.OPERATORID;
            parameters[17].Value = model.OPERATEDATE;

            SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
        }
        #endregion
        #region 增明细
        /// <summary>
        /// 增仓库间调拨明细数据
        /// </summary>
        /// <param name="listmodel">仓库间调拨明细Model集合</param>
        public void InsertStorageRepInfo(List<StorageRepInfoModel> listmodel)
        {
            StringBuilder strSql = new StringBuilder();
            List<string> addsqlstrlist = new List<string>();
            List<OracleParameter[]> addsqlpara = new List<OracleParameter[]>();

            foreach (StorageRepInfoModel model in listmodel)
            {
                strSql = new StringBuilder();
                strSql.Append("insert into T_STOCK_STOREP_INFO(");
                strSql.Append("STOREP_ID,GOODS_ID,GOODSOUT_COUNT,REMARK,VERSION,SHEVLS_NUM,PRICE,UNIT,SUMPRICE)");
                strSql.Append(" values (");
                strSql.Append(":STOREP_ID,:GOODS_ID,:GOODSOUT_COUNT,:REMARK,:VERSION,:SHEVLS_NUM,:PRICE,:UNIT,:SUMPRICE)");
                OracleParameter[] parameter = {
					new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                  	new OracleParameter(":SHEVLS_NUM", OracleDbType.Decimal,4),                
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),                    
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),                   
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),                    
                                              };
                parameter[0].Value = model.STOREP_ID;
                parameter[1].Value = model.GOODS_ID;
                parameter[2].Value = model.GOODSOUT_COUNT;
                parameter[3].Value = model.REMARK;
                parameter[4].Value = model.VERSION;
                parameter[5].Value = model.SHEVLS_NUM;
                parameter[6].Value = model.PRICE;
                parameter[7].Value = model.UNIT;
                parameter[8].Value = model.SUMPRICE;
                addsqlstrlist.Add(strSql.ToString());
                addsqlpara.Add(parameter);
                strSql.Clear();

            }
            SystemDataObject.Instance.ExecuteList(addsqlstrlist, addsqlpara);
        }
        #endregion


        #region 更主表
        /// <summary>
        /// 更新仓库间调拨主表数据
        /// </summary>
        /// <param name="model">仓库间调拨Model</param>
        public void UpdateStorageRep(StorageRepModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_STOCK_STOREP set ");
            strSql.Append("TOTALOUT_NUM=:TOTALOUT_NUM,");
            strSql.Append("CREATE_MAN=:CREATE_MAN,");
            strSql.Append("CONFIRM_MAN=:CONFIRM_MAN,");
            //strSql.Append("REVIEW_MAN=:REVIEW_MAN,");
            strSql.Append("CREATE_DATE=:CREATE_DATE,");
            strSql.Append("CONFIRM_DATE=:CONFIRM_DATE,");
            //strSql.Append("REVIEW_DATE=:REVIEW_DATE,");
            strSql.Append("EXPECT_DATE=:EXPECT_DATE,");
            strSql.Append("STOSTART_ID=:STOSTART_ID,");
            strSql.Append("STOEND_ID=:STOEND_ID,");
            strSql.Append("STOREP_STATUS=:STOREP_STATUS,");
            strSql.Append("RESION=:RESION,");
            strSql.Append("REMARK=:REMARK,");
            strSql.Append("VERSION=:VERSION,");
            strSql.Append("PRINT_COUNT=:PRINT_COUNT,");
            strSql.Append("SHIPPERS=:SHIPPERS,");
            strSql.Append("OPERATORID=:OPERATORID,");
            strSql.Append("OPERATEDATE=:OPERATEDATE,");
            strSql.Append("ORI_BILL=:ORI_BILL");
            strSql.Append(" where STOREP_ID=:STOREP_ID ");
            OracleParameter[] parameters = {
					
					new OracleParameter(":TOTALOUT_NUM", OracleDbType.Decimal,4),
					new OracleParameter(":CREATE_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CONFIRM_MAN",OracleDbType.Varchar2,30),
					//new OracleParameter(":REVIEW_MAN",OracleDbType.Varchar2,30),
					new OracleParameter(":CREATE_DATE", OracleDbType.Date),
					new OracleParameter(":CONFIRM_DATE", OracleDbType.Date),
					//new OracleParameter(":REVIEW_DATE", OracleDbType.Date),
					new OracleParameter(":EXPECT_DATE", OracleDbType.Date),
					new OracleParameter(":STOSTART_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOEND_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":STOREP_STATUS", OracleDbType.Char,1),
                   new OracleParameter(":RESION",OracleDbType.Varchar2,200),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":PRINT_COUNT",OracleDbType.Decimal),
                   new OracleParameter(":SHIPPERS",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATORID",OracleDbType.Varchar2,50),
                   new OracleParameter(":OPERATEDATE",OracleDbType.Date),
                   new OracleParameter(":ORI_BILL",OracleDbType.Varchar2,50),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)};

            parameters[0].Value = model.TOTALOUT_NUM;
            parameters[1].Value = model.CREATE_MAN;
            parameters[2].Value = model.CONFIRM_MAN;
            //parameters[3].Value = model.REVIEW_MAN;
            parameters[3].Value = model.CREATE_DATE;
            parameters[4].Value = model.CONFIRM_DATE;
            //parameters[6].Value = model.REVIEW_DATE;
            parameters[5].Value = model.EXPECT_DATE;
            parameters[6].Value = model.STOSTART_ID;
            parameters[7].Value = model.STOEND_ID;
            parameters[8].Value = model.STOREP_STATUS;
            parameters[9].Value = model.RESION;
            parameters[10].Value = model.REMARK;
            parameters[11].Value = model.VERSION;
            parameters[12].Value = model.PRINT_COUNT;
            parameters[13].Value = model.SHIPPERS;
            parameters[14].Value = model.OPERATORID;
            parameters[15].Value = model.OPERATEDATE;
            parameters[16].Value = model.ORI_BILL;
            parameters[17].Value = model.STOREP_ID;

            SystemDataObject.Instance.ExecuteSqlCommit(strSql.ToString(), parameters);
        }


        #endregion
        #region 更明细
        /// <summary>
        /// 更新仓库间调拨明细数据
        /// </summary>
        /// <param name="listmodel">仓库间调拨明细Model集合</param>
        public void UpdateStorageRepInfo(List<StorageRepInfoModel> listmodel)
        {
            StringBuilder strSql = new StringBuilder();
            List<string> updatesqlstrlist = new List<string>();
            List<OracleParameter[]> updatesqlpara = new List<OracleParameter[]>();

            foreach (StorageRepInfoModel model in listmodel)
            {
                strSql.Append("update T_STOCK_STOREP_INFO set ");
                strSql.Append("GOODSOUT_COUNT=:GOODSOUT_COUNT,");
                strSql.Append("REMARK=:REMARK,");
                strSql.Append("PRICE=:PRICE,");
                strSql.Append("UNIT=:UNIT,");
                strSql.Append("SUMPRICE=:SUMPRICE,");
                strSql.Append("VERSION=:VERSION");
                strSql.Append(" where STOREP_ID=:STOREP_ID and GOODS_ID=:GOODS_ID ");
                OracleParameter[] parameter = {
					new OracleParameter(":GOODSOUT_COUNT", OracleDbType.Decimal,4),
					new OracleParameter(":REMARK",OracleDbType.Varchar2,200),
                   new OracleParameter(":PRICE", OracleDbType.Decimal,4),
                   new OracleParameter(":UNIT",OracleDbType.Varchar2,10),
                   new OracleParameter(":SUMPRICE", OracleDbType.Decimal,4),
					new OracleParameter(":VERSION",OracleDbType.Varchar2,10),
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30),
					new OracleParameter(":GOODS_ID",OracleDbType.Varchar2,30)};

                parameter[0].Value = model.GOODSOUT_COUNT;
                parameter[1].Value = model.REMARK;
                parameter[2].Value = model.PRICE;
                parameter[3].Value = model.UNIT;
                parameter[4].Value = model.SUMPRICE;
                parameter[5].Value = model.VERSION;
                parameter[6].Value = model.STOREP_ID;
                parameter[7].Value = model.GOODS_ID;
                updatesqlstrlist.Add(strSql.ToString());
                updatesqlpara.Add(parameter);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(updatesqlstrlist, updatesqlpara);
        }
        #endregion
        #region 删主表
        /// <summary>
        /// 删除仓库间调拨主表数据
        /// </summary>
        /// <param name="listmodel">仓库间调拨ID集合</param>
        public void DeleteStorageRep(List<string> listmodel)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> delsqlstrlist = new List<string>();
            List<OracleParameter[]> delsqlpara = new List<OracleParameter[]>();

            foreach (string stDel in listmodel)
            {
                strSql.Append("delete from T_STOCK_STOREP ");
                strSql.Append(" where STOREP_ID=:STOREP_ID ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)			};
                parameters[0].Value = stDel;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
                strSql.Clear();
            }
            SystemDataObject.Instance.ExecuteList(delsqlstrlist, delsqlpara);
        }
        #endregion
        #region 删明细
        /// <summary>
        /// 删除仓库间调拨明细表数据
        /// </summary>
        /// <param name="listmodel">仓库间调拨ID集合</param>
        public void DeleteStorageRepInfo(List<string> listmodel)
        {

            StringBuilder strSql = new StringBuilder();
            List<string> delsqlstrlist = new List<string>();
            List<OracleParameter[]> delsqlpara = new List<OracleParameter[]>();

            foreach (string str in listmodel)
            {
                strSql.Append("delete from T_STOCK_STOREP_INFO ");
                strSql.Append(" where STOREP_ID=:STOREP_ID   ");
                OracleParameter[] parameters = {
                   new OracleParameter(":STOREP_ID",OracleDbType.Varchar2,30)		
                                               };
                parameters[0].Value = str;
                delsqlstrlist.Add(strSql.ToString());
                delsqlpara.Add(parameters);
            }
            SystemDataObject.Instance.ExecuteList(delsqlstrlist, delsqlpara);
        }
        #endregion

    }
}