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); }