/// <summary>
///点击确定按钮触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button_sumbit_Click(object sender, EventArgs e)
{
try
{
string NAME = this.txtCardName.Text;//获取到资金卡名称
if (String.IsNullOrEmpty(NAME))
{
tag.Text = "名称不能为空，请填写名称！";
return;
}
bool checkName = bCash_CardsExt.Exists(NAME);
if (checkName)
{
tag.Text = "该名称已经存在，请修改！";
return;
}
if (string.IsNullOrEmpty(TB_DateTime.Value) || DateTime.Parse(TB_DateTime.Value) < DateTime.Parse(DateTime.Now.ToLongDateString()))
{
tag.Text = "到期日期必须大于或等于当前日期";
return;
}
if (!Cash_CarDetailMX1.ReturnTnF())
{
tag.Text = "未添加明细，请添加！";
return;
}
int intMaxID = bCash_Cards.GetMaxId();
int ZJK = 0;
DataTable dt = new DataTable();
dt = bCash_Cards.GetList("Statas=0 or Statas=1").Tables[0];
if (dt.Rows.Count > 0)
{
ZJK = dt.Rows.Count;
}
mCash_Cards = new Dianda.Model.Cash_Cards();
mCash_Cards.ID = intMaxID;
string time = DateTime.Now.ToString("yyyyMMdd");
//资金卡编号
mCash_Cards.CardNum = "zjk" + time + ZJK.ToString("0000");
//资金卡名称
mCash_Cards.CardName = NAME;
//所属项目
mCash_Cards.ProjectID = Int32.Parse(this.ddlProjectID.SelectedValue);
//所属预算报告
mCash_Cards.SFOrderID = int.Parse(DDL_Budget.SelectedValue.ToString());
//所属部门
mCash_Cards.DepartmentID = this.ddlDepartmentID.SelectedValue;
//持卡人
mCash_Cards.CardholderID = this.ddlCardholderID.SelectedValue;
//到期时间
mCash_Cards.EndTime = DateTime.Parse(TB_DateTime.Value);
//审批人
mCash_Cards.ApproverIDs = this.ddlApproverIDs.SelectedValue;
//创建日期
mCash_Cards.DATETIME = DateTime.Now;
//状态
mCash_Cards.Statas = 1;
//创建人
mCash_Cards.DoUserID = ((Model.USER_Users)Session["USER_Users"]).USERNAME;
//新建时，可用金额和预算金额及当前余额都是一样
decimal Balance = decimal.Parse(Cash_CarDetailMX1.Balance);
//预算金额
mCash_Cards.Balance = Balance;
//可用金额
mCash_Cards.LimitNums = Balance;
//当前余额
mCash_Cards.YEBalance = Balance;
int carid = bCash_CardsExt.Add(mCash_Cards);
Cash_CarDetailMX1.Submit(carid);
/*-------------------资金卡明细----------begin--------*/
//开始操作资金卡明细信息
//GridView GV = Cash_CarDetailList.GV1;
//if (GV.Rows.Count > 0)
//{
// Model.Cash_CardsDetail cardsdetail_model = new Dianda.Model.Cash_CardsDetail();
// BLL.Cash_CardsDetail cardsdetail_bll = new Dianda.BLL.Cash_CardsDetail();
// for (int i = 0; i < GV.Rows.Count; i++)
// {
// HiddenField HF_DetailID = (HiddenField)GV.Rows[i].FindControl("HiddenField_deid");
// TextBox TB_balance = (TextBox)GV.Rows[i].FindControl("TextBox_balance");
// DropDownList DropDownList_Unit = (DropDownList)GV.Rows[i].FindControl("DropDownList_Unit");
// int Unit = int.Parse(DropDownList_Unit.SelectedValue.ToString());
// RadioButtonList RadioButtonList_typename = (RadioButtonList)GV.Rows[i].FindControl("RadioButtonList_typename");
// //ID
// cardsdetail_model.ID = cardsdetail_bll.GetMaxId();
// //资金卡ID
// cardsdetail_model.CardID = carid;
// //明细项目的ID
// cardsdetail_model.DetailID = int.Parse(HF_DetailID.Value.ToString());
// //在新建资金卡时，预算金额、可用金额、当前余额都是一样的
// //各明细项的当前余额
// cardsdetail_model.Balance = decimal.Parse(TB_balance.Text.ToString()) * Unit;
// //预算金额
// cardsdetail_model.Oldbalance = decimal.Parse(TB_balance.Text.ToString()) * Unit;
// //可用金额
// cardsdetail_model.KYbalance = decimal.Parse(TB_balance.Text.ToString()) * Unit;
// //单位
// cardsdetail_model.Unit = Unit;
// //细目的类型
// cardsdetail_model.TypesName = RadioButtonList_typename.SelectedValue.ToString();
// cardsdetail_bll.Add(cardsdetail_model);
// }
//}
/*-------------------资金卡明细----------begin--------*/
/*---------------------一旦为某一个预算报告新创建了一个新的资金卡,就要在预算报告的资金卡数量上加1 -----------begin--------------*/
BLL.Cash_SF_Order order_bll = new Dianda.BLL.Cash_SF_Order();
Model.Cash_SF_Order order_model = new Dianda.Model.Cash_SF_Order();
string SFOrderID = mCash_Cards.SFOrderID.ToString();
order_model = order_bll.GetModel(int.Parse(SFOrderID));
//资金卡数量加1
order_model.CarNums = order_model.CarNums + 1;
order_bll.Update(order_model);
/*---------------------一旦为某一个预算报告新创建了一个新的资金卡,就要在预算报告的资金卡数量上加1---------------end------------*/
Cash_CarDetailMX1.main(carid.ToString());
tag.Text = "操作成功！";
tag2.Text = "操作成功！";
this.lblCardNum.Text = mCash_Cards.CardNum;
this.Button_sumbit.Visible = false;
//this.Button_reset.Visible = false;
//string coutws = "<script language=\"javascript\" type=\"text/javascript\">alert(\"操作成功！现在进入列表页面\"); location.href = \"manage.aspx" + "\";</script>";
//Response.Write(coutws);
//添加操作日志
Dianda.BLL.SYS_LogsExt bsyslog = new Dianda.BLL.SYS_LogsExt();
Model.USER_Users user_model = (Model.USER_Users)Session["USER_Users"];
bsyslog.addlogs(((Model.USER_Users)Session["USER_Users"]).REALNAME + "(" + ((Model.USER_Users)Session["USER_Users"]).USERNAME + ")", "新增资金卡", "新增资金卡" + mCash_Cards.CardNum + "成功");
//添加操作日志
string coutws = "alert(\"操作成功！现在返回列表页面\"); ";
coutws += "location.href = \"manage.aspx?pageindex=" + Request["pageindex"] + "\";";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "addScript", coutws, true);
}
catch
{
tag.Text = "操作失败，请重试！";
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Dianda.Model.Cash_SF_Order GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,NAMES,SpecialFundsID,ProjectID,ADDTIME,BudgetAmount,BAUNIT,ActualAmount,AAUNIT,Applyuser,Status,Delflag,BudgetList,Note,CheckerHistory,Checker,AssignChecker,CarNums,TEMP1,TEMP2,TEMP3,TEMP4,TEMP5,CheckTime from Cash_SF_Order ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
Dianda.Model.Cash_SF_Order model = new Dianda.Model.Cash_SF_Order();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["NAMES"] != null && ds.Tables[0].Rows[0]["NAMES"].ToString() != "")
{
model.NAMES = ds.Tables[0].Rows[0]["NAMES"].ToString();
}
if (ds.Tables[0].Rows[0]["SpecialFundsID"] != null && ds.Tables[0].Rows[0]["SpecialFundsID"].ToString() != "")
{
model.SpecialFundsID = int.Parse(ds.Tables[0].Rows[0]["SpecialFundsID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProjectID"] != null && ds.Tables[0].Rows[0]["ProjectID"].ToString() != "")
{
model.ProjectID = int.Parse(ds.Tables[0].Rows[0]["ProjectID"].ToString());
}
if (ds.Tables[0].Rows[0]["ADDTIME"] != null && ds.Tables[0].Rows[0]["ADDTIME"].ToString() != "")
{
model.ADDTIME = DateTime.Parse(ds.Tables[0].Rows[0]["ADDTIME"].ToString());
}
if (ds.Tables[0].Rows[0]["BudgetAmount"] != null && ds.Tables[0].Rows[0]["BudgetAmount"].ToString() != "")
{
model.BudgetAmount = decimal.Parse(ds.Tables[0].Rows[0]["BudgetAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["BAUNIT"] != null && ds.Tables[0].Rows[0]["BAUNIT"].ToString() != "")
{
model.BAUNIT = ds.Tables[0].Rows[0]["BAUNIT"].ToString();
}
if (ds.Tables[0].Rows[0]["ActualAmount"] != null && ds.Tables[0].Rows[0]["ActualAmount"].ToString() != "")
{
model.ActualAmount = decimal.Parse(ds.Tables[0].Rows[0]["ActualAmount"].ToString());
}
if (ds.Tables[0].Rows[0]["AAUNIT"] != null && ds.Tables[0].Rows[0]["AAUNIT"].ToString() != "")
{
model.AAUNIT = ds.Tables[0].Rows[0]["AAUNIT"].ToString();
}
if (ds.Tables[0].Rows[0]["Applyuser"] != null && ds.Tables[0].Rows[0]["Applyuser"].ToString() != "")
{
model.Applyuser = ds.Tables[0].Rows[0]["Applyuser"].ToString();
}
if (ds.Tables[0].Rows[0]["Status"] != null && ds.Tables[0].Rows[0]["Status"].ToString() != "")
{
model.Status = int.Parse(ds.Tables[0].Rows[0]["Status"].ToString());
}
if (ds.Tables[0].Rows[0]["Delflag"] != null && ds.Tables[0].Rows[0]["Delflag"].ToString() != "")
{
model.Delflag = int.Parse(ds.Tables[0].Rows[0]["Delflag"].ToString());
}
if (ds.Tables[0].Rows[0]["BudgetList"] != null && ds.Tables[0].Rows[0]["BudgetList"].ToString() != "")
{
model.BudgetList = ds.Tables[0].Rows[0]["BudgetList"].ToString();
}
if (ds.Tables[0].Rows[0]["Note"] != null && ds.Tables[0].Rows[0]["Note"].ToString() != "")
{
model.Note = ds.Tables[0].Rows[0]["Note"].ToString();
}
if (ds.Tables[0].Rows[0]["CheckerHistory"] != null && ds.Tables[0].Rows[0]["CheckerHistory"].ToString() != "")
{
model.CheckerHistory = ds.Tables[0].Rows[0]["CheckerHistory"].ToString();
}
if (ds.Tables[0].Rows[0]["Checker"] != null && ds.Tables[0].Rows[0]["Checker"].ToString() != "")
{
model.Checker = ds.Tables[0].Rows[0]["Checker"].ToString();
}
if (ds.Tables[0].Rows[0]["AssignChecker"] != null && ds.Tables[0].Rows[0]["AssignChecker"].ToString() != "")
{
model.AssignChecker = ds.Tables[0].Rows[0]["AssignChecker"].ToString();
}
if (ds.Tables[0].Rows[0]["CarNums"] != null && ds.Tables[0].Rows[0]["CarNums"].ToString() != "")
{
model.CarNums = int.Parse(ds.Tables[0].Rows[0]["CarNums"].ToString());
}
if (ds.Tables[0].Rows[0]["TEMP1"] != null && ds.Tables[0].Rows[0]["TEMP1"].ToString() != "")
{
model.TEMP1 = ds.Tables[0].Rows[0]["TEMP1"].ToString();
}
if (ds.Tables[0].Rows[0]["TEMP2"] != null && ds.Tables[0].Rows[0]["TEMP2"].ToString() != "")
{
model.TEMP2 = ds.Tables[0].Rows[0]["TEMP2"].ToString();
}
if (ds.Tables[0].Rows[0]["TEMP3"] != null && ds.Tables[0].Rows[0]["TEMP3"].ToString() != "")
{
model.TEMP3 = ds.Tables[0].Rows[0]["TEMP3"].ToString();
}
if (ds.Tables[0].Rows[0]["TEMP4"] != null && ds.Tables[0].Rows[0]["TEMP4"].ToString() != "")
{
model.TEMP4 = ds.Tables[0].Rows[0]["TEMP4"].ToString();
}
if (ds.Tables[0].Rows[0]["TEMP5"] != null && ds.Tables[0].Rows[0]["TEMP5"].ToString() != "")
{
model.TEMP5 = ds.Tables[0].Rows[0]["TEMP5"].ToString();
}
if (ds.Tables[0].Rows[0]["CheckTime"] != null && ds.Tables[0].Rows[0]["CheckTime"].ToString() != "")
{
model.ADDTIME = DateTime.Parse(ds.Tables[0].Rows[0]["CheckTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Dianda.Model.Cash_SF_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Cash_SF_Order(");
strSql.Append("NAMES,SpecialFundsID,ProjectID,ADDTIME,BudgetAmount,BAUNIT,ActualAmount,AAUNIT,Applyuser,Status,Delflag,BudgetList,Note,CheckerHistory,Checker,AssignChecker,CarNums,TEMP1,TEMP2,TEMP3,TEMP4,TEMP5,CheckTime)");
strSql.Append(" values (");
strSql.Append("@NAMES,@SpecialFundsID,@ProjectID,@ADDTIME,@BudgetAmount,@BAUNIT,@ActualAmount,@AAUNIT,@Applyuser,@Status,@Delflag,@BudgetList,@Note,@CheckerHistory,@Checker,@AssignChecker,@CarNums,@TEMP1,@TEMP2,@TEMP3,@TEMP4,@TEMP5,@CheckTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@NAMES", SqlDbType.VarChar, 100),
new SqlParameter("@SpecialFundsID", SqlDbType.Int, 4),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@ADDTIME", SqlDbType.DateTime),
new SqlParameter("@BudgetAmount", SqlDbType.Float, 8),
new SqlParameter("@BAUNIT", SqlDbType.VarChar, 10),
new SqlParameter("@ActualAmount", SqlDbType.Float, 8),
new SqlParameter("@AAUNIT", SqlDbType.VarChar, 10),
new SqlParameter("@Applyuser", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Delflag", SqlDbType.Int, 4),
new SqlParameter("@BudgetList", SqlDbType.VarChar, 500),
new SqlParameter("@Note", SqlDbType.Text),
new SqlParameter("@CheckerHistory", SqlDbType.VarChar, 500),
new SqlParameter("@Checker", SqlDbType.VarChar, 500),
new SqlParameter("@AssignChecker", SqlDbType.VarChar, 500),
new SqlParameter("@CarNums", SqlDbType.Int, 4),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP4", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP5", SqlDbType.VarChar, 500),
new SqlParameter("@CheckTime", SqlDbType.DateTime)
};
parameters[0].Value = model.NAMES;
parameters[1].Value = model.SpecialFundsID;
parameters[2].Value = model.ProjectID;
parameters[3].Value = model.ADDTIME;
parameters[4].Value = model.BudgetAmount;
parameters[5].Value = model.BAUNIT;
parameters[6].Value = model.ActualAmount;
parameters[7].Value = model.AAUNIT;
parameters[8].Value = model.Applyuser;
parameters[9].Value = model.Status;
parameters[10].Value = model.Delflag;
parameters[11].Value = model.BudgetList;
parameters[12].Value = model.Note;
parameters[13].Value = model.CheckerHistory;
parameters[14].Value = model.Checker;
parameters[15].Value = model.AssignChecker;
parameters[16].Value = model.CarNums;
parameters[17].Value = model.TEMP1;
parameters[18].Value = model.TEMP2;
parameters[19].Value = model.TEMP3;
parameters[20].Value = model.TEMP4;
parameters[21].Value = model.TEMP5;
parameters[22].Value = model.CheckTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Dianda.Model.Cash_SF_Order model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Cash_SF_Order set ");
strSql.Append("NAMES=@NAMES,");
strSql.Append("SpecialFundsID=@SpecialFundsID,");
strSql.Append("ProjectID=@ProjectID,");
strSql.Append("ADDTIME=@ADDTIME,");
strSql.Append("BudgetAmount=@BudgetAmount,");
strSql.Append("BAUNIT=@BAUNIT,");
strSql.Append("ActualAmount=@ActualAmount,");
strSql.Append("AAUNIT=@AAUNIT,");
strSql.Append("Applyuser=@Applyuser,");
strSql.Append("Status=@Status,");
strSql.Append("Delflag=@Delflag,");
strSql.Append("BudgetList=@BudgetList,");
strSql.Append("Note=@Note,");
strSql.Append("CheckerHistory=@CheckerHistory,");
strSql.Append("Checker=@Checker,");
strSql.Append("AssignChecker=@AssignChecker,");
strSql.Append("CarNums=@CarNums,");
strSql.Append("TEMP1=@TEMP1,");
strSql.Append("TEMP2=@TEMP2,");
strSql.Append("TEMP3=@TEMP3,");
strSql.Append("TEMP4=@TEMP4,");
strSql.Append("TEMP5=@TEMP5,");
strSql.Append("CheckTime=@CheckTime");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@NAMES", SqlDbType.VarChar, 100),
new SqlParameter("@SpecialFundsID", SqlDbType.Int, 4),
new SqlParameter("@ProjectID", SqlDbType.Int, 4),
new SqlParameter("@ADDTIME", SqlDbType.DateTime),
new SqlParameter("@BudgetAmount", SqlDbType.Float, 8),
new SqlParameter("@BAUNIT", SqlDbType.VarChar, 10),
new SqlParameter("@ActualAmount", SqlDbType.Float, 8),
new SqlParameter("@AAUNIT", SqlDbType.VarChar, 10),
new SqlParameter("@Applyuser", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@Delflag", SqlDbType.Int, 4),
new SqlParameter("@BudgetList", SqlDbType.VarChar, 500),
new SqlParameter("@Note", SqlDbType.Text),
new SqlParameter("@CheckerHistory", SqlDbType.VarChar, 500),
new SqlParameter("@Checker", SqlDbType.VarChar, 500),
new SqlParameter("@AssignChecker", SqlDbType.VarChar, 500),
new SqlParameter("@CarNums", SqlDbType.Int, 4),
new SqlParameter("@TEMP1", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP2", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP3", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP4", SqlDbType.VarChar, 500),
new SqlParameter("@TEMP5", SqlDbType.VarChar, 500),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@CheckTime", SqlDbType.DateTime)
};
parameters[0].Value = model.NAMES;
parameters[1].Value = model.SpecialFundsID;
parameters[2].Value = model.ProjectID;
parameters[3].Value = model.ADDTIME;
parameters[4].Value = model.BudgetAmount;
parameters[5].Value = model.BAUNIT;
parameters[6].Value = model.ActualAmount;
parameters[7].Value = model.AAUNIT;
parameters[8].Value = model.Applyuser;
parameters[9].Value = model.Status;
parameters[10].Value = model.Delflag;
parameters[11].Value = model.BudgetList;
parameters[12].Value = model.Note;
parameters[13].Value = model.CheckerHistory;
parameters[14].Value = model.Checker;
parameters[15].Value = model.AssignChecker;
parameters[16].Value = model.CarNums;
parameters[17].Value = model.TEMP1;
parameters[18].Value = model.TEMP2;
parameters[19].Value = model.TEMP3;
parameters[20].Value = model.TEMP4;
parameters[21].Value = model.TEMP5;
parameters[22].Value = model.ID;
parameters[23].Value = model.CheckTime;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
