/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.SystemInfo.CustomerSetting GetModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SID,AllowRegister,SameEmailRegister,AdminValidate,EmailValidate,EmailValidateContent,HandselCoupons,HandselCouponsNumber,HandselCouponsBeginTime,HandselCouponsEndTime,HandselPoint,ForbidUserId,AnswerValidate,QuestionFirst,AnswerFirst,QuestionSecond,AnswerSecond,UserDefaultGroup,GetPasswordMethod,LoginPoint,LoginIsNeedCheckCode,AllowOtherLogin,MoneyToCoupons,MoneyToDate,PointToCoupons,PointToDate,CouponsName,CouponsUnits,RegisterRequired,RegisterRequiredOptional from yxs_CustomerSetting ");
ShowShop.Model.SystemInfo.CustomerSetting model = new ShowShop.Model.SystemInfo.CustomerSetting();
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["SID"].ToString() != "")
{
model.SID = int.Parse(ds.Tables[0].Rows[0]["SID"].ToString());
}
model.AllowRegister = ds.Tables[0].Rows[0]["AllowRegister"].ToString();
if (ds.Tables[0].Rows[0]["SameEmailRegister"].ToString() != "")
{
model.SameEmailRegister = int.Parse(ds.Tables[0].Rows[0]["SameEmailRegister"].ToString());
}
if (ds.Tables[0].Rows[0]["AdminValidate"].ToString() != "")
{
model.AdminValidate = int.Parse(ds.Tables[0].Rows[0]["AdminValidate"].ToString());
}
if (ds.Tables[0].Rows[0]["EmailValidate"].ToString() != "")
{
model.EmailValidate = int.Parse(ds.Tables[0].Rows[0]["EmailValidate"].ToString());
}
model.EmailValidateContent = ds.Tables[0].Rows[0]["EmailValidateContent"].ToString();
if (ds.Tables[0].Rows[0]["HandselCoupons"].ToString() != "")
{
model.HandselCoupons = int.Parse(ds.Tables[0].Rows[0]["HandselCoupons"].ToString());
}
if (ds.Tables[0].Rows[0]["HandselCouponsNumber"].ToString() != "")
{
model.HandselCouponsNumber = int.Parse(ds.Tables[0].Rows[0]["HandselCouponsNumber"].ToString());
}
if (ds.Tables[0].Rows[0]["HandselCouponsBeginTime"].ToString() != "")
{
model.HandselCouponsBeginTime = DateTime.Parse(ds.Tables[0].Rows[0]["HandselCouponsBeginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["HandselCouponsEndTime"].ToString() != "")
{
model.HandselCouponsEndTime = DateTime.Parse(ds.Tables[0].Rows[0]["HandselCouponsEndTime"].ToString());
}
model.HandselPoint = ds.Tables[0].Rows[0]["HandselPoint"].ToString();
model.ForbidUserId = ds.Tables[0].Rows[0]["ForbidUserId"].ToString();
if (ds.Tables[0].Rows[0]["AnswerValidate"].ToString() != "")
{
model.AnswerValidate = int.Parse(ds.Tables[0].Rows[0]["AnswerValidate"].ToString());
}
model.QuestionFirst = ds.Tables[0].Rows[0]["QuestionFirst"].ToString();
model.AnswerFirst = ds.Tables[0].Rows[0]["AnswerFirst"].ToString();
model.QuestionSecond = ds.Tables[0].Rows[0]["QuestionSecond"].ToString();
model.AnswerSecond = ds.Tables[0].Rows[0]["AnswerSecond"].ToString();
model.UserDefaultGroup = ds.Tables[0].Rows[0]["UserDefaultGroup"].ToString();
if (ds.Tables[0].Rows[0]["GetPasswordMethod"].ToString() != "")
{
model.GetPasswordMethod = int.Parse(ds.Tables[0].Rows[0]["GetPasswordMethod"].ToString());
}
if (ds.Tables[0].Rows[0]["LoginPoint"].ToString() != "")
{
model.LoginPoint = decimal.Parse(ds.Tables[0].Rows[0]["LoginPoint"].ToString());
}
if (ds.Tables[0].Rows[0]["LoginIsNeedCheckCode"].ToString() != "")
{
model.LoginIsNeedCheckCode = int.Parse(ds.Tables[0].Rows[0]["LoginIsNeedCheckCode"].ToString());
}
if (ds.Tables[0].Rows[0]["AllowOtherLogin"].ToString() != "")
{
model.AllowOtherLogin = int.Parse(ds.Tables[0].Rows[0]["AllowOtherLogin"].ToString());
}
model.MoneyToCoupons = ds.Tables[0].Rows[0]["MoneyToCoupons"].ToString();
model.MoneyToDate = ds.Tables[0].Rows[0]["MoneyToDate"].ToString();
model.PointToCoupons = ds.Tables[0].Rows[0]["PointToCoupons"].ToString();
model.PointToDate = ds.Tables[0].Rows[0]["PointToDate"].ToString();
model.CouponsName = ds.Tables[0].Rows[0]["CouponsName"].ToString();
model.CouponsUnits = ds.Tables[0].Rows[0]["CouponsUnits"].ToString();
model.RegisterRequired = ds.Tables[0].Rows[0]["RegisterRequired"].ToString();
model.RegisterRequiredOptional = ds.Tables[0].Rows[0]["RegisterRequiredOptional"].ToString();
return model;
}
else
{
return null;
}
}
private void SaveRegisterInfo()
{
try
{
string AllowRegister = this.ckbAllowRegister.SelectedValue;
int SameEmailRegister = int.Parse(this.ckbSameEmailRegister.SelectedValue);
int AdminValidate = int.Parse(this.ckbAdminValidate.SelectedValue);
int EmailValidate = int.Parse(this.ckbEmailValidate.SelectedValue);
string EmailValidateContent = this.txtEmailValidateContent.Text;
int HandselCoupons = int.Parse(this.ckbHandselCoupons.SelectedValue);
if (txtHandselCouponsNumber.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtHandselCouponsNumber.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，点券数量必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtHandselPoint.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtHandselPoint.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，积分数量必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtLoginPoint.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtLoginPoint.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，登陆积分数量必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtMoneyToCoupons.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtMoneyToCoupons.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，资金与点券兑换比必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
if(int.Parse(txtMoneyToCoupons.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，兑换点卷数量必须大于0。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtMoneyToDate.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtMoneyToDate.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，资金与有效期兑换比必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
if(int.Parse(txtMoneyToDate.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，兑换有效期数量必须大于0。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtPointToCoupons.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtPointToCoupons.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，积分与点券兑换比必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
if(int.Parse(txtPointToCoupons.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，积分兑换点卷数量必须大于0。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
if (txtPointToDate.Text.Trim()!="")
{
if (!ChangeHope.Common.ValidateHelper.IsNumber(txtPointToDate.Text.Trim()))
{
this.ltlMsg.Text = "操作失败，积分与有效期兑换比必须是数字。";
this.pnlMsg.CssClass = "actionErr";
return;
}
if(int.Parse(txtPointToDate.Text.Trim())<=0)
{
this.ltlMsg.Text = "操作失败，积分兑换有效期数量必须大于0。";
this.pnlMsg.CssClass = "actionErr";
return;
}
}
int HandselCouponsNumber = int.Parse(this.txtHandselCouponsNumber.Text);
DateTime HandselCouponsBeginTime = DateTime.Parse(this.txtHandselCouponsBeginTime.Text);
DateTime HandselCouponsEndTime = DateTime.Parse(this.txtHandselCouponsEndTime.Text);
string HandselPoint = this.txtHandselPoint.Text;
string ForbidUserId = this.txtForbidUserId.Text;
int AnswerValidate = int.Parse(this.ckbAnswerValidate.Text);
string QuestionFirst = this.txtQuestionFirst.Text;
string AnswerFirst = this.txtAnswerFirst.Text;
string QuestionSecond = this.txtQuestionSecond.Text;
string AnswerSecond = this.txtAnswerSecond.Text;
string UserDefaultGroup = this.ddlUserDefaultGroup.SelectedValue;
int GetPasswordMethod = int.Parse(this.ckbGetPasswordMethod.SelectedValue);
decimal LoginPoint = decimal.Parse(this.txtLoginPoint.Text);
int LoginIsNeedCheckCode = int.Parse(this.ckbLoginIsNeedCheckCode.SelectedValue);
int AllowOtherLogin = int.Parse(this.ckbAllowOtherLogin.SelectedValue);
string MoneyToCoupons = this.txtMoneyToCoupons.Text;
string MoneyToDate = this.txtMoneyToDate.Text;
string PointToCoupons = this.txtPointToCoupons.Text;
string PointToDate = this.txtPointToDate.Text;
string CouponsName = this.txtCouponsName.Text;
string CouponsUnits = this.txtCouponsUnits.Text;
string RegisterRequired = "";
string RegisterRequiredOptional = "";
foreach (ListItem item in this.ckbRegisterRequired.Items)
{
if (item.Selected)
{
RegisterRequired = RegisterRequired + "," + item.Value;
}
}
foreach (ListItem item in this.ckbRegisterRequiredOptional.Items)
{
if (item.Selected)
{
RegisterRequiredOptional = RegisterRequiredOptional + "," + item.Value;
}
}
ShowShop.Model.SystemInfo.CustomerSetting model = new ShowShop.Model.SystemInfo.CustomerSetting();
model.AllowRegister = AllowRegister;
model.SameEmailRegister = SameEmailRegister;
model.AdminValidate = AdminValidate;
model.EmailValidate = EmailValidate;
model.EmailValidateContent = EmailValidateContent;
model.HandselCoupons = HandselCoupons;
model.HandselCouponsNumber = HandselCouponsNumber;
model.HandselCouponsBeginTime = HandselCouponsBeginTime;
model.HandselCouponsEndTime = HandselCouponsEndTime;
if (model.HandselCouponsEndTime < model.HandselCouponsBeginTime)
{
this.ltlMsg.Text = "赠送积分的时间段开始时间大于了结束时间！";
this.pnlMsg.CssClass = "actionErr";
return;
}
model.HandselPoint = HandselPoint;
model.ForbidUserId = ForbidUserId;
model.AnswerValidate = AnswerValidate;
model.QuestionFirst = QuestionFirst;
model.AnswerFirst = AnswerFirst;
model.QuestionSecond = QuestionSecond;
model.AnswerSecond = AnswerSecond;
model.UserDefaultGroup = UserDefaultGroup;
model.GetPasswordMethod = GetPasswordMethod;
model.LoginPoint = LoginPoint;
model.LoginIsNeedCheckCode = LoginIsNeedCheckCode;
model.AllowOtherLogin = AllowOtherLogin;
model.MoneyToCoupons = MoneyToCoupons;
model.MoneyToDate = MoneyToDate;
model.PointToCoupons = PointToCoupons;
model.PointToDate = PointToDate;
model.CouponsName = CouponsName;
model.CouponsUnits = CouponsUnits;
model.RegisterRequired = RegisterRequired;
model.RegisterRequiredOptional = RegisterRequiredOptional;
ShowShop.BLL.SystemInfo.CustomerSetting bll = new ShowShop.BLL.SystemInfo.CustomerSetting();
if (ChangeHope.Common.StringHelper.StringToInt(this.txtId.Value) > 0)
{
model.SID = ChangeHope.Common.StringHelper.StringToInt(this.txtId.Value);
bll.Update(model);
}
else
{
bll.Add(model);
}
this.ltlMsg.Text = "操作成功！";
this.pnlMsg.CssClass = "actionOk";
}
catch (Exception ex)
{
SaveRegisterInfo();
this.ltlMsg.Text = ex.ToString();
this.pnlMsg.CssClass = "actionErr";
}
finally
{
ChangeHope.Common.CacheClass.RemoveOneCache("CustomerSetting");
this.pnlMsg.Visible = true;
}
}
