protected void ExportToExcel(object sender, EventArgs e)
{
List <QueryFilter> queryFilters = new List <QueryFilter>();
int channelID = 0;
if (this.cmbSChannelID.SelectedItem != null && this.cmbSChannelID.SelectedItem.Value != "")
{
channelID = Convert.ToInt32(this.cmbSChannelID.SelectedItem.Value);
}
if (this.cmbSOperatorType.SelectedItem != null && this.cmbSOperatorType.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_OPERATORTYPE, this.cmbSOperatorType.SelectedItem.Value, FilterFunction.EqualTo));
}
if (this.cmbSProvince.SelectedItem != null && this.cmbSProvince.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_PROVINCE, this.cmbSProvince.SelectedItem.Value, FilterFunction.Contains));
}
if (!string.IsNullOrEmpty(this.txtSMo.Text))
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_MO, this.txtSMo.Text.Trim(), FilterFunction.Contains));
}
if (!string.IsNullOrEmpty(this.txtSPort.Text))
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_SPCODE, this.txtSPort.Text.Trim(), FilterFunction.Contains));
}
if (this.cmbSEnbale.SelectedItem != null && this.cmbSEnbale.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_ISENABLE, this.cmbSEnbale.SelectedItem.Value.Equals("1").ToString(), FilterFunction.EqualTo));
}
if (this.cmbLimit.SelectedItem != null && this.cmbLimit.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_ISLIMIT, this.cmbLimit.SelectedItem.Value.Equals("1").ToString(), FilterFunction.EqualTo));
}
List <SPCodeInfoWrapper> dataSource = SPCodeInfoWrapper.FindAllByOrderByAndChannelID(channelID, queryFilters, "", false);
byte[] reportFile = ReportViewHelper.ExportListToExcel(this.rptvExport, dataSource, "DataSet1", "自定义数据导出报表");
this.Response.Clear();
this.Response.ContentType = "application/vnd.ms-excel";
this.Response.AddHeader("Content-Disposition", "attachment; filename=submittedData.xls");
this.Response.BinaryWrite(reportFile);
this.Response.End();
}
public void Show(int id)
{
try
{
SPCodeInfoWrapper obj = SPCodeInfoWrapper.FindById(id);
if (obj != null)
{
if (obj.ChannelID != null)
{
this.cmbChannelID.Value = obj.ChannelID.Id;
}
cmbOperatorType.Value = obj.OperatorType;
txtMo.Text = obj.Mo;
cmbCodeType.Value = obj.CodeType;
txtSPCode.Text = obj.SPCode;
this.chkIsLimit.Checked = obj.IsLimit;
this.chkIsEnable.Checked = obj.IsEnable;
this.txtProvince.Text = obj.Province;
this.txtSendText.Text = obj.SendText;
this.txtComent.Text = obj.Comment;
this.txtDayMonthLimit.Text = obj.DayMonthLimit;
this.txtDisableArea.Text = obj.DisableArea;
this.txtPrice.Text = obj.Price;
hidId.Text = id.ToString();
winSPCodeInfoEdit.Show();
}
else
{
ScriptManager.AjaxSuccess = false;
ScriptManager.AjaxErrorMessage = "错误信息：数据不存在";
return;
}
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
return;
}
}
public void DeleteRecord(int id)
{
try
{
SPCodeInfoWrapper.DeleteByID(id);
ScriptManager.AjaxSuccess = true;
}
catch (Exception ex)
{
ScriptManager.AjaxSuccess = false;
ScriptManager.AjaxErrorMessage = string.Format(ex.Message);
return;
}
}
protected void btnSaveSPCodeInfo_Click(object sender, AjaxEventArgs e)
{
try
{
SPCodeInfoWrapper obj = new SPCodeInfoWrapper();
if (this.cmbChannelID.SelectedItem != null)
{
obj.ChannelID = SPChannelWrapper.FindById(Convert.ToInt32(this.cmbChannelID.SelectedItem.Value.ToString()));
}
obj.OperatorType = cmbOperatorType.SelectedItem.Value;
obj.Mo = txtMo.Text.Trim();
obj.CodeType = cmbCodeType.SelectedItem.Value;
obj.SPCode = txtSPCode.Text.Trim();
obj.IsLimit = this.chkIsLimit.Checked;
obj.IsEnable = this.chkIsEnable.Checked;
obj.Province = this.txtProvince.Text.Trim();
obj.SendText = this.txtSendText.Text.Trim();
obj.Comment = this.txtComent.Text.Trim();
obj.DayMonthLimit = this.txtDayMonthLimit.Text.Trim();
obj.DisableArea = this.txtDisableArea.Text.Trim();
obj.Price = this.txtPrice.Text.Trim();
obj.CreateTime = System.DateTime.Now;
obj.CreateUser = this.ParentPage.CurrentLoginUser.UserID;
SPCodeInfoWrapper.Save(obj);
winSPCodeInfoAdd.Hide();
}
catch (Exception ex)
{
Coolite.Ext.Web.ScriptManager.AjaxSuccess = false;
Coolite.Ext.Web.ScriptManager.AjaxErrorMessage = "错误信息：" + ex.Message;
}
}
protected void storeSPCodeInfo_Refresh(object sender, StoreRefreshDataEventArgs e)
{
int recordCount = 0;
string sortFieldName = "";
if (e.Sort != null)
{
sortFieldName = e.Sort;
}
int startIndex = 0;
if (e.Start > -1)
{
startIndex = e.Start;
}
int limit = this.PagingToolBar1.PageSize;
int pageIndex = 1;
if ((startIndex % limit) == 0)
{
pageIndex = startIndex / limit + 1;
}
else
{
pageIndex = startIndex / limit;
}
List <QueryFilter> queryFilters = new List <QueryFilter>();
int channelID = 0;
if (this.cmbSChannelID.SelectedItem != null && this.cmbSChannelID.SelectedItem.Value != "")
{
channelID = Convert.ToInt32(this.cmbSChannelID.SelectedItem.Value);
}
if (this.cmbSOperatorType.SelectedItem != null && this.cmbSOperatorType.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_OPERATORTYPE, this.cmbSOperatorType.SelectedItem.Value, FilterFunction.EqualTo));
}
if (this.cmbSProvince.SelectedItem != null && this.cmbSProvince.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_PROVINCE, this.cmbSProvince.SelectedItem.Value, FilterFunction.Contains));
}
if (!string.IsNullOrEmpty(this.txtSMo.Text))
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_MO, this.txtSMo.Text.Trim(), FilterFunction.Contains));
}
if (!string.IsNullOrEmpty(this.txtSPort.Text))
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_SPCODE, this.txtSPort.Text.Trim(), FilterFunction.Contains));
}
if (this.cmbSEnbale.SelectedItem != null && this.cmbSEnbale.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_ISENABLE, this.cmbSEnbale.SelectedItem.Value.Equals("1").ToString(), FilterFunction.EqualTo));
}
if (this.cmbLimit.SelectedItem != null && this.cmbLimit.SelectedItem.Value != "")
{
queryFilters.Add(new QueryFilter(SPCodeInfoWrapper.PROPERTY_NAME_ISLIMIT, this.cmbLimit.SelectedItem.Value.Equals("1").ToString(), FilterFunction.EqualTo));
}
storeSPCodeInfo.DataSource = SPCodeInfoWrapper.FindAllByOrderByAndFilterAndChannelID(channelID, queryFilters, sortFieldName, (e.Dir == SortDirection.DESC), pageIndex, limit, out recordCount);
e.TotalCount = recordCount;
storeSPCodeInfo.DataBind();
}
