protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
if (this.ddlCoalKind.SelectedValue == "")
{
MessageBox.Show(this, "请选择煤种!");
return;
}
if (this.txtDate.Value.Trim() == "")
{
MessageBox.Show(this, "生效日期不能为空!");
return;
}
if (Convert.ToDateTime(this.txtDate.Value) < DateTime.Now)
{
MessageBox.Show(this, "生效日期不能小于当前日期!");
return;
}
List<string> listRoom = new List<string>();
List<TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail> listModel = new List<TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail>();
if (this.ddlRoom.SelectedValue == "")
{
foreach (ListItem li in this.ddlRoom.Items)
{
if (li.Value != "")
listRoom.Add(li.Value);
}
}
else
{
listRoom.Add(this.ddlRoom.SelectedValue);
}
string strIsAll = "";
if (listRoom.Count > 1)
strIsAll = "1";
else
strIsAll = "0";
lock (this)
{
decimal dTaxGroup = DbHelperSQL.GetMaxID("TaxGroup", "TT_TaxItemDetail");
foreach (GridViewRow gr in this.gdvList.Rows)
{
GridView gdvDetail = (GridView)gr.Cells[1].FindControl("gdvDetail");
foreach (GridViewRow r in gdvDetail.Rows)
{
TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail model = new TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail();
string strAmount = ((TextBox)r.Cells[1].FindControl("txtAmount")).Text.Trim().Replace(" ","");
if (strAmount == "")
strAmount = "0";
model.Amount = Convert.ToDecimal(strAmount);
model.CoalKindCode = this.ddlCoalKind.SelectedValue;
model.EffectTime = Convert.ToDateTime(this.txtDate.Value.Trim());
model.Operator = CookieManager.GetCookieValue("UserName");
model.OperateTime = DateTime.Now;
model.TaxItemCode = gdvDetail.DataKeys[r.RowIndex].Value.ToString();
model.TaxGroup = dTaxGroup;
model.IsAll = strIsAll;
listModel.Add(model);
}
}
if (bll.Add(listModel, listRoom))
{
#region 数据同步
//StringBuilder strSql = new StringBuilder("");
//foreach (string strRoomCode in listRoom)
//{
// //如果同一天设置了多次规费，删除这一天的设置和分配，重新添加并且重新分配
// strSql.Append("Delete TT_TaxItemDetail where RoomCode='" + strRoomCode + "' and CoalKindCode='" + listModel[0].CoalKindCode + "' and EffectTime='" + listModel[0].EffectTime + "';");
// strSql.Append("Delete TT_TaxAssignDetail where ItemDetailId in (select ItemDetailId from TT_TaxItemDetail where RoomCode='" + strRoomCode + "' and CoalKindCode='" + listModel[0].CoalKindCode + "' and EffectTime='" + listModel[0].EffectTime + "');");
// foreach (TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail model in listModel)
// {
// model.RoomCode = strRoomCode;
// strSql.Append("insert into TT_TaxItemDetail(");
// strSql.Append("CoalKindCode,RoomCode,TaxItemCode,Amount,EffectTime,Operator,OperateTime,TaxGroup,IsAssigned,IsAll)");
// strSql.Append(" values (");
// strSql.Append("'" + model.CoalKindCode + "','" + model.RoomCode + "','" + model.TaxItemCode + "','" + model.Amount + "','" + model.EffectTime + "','" + model.Operator + "','" + model.OperateTime + "','" + dTaxGroup + "','0','" + model.IsAll + "');");
// }
// dTaxGroup++;
//}
//string strMq = mq.AllStation + mq.Prefix + "TT_TaxItemDetail" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + mq.Prefix + strSql.ToString();
//mq.AddMsmq(strMq.ToString());禁用了消息队列
#endregion
loadData();
this.ddlCoalKind.SelectedValue = "";
this.ddlRoom.SelectedValue = "";
this.txtDate.Value = "";
MessageBox.Show(this, "规费设置成功!");
#region 打印明细单
string strRoom = "";
if (this.ddlRoom.SelectedValue == "")
{
foreach (ListItem li in this.ddlRoom.Items)
{
if (li.Value != "")
strRoom += "'" + li.Value + "',";
}
}
else
{
strRoom = "'" + ddlRoom.SelectedValue + "'";
}
if (strRoom != "")
strRoom = strRoom.TrimEnd(',');
string userName = GetUserName();
string title = GetXianName();
title += "规费标准设置";
string strWhere = " 1=1 ";
strWhere += " and a.RoomCode in(" + strRoom + ") and a.CoalKindCode='" + ddlCoalKind.SelectedValue + "' and EffectTime='"+this.txtDate.Value+"'";
strWhere = Server.UrlEncode(strWhere);
#endregion
ScriptManager.RegisterStartupScript(this, Page.GetType(), "", "LoadUrl(\"" + strWhere + "\",'" + userName + "','" + title + "','" + strTaxObject + "');", true);
//ClientScript.RegisterStartupScript(Page.GetType(), "", "this.top.currForm.close();", true);
}
else
MessageBox.Show(this, "规费设置失败!");
}
}
protected void btnSave_Click(object sender, ImageClickEventArgs e)
{
if (this.ddlCoalKind.SelectedValue == "")
{
MessageBox.Show(this.UpdatePanel1,this, "请选择煤种!");
return;
}
if (this.ddlEffectTime.SelectedValue == "")
{
MessageBox.Show(this.UpdatePanel1,this, "您的选择没有要修改的规费设置!");
return;
}
List<string> listRoom = new List<string>();
List<TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail> listModel = new List<TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail>();
if (this.ddlRoom.SelectedValue == "")
{
foreach (ListItem li in this.ddlRoom.Items)
{
if (li.Value != "")
listRoom.Add(li.Value);
}
}
else
listRoom.Add(this.ddlRoom.SelectedValue);
string strIsAll = "";
if (listRoom.Count > 1)
strIsAll = "1";
else
strIsAll = "0";
lock (this)
{
decimal dTaxGroup = DbHelperSQL.GetMaxID("TaxGroup", "TT_TaxItemDetail");
foreach (GridViewRow gr in this.gdvList.Rows)
{
GridView gdvDetail = (GridView)gr.Cells[1].FindControl("gdvDetail");
foreach (GridViewRow r in gdvDetail.Rows)
{
TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail model = new TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail();
string strAmount = ((TextBox)r.Cells[1].FindControl("txtAmount")).Text.Trim().Replace(" ","");
if (strAmount == "")
strAmount = "0";
model.Amount = Convert.ToDecimal(strAmount);
model.CoalKindCode = this.ddlCoalKind.SelectedValue;
model.EffectTime = Convert.ToDateTime(this.ddlEffectTime.SelectedValue);
model.Operator = CookieManager.GetCookieValue("UserName");
model.OperateTime = DateTime.Now;
model.TaxItemCode = gdvDetail.DataKeys[r.RowIndex].Value.ToString();
model.TaxGroup = dTaxGroup;
model.IsAll = strIsAll;
listModel.Add(model);
}
}
if (bll.Add(listModel, listRoom))
{
#region 数据同步
StringBuilder strSql = new StringBuilder("");
foreach (string strRoomCode in listRoom)
{
//如果同一天设置了多次规费，删除这一天的设置和分配，重新添加并且重新分配
strSql.Append("Delete TT_TaxItemDetail where RoomCode='" + strRoomCode + "' and CoalKindCode='" + listModel[0].CoalKindCode + "' and EffectTime='" + listModel[0].EffectTime + "';");
strSql.Append("Delete TT_TaxAssignDetail where ItemDetailId in (select ItemDetailId from TT_TaxItemDetail where RoomCode='" + strRoomCode + "' and CoalKindCode='" + listModel[0].CoalKindCode + "' and EffectTime='" + listModel[0].EffectTime + "');");
foreach (TDTK.IndustryPlatform.CoalTraffic.Model.TT_TaxItemDetail model in listModel)
{
model.RoomCode = strRoomCode;
strSql.Append("insert into TT_TaxItemDetail(");
strSql.Append("CoalKindCode,RoomCode,TaxItemCode,Amount,EffectTime,Operator,OperateTime,TaxGroup,IsAssigned,IsAll)");
strSql.Append(" values (");
strSql.Append("'" + model.CoalKindCode + "','" + model.RoomCode + "','" + model.TaxItemCode + "','" + model.Amount + "','" + model.EffectTime + "','" + model.Operator + "','"+model.OperateTime+"','" + model.TaxGroup + "','0','" + model.IsAll + "');");
}
}
string strMq = mq.AllStation + mq.Prefix + "TT_TaxItemDetail" + mq.Prefix + mq.EditFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + mq.Prefix + strSql.ToString();
mq.AddMsmq(strMq.ToString());
#endregion
ScriptManager.RegisterStartupScript(this.UpdatePanel1, this.GetType(), "", "this.top.currForm.close();", true);
}
else
MessageBox.Show(this.UpdatePanel1, this, "规费设置失败!");
}
}
