1using System;
  2using System.Collections.Generic;
  3using System.Data;
  4using System.Data.OleDb;
  5using MyShop.IDAL;
  6using MyShop.Model;
  7
  8namespace MyShop.AccessDAL
  9...{
 10    public class Config :IConfig
 11    ...{
 12        private ConfigInfo configInfo = new ConfigInfo();
 13        private string tableName = "Ljh_Config";
 14        public Config()
 15        ...{
 16            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
 17                tableName = configInfo.TablePrefix + "Config";
 18        }
 19        IConfig 成员#region IConfig 成员
 20
 21        public int Add(ConfigInfo model)
 22        ...{
 23            throw new Exception("The method or operation is not implemented.");
 24        }
 25
 26        public int Delete(string filter)
 27        ...{
 28            throw new Exception("The method or operation is not implemented.");
 29        }
 30
 31        public bool Exist(string filter)
 32        ...{
 33            throw new Exception("The method or operation is not implemented.");
 34        }
 35
 36        public DataSet GetDataSet()
 37        ...{
 38            string sql = "select * from " + tableName;
 39            DataSet dataset = new DataSet();
 40            try
 41            ...{
 42                
 43                dataset = Database.ExecuteDataSet(sql);
 44
 45            }
 46            catch (Exception ex)
 47            ...{
 48                throw ex;
 49            }
 50            return dataset;
 51        }
 52
 53        public DataSet GetDataSet(string filter)
 54        ...{
 55             throw new Exception("The method or operation is not implemented.");
 56        }
 57
 58        public ConfigInfo GetModel(DataRow dr)
 59        ...{
 60            if (dr == null)
 61                return null;
 62            ConfigInfo model = new ConfigInfo();
 63            if (dr["SiteName"].ToString() != "") model.SiteName = dr["SiteName"].ToString();
 64            if (dr["SiteTitle"].ToString() != "") model.SiteTitle = dr["SiteTitle"].ToString();
 65            if (dr["SiteUrl"].ToString() != "") model.SiteUrl = dr["SiteUrl"].ToString();
 66            if (dr["InstallDir"].ToString() != "") model.InstallDir = dr["InstallDir"].ToString();
 67            if (dr["LogoUrl"].ToString() != "") model.LogoUrl = dr["LogoUrl"].ToString();
 68            if (dr["BannerUrl"].ToString() != "") model.BannerUrl = dr["BannerUrl"].ToString();
 69            if (dr["WebmasterName"].ToString() != "") model.WebmasterName = dr["WebmasterName"].ToString();
 70            if (dr["WebmasterEmail"].ToString() != "") model.WebmasterEmail = dr["WebmasterEmail"].ToString();
 71            if (dr["Copyright"].ToString() != "") model.Copyright = dr["Copyright"].ToString();
 72            if (dr["Meta_Keywords"].ToString() != "") model.Meta_Keywords = dr["Meta_Keywords"].ToString();
 73            if (dr["Meta_Description"].ToString() != "") model.Meta_Description = dr["Meta_Description"].ToString();
 74            if (dr["EnableCountFriendSiteHits"].ToString() != "") model.EnableCountFriendSiteHits = Convert.ToInt16( dr["EnableCountFriendSiteHits"]);
 75            if (dr["ObjName_FSO"].ToString() != "") model.ObjName_FSO = dr["ObjName_FSO"].ToString();
 76            if (dr["AdminDir"].ToString() != "") model.AdminDir = dr["AdminDir"].ToString();
 77            if (dr["ADDir"].ToString() != "") model.ADDir = dr["ADDir"].ToString();
 78            if (dr["HitsOfHot"].ToString() != "") model.HitsOfHot =  Convert.ToInt32(  dr["HitsOfHot"].ToString());
 79            if (dr["LockIPType"].ToString() != "") model.LockIPType = Convert.ToInt16(dr["LockIPType"].ToString());
 80            if (dr["LockIP"].ToString() != "") model.LockIP = dr["LockIP"].ToString();
 81            if (dr["EnableUserReg"].ToString() != "") model.EnableUserReg =  Convert.ToInt16(  dr["EnableUserReg"]);
 82            if (dr["EmailCheckReg"].ToString() != "") model.EmailCheckReg =  Convert.ToInt16( dr["EmailCheckReg"]);
 83            if (dr["EnableMultiRegPerEmail"].ToString() != "") model.EnableMultiRegPerEmail =  Convert.ToInt16( dr["EnableMultiRegPerEmail"]);
 84            if (dr["UserName_RegDisabled"].ToString() != "") model.UserName_RegDisabled = dr["UserName_RegDisabled"].ToString();
 85            if (dr["RegFields_MustFill"].ToString() != "") model.RegFields_MustFill = dr["RegFields_MustFill"].ToString();
 86            if (dr["EnableCheckCodeOfLogIn"].ToString() != "") model.EnableCheckCodeOfLogIn =  Convert.ToInt16( dr["EnableCheckCodeOfLogIn"]);
 87            if (dr["PresentExpPerLogIn"].ToString() != "") model.PresentExpPerLogIn = Convert.ToInt32(dr["PresentExpPerLogIn"]);
 88            if (dr["EmailOfRegCheck"].ToString() != "") model.EmailOfRegCheck = dr["EmailOfRegCheck"].ToString();
 89            if (dr["MailServer"].ToString() != "") model.MailServer = dr["MailServer"].ToString();
 90            if (dr["MailServerUserName"].ToString() != "") model.MailServerUserName = dr["MailServerUserName"].ToString();
 91            if (dr["MailServerPassWord"].ToString() != "") model.MailServerPassWord = dr["MailServerPassWord"].ToString();
 92            if (dr["MailDomain"].ToString() != "") model.MailDomain = dr["MailDomain"].ToString();
 93            if (dr["Thumb_DefaultWidth"].ToString() != "") model.Thumb_DefaultWidth =  Convert.ToInt32( dr["Thumb_DefaultWidth"].ToString());
 94            if (dr["Thumb_DefaultHeight"].ToString() != "") model.Thumb_DefaultHeight =  Convert.ToInt32( dr["Thumb_DefaultHeight"].ToString());
 95            if (dr["SearchContent"].ToString() != "") model.SearchContent = Convert.ToInt16(  dr["SearchContent"]);
 96            if (dr["EnableGuestBuy"].ToString() != "") model.EnableGuestBuy =  Convert.ToInt16(  dr["EnableGuestBuy"]);
 97            if (dr["PayOnlineProvider"].ToString() != "") model.PayOnlineProvider = Convert.ToInt32(  dr["PayOnlineProvider"].ToString());
 98            if (dr["PayOnlineShopID"].ToString() != "") model.PayOnlineShopID = dr["PayOnlineShopID"].ToString();
 99            if (dr["PayOnlineKey"].ToString() != "") model.PayOnlineKey = dr["PayOnlineKey"].ToString();
100            if (dr["PayOnlineRate"].ToString() != "") model.PayOnlineRate =  Convert.ToSingle( dr["PayOnlineRate"].ToString());
101            if (dr["Prefix_PaymentNum"].ToString() != "") model.Prefix_PaymentNum = dr["Prefix_PaymentNum"].ToString();
102            if (dr["Country"].ToString() != "") model.Country = dr["Country"].ToString();
103            if (dr["Province"].ToString() != "") model.Province = dr["Province"].ToString();
104            if (dr["City"].ToString() != "") model.City = dr["City"].ToString();
105            if (dr["PostCode"].ToString() != "") model.PostCode = dr["PostCode"].ToString();
106            if (dr["MessageOfOrderConfirm"].ToString() != "") model.MessageOfOrderConfirm = dr["MessageOfOrderConfirm"].ToString();
107            if (dr["EmailOfOrderConfirm"].ToString() != "") model.EmailOfOrderConfirm = dr["EmailOfOrderConfirm"].ToString();
108            if (dr["MessageOfReceiptMoney"].ToString() != "") model.MessageOfReceiptMoney = dr["MessageOfReceiptMoney"].ToString();
109            if (dr["EmailOfReceiptMoney"].ToString() != "") model.EmailOfReceiptMoney = dr["EmailOfReceiptMoney"].ToString();
110            if (dr["MessageOfRefund"].ToString() != "") model.MessageOfRefund = dr["MessageOfRefund"].ToString();
111            if (dr["EmailOfRefund"].ToString() != "") model.EmailOfRefund = dr["EmailOfRefund"].ToString();
112            if (dr["MessageOfDeliver"].ToString() != "") model.MessageOfDeliver = dr["MessageOfDeliver"].ToString();
113            if (dr["EmailOfDeliver"].ToString() != "") model.EmailOfDeliver = dr["EmailOfDeliver"].ToString();
114            if (dr["DatabaseVersion"].ToString() != "") model.DatabaseVersion =  Convert.ToSingle( dr["DatabaseVersion"].ToString());
115            if (dr["MessageOfOrder"].ToString() != "") model.MessageOfOrder = dr["MessageOfOrder"].ToString();
116            if (dr["MessageOfAddRemit"].ToString() != "") model.MessageOfAddRemit = dr["MessageOfAddRemit"].ToString();
117            if (dr["MessageOfAddIncome"].ToString() != "") model.MessageOfAddIncome = dr["MessageOfAddIncome"].ToString();
118            if (dr["MessageOfAddPayment"].ToString() != "") model.MessageOfAddPayment = dr["MessageOfAddPayment"].ToString();
119            if (dr["Thumb_BackgroundColor"].ToString() != "") model.Thumb_BackgroundColor = dr["Thumb_BackgroundColor"].ToString();
120
121            if (dr["EnableCheckCodeOfReg"].ToString() != "") model.EnableCheckCodeOfReg = Convert.ToInt32(dr["EnableCheckCodeOfReg"]);
122            if (dr["PayOnlinePlusPoundage"].ToString() != "") model.PayOnlinePlusPoundage = Convert.ToInt32(dr["PayOnlinePlusPoundage"]);
123            if (dr["MessageOfInvoice"].ToString() != "") model.MessageOfInvoice = dr["MessageOfInvoice"].ToString();
124            if (dr["EmailOfInvoice"].ToString() != "") model.EmailOfInvoice = dr["EmailOfInvoice"].ToString();
125
126
127            if (dr["ThumbArithmetic"].ToString() != "") model.ThumbArithmetic = Convert.ToInt32(dr["ThumbArithmetic"]);
128            if (dr["WatermarkType"].ToString() != "") model.WatermarkType = Convert.ToInt32(dr["WatermarkType"]);
129            if (dr["WatermarkText"].ToString() != "") model.WatermarkText = dr["WatermarkText"].ToString();
130            if (dr["WatermarkTextFontName"].ToString() != "") model.WatermarkTextFontName = dr["WatermarkTextFontName"].ToString();
131            if (dr["WatermarkTextFontSize"].ToString() != "") model.WatermarkTextFontSize = Convert.ToInt32(dr["WatermarkTextFontSize"]);
132            if (dr["WatermarkTextFontColor"].ToString() != "") model.WatermarkTextFontColor = dr["WatermarkTextFontColor"].ToString();
133            if (dr["WatermarkTextFontStyle"].ToString() != "") model.WatermarkTextFontStyle = Convert.ToInt32(dr["WatermarkTextFontStyle"]);
134            if (dr["WatermarkImagesFileName"].ToString() != "") model.WatermarkImagesFileName = dr["WatermarkImagesFileName"].ToString();
135            if (dr["WatermarkTransparence"].ToString() != "") model.WatermarkTransparence = Convert.ToInt32(dr["WatermarkTransparence"]);
136            if (dr["WatermarkPosition"].ToString() != "") model.WatermarkPosition = Convert.ToInt32(dr["WatermarkPosition"]);
137            if (dr["WatermarkPositionX"].ToString() != "") model.WatermarkPositionX = Convert.ToInt32(dr["WatermarkPositionX"]);
138            if (dr["WatermarkPositionY"].ToString() != "") model.WatermarkPositionY = Convert.ToInt32(dr["WatermarkPositionY"]);
139            if (dr["PhotoQuality"].ToString() != "") model.PhotoQuality = Convert.ToInt32(dr["PhotoQuality"]);
140
141            return model;
142        }
143
144        public DataSet Query(string sql)
145        ...{
146            throw new Exception("The method or operation is not implemented.");
147        }
148
149        public int Update(ConfigInfo model, string filter)
150        ...{
151            int result;
152            string sql = @"update " + tableName + " set  siteName =@siteName,siteTitle =@siteTitle,siteUrl =@siteUrl,installDir =@installDir,logoUrl =@logoUrl,bannerUrl =@bannerUrl,webmasterName =@webmasterName,webmasterEmail =@webmasterEmail,copyright =@copyright,meta_Keywords =@meta_Keywords,meta_Description =@meta_Description,enableCountFriendSiteHits =@enableCountFriendSiteHits,objName_FSO =@objName_FSO,adminDir =@adminDir,adDir =@adDir,hitsOfHot =@hitsOfHot,lockIPType =@lockIPType,lockIP =@lockIP,enableUserReg =@enableUserReg,EmailCheckReg =@EmailCheckReg,enableMultiRegPerEmail =@enableMultiRegPerEmail,UserName_RegDisabled =@UserName_RegDisabled,regFields_mustFill =@regFields_mustFill,enableCheckCodeOfLogIn =@enableCheckCodeOfLogIn,PresentExpPerLogIn =@PresentExpPerLogIn,EmailOfRegCheck =@EmailOfRegCheck,mailServer =@mailServer,mailServerUserName =@mailServerUserName,mailServerPassword =@mailServerPassword,mailDomain =@mailDomain,thumb_defaultWidth =@thumb_defaultWidth,thumb_defaultHeight =@thumb_defaultHeight,searchContent =@searchContent,enableGuestBuy =@enableGuestBuy,payOnlineProvider =@payOnlineProvider,payOnlineShopID =@payOnlineShopID,payOnlineKey =@payOnlineKey,payOnlineRate =@payOnlineRate,prefix_PaymentNum =@prefix_PaymentNum,country =@country,province =@province,city =@city,postCode =@postCode,messageOfOrderConfirm =@messageOfOrderConfirm,EmailOfOrderConfirm =@EmailOfOrderConfirm,messageOfReceiptMoney =@messageOfReceiptMoney,EmailOfReceiptMoney =@EmailOfReceiptMoney,messageOfRefund =@messageOfRefund,EmailOfRefund =@EmailOfRefund,messageOfDeliver =@messageOfDeliver,EmailOfDeliver =@EmailOfDeliver,DatabaseVersion =@DatabaseVersion,messageOfOrder =@messageOfOrder,messageOfAddRemit =@messageOfAddRemit,messageOfAddIncome =@messageOfAddIncome,messageOfAddPayment =@messageOfAddPayment,thumb_BackgroundColor =@thumb_BackgroundColor,EnableCheckCodeOfReg=@EnableCheckCodeOfReg,PayOnlinePlusPoundage=@PayOnlinePlusPoundage,MessageOfInvoice=@MessageOfInvoice,EmailOfInvoice=@EmailOfInvoice " +
153                ",ThumbArithmetic    =@ThumbArithmetic,WatermarkType    =@WatermarkType,WatermarkText    =@WatermarkText,WatermarkTextFontName    =@WatermarkTextFontName,WatermarkTextFontSize    =@WatermarkTextFontSize,WatermarkTextFontColor    =@WatermarkTextFontColor,WatermarkTextFontStyle    =@WatermarkTextFontStyle,WatermarkImagesFileName    =@WatermarkImagesFileName,WatermarkTransparence    =@WatermarkTransparence,WatermarkPosition    =@WatermarkPosition,WatermarkPositionX    =@WatermarkPositionX,WatermarkPositionY    =@WatermarkPositionY ,PhotoQuality=@PhotoQuality";
154            OleDbParameter[] prams = ...{
155                Database.MakeInParam("@SiteName", OleDbType.VarWChar,50,model.SiteName),
156                Database.MakeInParam("@SiteTitle", OleDbType.VarWChar,50,model.SiteTitle),
157                Database.MakeInParam("@SiteUrl", OleDbType.VarWChar,255,model.SiteUrl),
158                Database.MakeInParam("@InstallDir", OleDbType.VarWChar,30,model.InstallDir),
159                Database.MakeInParam("@LogoUrl", OleDbType.VarWChar,255,model.LogoUrl),
160                Database.MakeInParam("@BannerUrl", OleDbType.VarWChar,255,model.BannerUrl),
161                Database.MakeInParam("@WebmasterName", OleDbType.VarWChar,20,model.WebmasterName),
162                Database.MakeInParam("@WebmasterEmail", OleDbType.VarWChar,100,model.WebmasterEmail),
163                Database.MakeInParam("@Copyright", OleDbType.VarWChar,0,model.Copyright),
164                Database.MakeInParam("@Meta_Keywords", OleDbType.VarWChar,0,model.Meta_Keywords),
165                Database.MakeInParam("@Meta_Description", OleDbType.VarWChar,0,model.Meta_Description),
166                Database.MakeInParam("@EnableCountFriendSiteHits", OleDbType.UnsignedTinyInt,1,model.EnableCountFriendSiteHits),
167                Database.MakeInParam("@ObjName_FSO", OleDbType.VarWChar,50,model.ObjName_FSO),
168                Database.MakeInParam("@AdminDir", OleDbType.VarWChar,50,model.AdminDir),
169                Database.MakeInParam("@ADDir", OleDbType.VarWChar,50,model.ADDir),
170                Database.MakeInParam("@HitsOfHot", OleDbType.Integer,4,model.HitsOfHot),
171                Database.MakeInParam("@LockIPType", OleDbType.Integer,4,model.LockIPType),
172                Database.MakeInParam("@LockIP", OleDbType.VarWChar,0,model.LockIP),
173                Database.MakeInParam("@EnableUserReg", OleDbType.UnsignedTinyInt,1,model.EnableUserReg),
174                Database.MakeInParam("@EmailCheckReg", OleDbType.UnsignedTinyInt,1,model.EmailCheckReg),
175                
176                Database.MakeInParam("@EnableMultiRegPerEmail", OleDbType.UnsignedTinyInt,1,model.EnableMultiRegPerEmail),
177                Database.MakeInParam("@UserName_RegDisabled", OleDbType.VarWChar,0,model.UserName_RegDisabled),
178                Database.MakeInParam("@RegFields_MustFill", OleDbType.VarWChar,255,model.RegFields_MustFill),
179                Database.MakeInParam("@EnableCheckCodeOfLogIn", OleDbType.UnsignedTinyInt,1,model.EnableCheckCodeOfLogIn),
180                Database.MakeInParam("@PresentExpPerLogIn", OleDbType.Integer,4,model.PresentExpPerLogIn),
181                Database.MakeInParam("@EmailOfRegCheck", OleDbType.VarWChar,0,model.EmailOfRegCheck),
182                Database.MakeInParam("@MailServer", OleDbType.VarWChar,50,model.MailServer),
183                Database.MakeInParam("@MailServerUserName", OleDbType.VarWChar,50,model.MailServerUserName),
184                Database.MakeInParam("@MailServerPassWord", OleDbType.VarWChar,50,model.MailServerPassWord),
185                Database.MakeInParam("@MailDomain", OleDbType.VarWChar,50,model.MailDomain),
186                Database.MakeInParam("@Thumb_DefaultWidth", OleDbType.Integer,4,model.Thumb_DefaultWidth),
187                Database.MakeInParam("@Thumb_DefaultHeight", OleDbType.Integer,4,model.Thumb_DefaultHeight),
188                Database.MakeInParam("@SearchContent", OleDbType.UnsignedTinyInt,1,model.SearchContent),
189                Database.MakeInParam("@EnableGuestBuy", OleDbType.UnsignedTinyInt,1,model.EnableGuestBuy),
190                Database.MakeInParam("@PayOnlineProvider", OleDbType.Integer,4,model.PayOnlineProvider),
191                Database.MakeInParam("@PayOnlineShopID", OleDbType.VarWChar,50,model.PayOnlineShopID),
192                Database.MakeInParam("@PayOnlineKey", OleDbType.VarWChar,50,model.PayOnlineKey),
193                Database.MakeInParam("@PayOnlineRate", OleDbType.Single,4,model.PayOnlineRate),
194                Database.MakeInParam("@Prefix_PaymentNum", OleDbType.VarWChar,4,model.Prefix_PaymentNum),
195                Database.MakeInParam("@Country", OleDbType.VarWChar,50,model.Country),
196                
197                Database.MakeInParam("@Province", OleDbType.VarWChar,50,model.Province),
198                Database.MakeInParam("@City", OleDbType.VarWChar,50,model.City),
199                Database.MakeInParam(