コード例 #1
0
ファイル: SqlHelper.cs プロジェクト: FinkleZhang/IMonitor
 public static DataSet GetStoreBaseInformation(StoreBaseInformation storeBase)
 {
     SqlParameter[] paras =
     {
         new SqlParameter("@storeNo",     storeBase.StoreNo),
         new SqlParameter("@storeRegion", storeBase.StoreRegion),
         new SqlParameter("@storeType",   storeBase.StoreType),
         new SqlParameter("@printerType", storeBase.PrinterType),
         new SqlParameter("@tonerType",   storeBase.TonerType),
         new SqlParameter("@laptopCount", storeBase.LaptopCount)
     };
     return(SqlHelper.ExecuteDataSet("GetStoreBaseInformation", paras));
 }
コード例 #2
0
ファイル: SqlHelper.cs プロジェクト: FinkleZhang/IMonitor
 // 同时会增加门店详细信息表的相关信息
 public static void InsertStoreBaseInformation(StoreBaseInformation storeBase)
 {
     SqlParameter[] paras =
     {
         new SqlParameter("@storeNo",      storeBase.StoreNo),
         new SqlParameter("@storeRegion",  storeBase.StoreRegion),
         new SqlParameter("@storeType",    storeBase.StoreType),
         new SqlParameter("@emailAddress", storeBase.EmailAddress),
         new SqlParameter("@printerType",  storeBase.PrinterType),
         new SqlParameter("@tonerType",    storeBase.TonerType),
         new SqlParameter("@laptopCount",  storeBase.LaptopCount)
     };
     SqlHelper.ExecuteNonQuery("InsertStoreBaseInformation", paras);
 }
コード例 #3
0
ファイル: SqlHelper.cs プロジェクト: FinkleZhang/IMonitor
        // 需要VPN或者ERP数据库连接
        private static void InsertStoreBaseInformationTemp()
        {
            DataSet ds = SqlHelper.GetOpeningStores();
            List <StoreBaseInformation> list = new List <StoreBaseInformation>();
            int count = ds.Tables[0].Rows.Count;

            for (int i = 0; i < count; i++)
            {
                StoreBaseInformation storeBase = new StoreBaseInformation();
                storeBase.StoreNo      = ds.Tables[0].Rows[i]["StoreNo"].ToString();
                storeBase.StoreRegion  = ds.Tables[0].Rows[i]["Region"].ToString();
                storeBase.StoreType    = ds.Tables[0].Rows[i]["StoreType"].ToString();
                storeBase.EmailAddress = storeBase.StoreRegion == "HK" ?
                                         storeBase.StoreNo + "*****@*****.**" : storeBase.StoreNo + "*****@*****.**";
                storeBase.PrinterType = "";
                storeBase.TonerType   = "";
                storeBase.LaptopCount = "2";

                list.Add(storeBase);
            }

            string[]  clist = { "storeNo", "storeRegion", "storeType", "emailAddress", "printerType", "tonerType", "laptopCount" };
            DataTable dt    = new DataTable();

            foreach (string colname in clist)
            {
                dt.Columns.Add(colname);
            }
            int rowcount = list.Count;

            for (int i = 0; i < rowcount; i++)
            {
                DataRow row = dt.NewRow();
                row["storeNo"]      = list[i].StoreNo;
                row["storeRegion"]  = list[i].StoreRegion;
                row["storeType"]    = list[i].StoreType;
                row["emailAddress"] = list[i].EmailAddress;
                row["printerType"]  = list[i].PrinterType;
                row["tonerType"]    = list[i].TonerType;
                row["laptopCount"]  = list[i].LaptopCount;
                dt.Rows.Add(row);
            }
            TruncateStoreBaseInformationTemp();
            SqlHelper.CommonBulkInsert(dt, "StoreBaseInformationTemp");
        }