public override bool AddSiteRequest(SiteRequestInfo siteRequest)
{
DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO Hishop_SiteRequest(UserId,FirstSiteUrl,FirstRecordCode,SecondSiteUrl,SecondRecordCode,RequestTime,RequestStatus,RefuseReason)VALUES(@UserId,@FirstSiteUrl,@FirstRecordCode,@SecondSiteUrl,@SecondRecordCode,@RequestTime,@RequestStatus,@RefuseReason)");
database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, HiContext.Current.User.UserId);
database.AddInParameter(sqlStringCommand, "FirstSiteUrl", DbType.String, siteRequest.FirstSiteUrl);
database.AddInParameter(sqlStringCommand, "FirstRecordCode", DbType.String, siteRequest.FirstRecordCode);
database.AddInParameter(sqlStringCommand, "SecondSiteUrl", DbType.String, siteRequest.SecondSiteUrl);
database.AddInParameter(sqlStringCommand, "SecondRecordCode", DbType.String, siteRequest.SecondRecordCode);
database.AddInParameter(sqlStringCommand, "RequestTime", DbType.DateTime, siteRequest.RequestTime);
database.AddInParameter(sqlStringCommand, "RequestStatus", DbType.Int32, (int)siteRequest.RequestStatus);
database.AddInParameter(sqlStringCommand, "RefuseReason", DbType.String, siteRequest.RefuseReason);
return (database.ExecuteNonQuery(sqlStringCommand) == 1);
}
private void btnRequestAgain_Click(object sender, EventArgs e)
{
SubsiteStoreHelper.DeleteSiteRequest();
SiteRequestInfo target = new SiteRequestInfo();
target.FirstSiteUrl = txtFirstSiteUrl.Text.Trim();
target.FirstRecordCode = txtFirstRecordCode.Text.Trim();
target.SecondSiteUrl = txtSencondSiteUrl.Text.Trim();
target.SecondRecordCode = txtSecondRecordCode.Text.Trim();
target.RequestTime = DateTime.Now;
target.RequestStatus = SiteRequestStatus.Dealing;
ValidationResults results = Hishop.Components.Validation.Validation.Validate<SiteRequestInfo>(target, new string[] { "ValSiteRequest" });
string msg = string.Empty;
if (!results.IsValid)
{
foreach (ValidationResult result in (IEnumerable<ValidationResult>)results)
{
msg = msg + Formatter.FormatErrorMessage(result.Message);
}
ShowMsg(msg, false);
}
else
{
SiteRequestInfo mySiteRequest = SubsiteStoreHelper.GetMySiteRequest();
if ((mySiteRequest != null) && (mySiteRequest.RequestStatus == SiteRequestStatus.Dealing))
{
ShowMsg("你上一条申请还未处理，请联系供应商", false);
}
else if (SubsiteStoreHelper.AddSiteRequest(target))
{
base.Response.Redirect(Globals.ApplicationPath + "/ShopAdmin/store/ShowSiteRequestStatus.aspx");
}
else
{
ShowMsg("站点申请提交失败", false);
}
}
}
public abstract bool AddSiteRequest(SiteRequestInfo siteRequest);
public static SiteRequestInfo PopulSiteRequest(IDataReader reader)
{
SiteRequestInfo info = new SiteRequestInfo();
info.RequestId = (int) reader["RequestId"];
info.UserId = (int) reader["UserId"];
info.FirstSiteUrl = (string) reader["FirstSiteUrl"];
info.FirstRecordCode = (string) reader["FirstRecordCode"];
if (reader["SecondSiteUrl"] != DBNull.Value)
{
info.SecondSiteUrl = (string) reader["SecondSiteUrl"];
}
if (reader["SecondRecordCode"] != DBNull.Value)
{
info.SecondRecordCode = (string) reader["SecondRecordCode"];
}
info.RequestTime = (DateTime) reader["RequestTime"];
info.RequestStatus = (SiteRequestStatus) reader["RequestStatus"];
if (reader["RefuseReason"] != DBNull.Value)
{
info.RefuseReason = (string) reader["RefuseReason"];
}
return info;
}
public static bool AddSiteRequest(SiteRequestInfo siteRequest)
{
return SubsiteStoreProvider.Instance().AddSiteRequest(siteRequest);
}
