protected void btnExport_Click(object sender, EventArgs e)
{
int hours1 = 0;
int min1 = 0;
int sec1 = 0;
int hours2 = 0;
int min2 = 0;
int sec2 = 0;
try
{
hours1 = string.IsNullOrEmpty(tbHours1.Text.Trim()) ? 0 : Convert.ToInt32(tbHours1.Text.Trim());
min1 = string.IsNullOrEmpty(tbMin1.Text.Trim()) ? 0 : Convert.ToInt32(tbMin1.Text.Trim());
sec1 = string.IsNullOrEmpty(tbSecond1.Text.Trim()) ? 0 : Convert.ToInt32(tbSecond1.Text.Trim());
hours2 = string.IsNullOrEmpty(tbHours2.Text.Trim()) ? 0 : Convert.ToInt32(tbHours2.Text.Trim());
min2 = string.IsNullOrEmpty(tbMin2.Text.Trim()) ? 0 : Convert.ToInt32(tbMin2.Text.Trim());
sec2 = string.IsNullOrEmpty(tbSecond2.Text.Trim()) ? 0 : Convert.ToInt32(tbSecond2.Text.Trim());
if (hours1 > 23 || min1 > 59 || sec1 > 59 || min2 > 59 || sec2 > 59 || hours2 > 23)
{
Response.Write("<script language='javascript'>alert('请正确填写时分秒');</script>");
return;
}
}
catch (Exception edd)
{
Response.Write("<script language='javascript'>alert('请正确填写时分秒');</script>");
return;
}
string startTime;
if (string.IsNullOrEmpty(txt_StartTime.Value))
{
startTime = txt_StartTime.Value;
}
else
{
startTime = txt_StartTime.Value + " " + hours1 + ":" + min1 + ":" + sec1;
}
string endTime;
if (string.IsNullOrEmpty(txt_EndTime.Value))
{
endTime = txt_EndTime.Value;
}
else
{
endTime = txt_EndTime.Value + " " + hours2 + ":" + min2 + ":" + sec2;
}
DataTable tb = MsgBLL.GetSellerMsgSendHisForReminder(txtTitle.Text.Trim(), startTime, endTime, drpSendType.SelectedValue, "", "");
DownloadToExcel(tb);
}
protected void gd_All_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Show")
{
IsAll.Value = "0";
int idx = Convert.ToInt16(e.CommandArgument.ToString());
string buyer = dtMsgCount.Rows[idx]["sellerNick"].ToString();
Buyer.Value = buyer;
DataTable tb = MsgBLL.GetSellerMsgSendHisForReminder(buyer, "",
"", "---全部---", "", "");
grdCus.DataSource = tb;
grdCus.DataBind();
}
}
private void MsgDataBind()
{
int hours1 = 0;
int min1 = 0;
int sec1 = 0;
int hours2 = 0;
int min2 = 0;
int sec2 = 0;
try
{
hours1 = string.IsNullOrEmpty(tbHours1.Text.Trim()) ? 0 : Convert.ToInt32(tbHours1.Text.Trim());
min1 = string.IsNullOrEmpty(tbMin1.Text.Trim()) ? 0 : Convert.ToInt32(tbMin1.Text.Trim());
sec1 = string.IsNullOrEmpty(tbSecond1.Text.Trim()) ? 0 : Convert.ToInt32(tbSecond1.Text.Trim());
hours2 = string.IsNullOrEmpty(tbHours2.Text.Trim()) ? 0 : Convert.ToInt32(tbHours2.Text.Trim());
min2 = string.IsNullOrEmpty(tbMin2.Text.Trim()) ? 0 : Convert.ToInt32(tbMin2.Text.Trim());
sec2 = string.IsNullOrEmpty(tbSecond2.Text.Trim()) ? 0 : Convert.ToInt32(tbSecond2.Text.Trim());
if (hours1 > 23 || min1 > 59 || sec1 > 59 || min2 > 59 || sec2 > 59 || hours2 > 23)
{
Response.Write("<script language='javascript'>alert('请正确填写时分秒');</script>");
return;
}
}
catch (Exception e)
{
Response.Write("<script language='javascript'>alert('请正确填写时分秒');</script>");
return;
}
string startTime;
if (string.IsNullOrEmpty(txt_StartTime.Value))
{
startTime = txt_StartTime.Value;
}
else
{
startTime = txt_StartTime.Value + " " + hours1 + ":" + min1 + ":" + sec1;
}
string endTime;
if (string.IsNullOrEmpty(txt_EndTime.Value))
{
endTime = txt_EndTime.Value;
}
else
{
endTime = txt_EndTime.Value + " " + hours2 + ":" + min2 + ":" + sec2;
}
try
{
if (IsAll.Value == "1")
{
DataTable tb = MsgBLL.GetSellerMsgSendHisForReminder(txtTitle.Text.Trim(), startTime, endTime, drpSendType.SelectedValue, "", "");
grdCus.DataSource = tb;
grdCus.DataBind();
}
else
{
DataTable tb = MsgBLL.GetSellerMsgSendHisForReminder(Buyer.Value, "",
"", "---全部---", "", "");
grdCus.DataSource = tb;
grdCus.DataBind();
}
}
catch (Exception ex)
{
ExceptionReporter.WriteLog(ex, ExceptionPostion.TBApply_Data);
}
}
