public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_contentId = Body.GetQueryInt("contentID");
if (_contentId == 0)
{
_contentIdList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("IDCollection"));
}
if (!IsPostBack)
{
EAppointmentStatusUtils.AddListItems(DdlStatus);
ControlUtils.SelectListItems(DdlStatus, EAppointmentStatusUtils.GetValue(EAppointmentStatus.Agree));
if (_contentId > 0)
{
var contentInfo = DataProviderWx.AppointmentContentDao.GetContentInfo(_contentId);
if (contentInfo != null)
{
DdlStatus.SelectedValue = contentInfo.Status;
TbMessage.Text = contentInfo.Message;
}
}
}
}
void rptContents_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var contentInfo = new AppointmentContentInfo(e.Item.DataItem);
var ltlItemIndex = e.Item.FindControl("ltlItemIndex") as Literal;
var ltlRealName = e.Item.FindControl("ltlRealName") as Literal;
var ltlAppointementTitle = e.Item.FindControl("ltlAppointementTitle") as Literal;
var ltlMobile = e.Item.FindControl("ltlMobile") as Literal;
var ltlExtendVal = e.Item.FindControl("ltlExtendVal") as Literal;
var ltlEmail = e.Item.FindControl("ltlEmail") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
var ltlStatus = e.Item.FindControl("ltlStatus") as Literal;
var ltlMessage = e.Item.FindControl("ltlMessage") as Literal;
var ltlEditUrl = e.Item.FindControl("ltlEditUrl") as Literal;
var ltlSelectUrl = e.Item.FindControl("ltlSelectUrl") as Literal;
AppointmentItemInfo itemInfo = null;
if (_itemInfoDictionary.ContainsKey(contentInfo.AppointmentItemId))
{
itemInfo = _itemInfoDictionary[contentInfo.AppointmentItemId];
}
else
{
itemInfo = DataProviderWx.AppointmentItemDao.GetItemInfo(contentInfo.AppointmentItemId);
_itemInfoDictionary.Add(contentInfo.AppointmentItemId, itemInfo);
}
ltlItemIndex.Text = (e.Item.ItemIndex + 1).ToString();
ltlRealName.Text = contentInfo.RealName;
if (itemInfo != null)
{
ltlAppointementTitle.Text = itemInfo.Title;
AppointmentTitle = itemInfo.Title;
}
ltlMobile.Text = contentInfo.Mobile;
ltlEmail.Text = contentInfo.Email;
ltlAddDate.Text = DateUtils.GetDateAndTimeString(contentInfo.AddDate);
ltlStatus.Text = EAppointmentStatusUtils.GetText(EAppointmentStatusUtils.GetEnumType(contentInfo.Status));
ltlMessage.Text = contentInfo.Message;
ltlEditUrl.Text =
$@"<a href=""javascrip:;"" onclick=""{ModalAppointmentHandle.GetOpenWindowStringToSingle(
PublishmentSystemId, contentInfo.Id)}"">预约处理</a>";
ltlSelectUrl.Text =
$@"<a href=""javascrip:;"" onclick=""{ModalAppointmentContentDetail.GetOpenWindowStringToSingle(
PublishmentSystemId, contentInfo.Id)}"">预约详情</a>";
}
}
public void ddlStatus_SelectedIndexChanged(object sender, EventArgs e)
{
var status = EAppointmentStatusUtils.GetEnumType(DdlStatus.SelectedValue);
if (status == EAppointmentStatus.Agree || status == EAppointmentStatus.Refuse)
{
PhMessage.Visible = true;
}
else
{
PhMessage.Visible = false;
}
}
public bool IsExist(int itemId, string cookieSn, string wxOpenId, string userName)
{
var isExist = false;
var statusList = new List <string>();
statusList.Add(EAppointmentStatusUtils.GetValue(EAppointmentStatus.Handling));
statusList.Add(EAppointmentStatusUtils.GetValue(EAppointmentStatus.Agree));
string sqlWhere =
$"WHERE {AppointmentContentAttribute.AppointmentItemId} = {itemId} AND {AppointmentContentAttribute.Status} IN ({TranslateUtils.ToSqlInStringWithQuote(statusList)})";
sqlWhere += $" AND ({AppointmentContentAttribute.CookieSn} = '{PageUtils.FilterSql(cookieSn)}'";
if (!string.IsNullOrEmpty(wxOpenId))
{
sqlWhere += $" OR {AppointmentContentAttribute.WxOpenId} = '{PageUtils.FilterSql(wxOpenId)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
sqlWhere += $" OR {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
sqlWhere += ")";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, AppointmentContentAttribute.Id, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
isExist = true;
}
rdr.Close();
}
return(isExist);
}
public bool IsExist(int itemID, string cookieSN, string wxOpenID, string userName)
{
var isExist = false;
var statusList = new List <string>();
statusList.Add(EAppointmentStatusUtils.GetValue(EAppointmentStatus.Handling));
statusList.Add(EAppointmentStatusUtils.GetValue(EAppointmentStatus.Agree));
string SQL_WHERE =
$"WHERE {AppointmentContentAttribute.AppointmentItemID} = {itemID} AND {AppointmentContentAttribute.Status} IN ({TranslateUtils.ToSqlInStringWithQuote(statusList)})";
SQL_WHERE += $" AND ({AppointmentContentAttribute.CookieSN} = '{PageUtils.FilterSql(cookieSN)}'";
if (!string.IsNullOrEmpty(wxOpenID))
{
SQL_WHERE += $" OR {AppointmentContentAttribute.WXOpenID} = '{PageUtils.FilterSql(wxOpenID)}'";
}
else if (!string.IsNullOrEmpty(userName))
{
SQL_WHERE += $" OR {AppointmentContentAttribute.UserName} = '{PageUtils.FilterSql(userName)}'";
}
SQL_WHERE += ")";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, AppointmentContentAttribute.ID, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
isExist = true;
}
rdr.Close();
}
return(isExist);
}
public void ExportAppointmentContentCSV(string filePath, List <AppointmentContentInfo> appointmentContentInfolList, string appointmentTitle, int appointmentID)
{
var appointmentInfo = DataProviderWX.AppointmentDAO.GetAppointmentInfo(appointmentID);
var head = new List <string>();
head.Add("序号");
head.Add("预约名称");
if (appointmentInfo.IsFormRealName == "True")
{
head.Add(appointmentInfo.FormRealNameTitle);
}
if (appointmentInfo.IsFormMobile == "True")
{
head.Add(appointmentInfo.FormMobileTitle);
}
if (appointmentInfo.IsFormEmail == "True")
{
head.Add(appointmentInfo.FormEmailTitle);
}
head.Add("预约时间");
head.Add("预约状态");
head.Add("留言");
var configExtendInfoList = DataProviderWX.ConfigExtendDAO.GetConfigExtendInfoList(PublishmentSystemId, appointmentID, EKeywordTypeUtils.GetValue(EKeywordType.Appointment));
foreach (var cList in configExtendInfoList)
{
head.Add(cList.AttributeName);
}
var rows = new List <List <string> >();
var index = 1;
foreach (var applist in appointmentContentInfolList)
{
var row = new List <string>();
row.Add((index++).ToString());
row.Add(appointmentTitle);
if (appointmentInfo.IsFormRealName == "True")
{
row.Add(applist.RealName);
}
if (appointmentInfo.IsFormMobile == "True")
{
row.Add(applist.Mobile);
}
if (appointmentInfo.IsFormEmail == "True")
{
row.Add(applist.Email);
}
row.Add(DateUtils.GetDateAndTimeString(applist.AddDate));
row.Add(EAppointmentStatusUtils.GetText(EAppointmentStatusUtils.GetEnumType(applist.Status)));
row.Add(applist.Message);
var SettingsXML = applist.SettingsXML.Replace("{", "").Replace("}", "");
var arr = SettingsXML.Split(',');
if (arr[0] != "")
{
for (var i = 0; i < arr.Length; i++)
{
var arr1 = arr[i].Replace("\"", "").Split(':');
row.Add(arr1[1]);
}
}
rows.Add(row);
}
CSVUtils.Export(filePath, head, rows);
}
