public bool update2(Model.Money money)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Money set ");
strSql.Append("Reason=@Reason,");
strSql.Append("ANumber1=@ANumber1,");
strSql.Append("ANumber2=@ANumber2,");
strSql.Append("Status=@Status");
strSql.Append(" where ");
strSql.Append("ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@Reason", SqlDbType.VarChar, 50),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@ANumber1", SqlDbType.Int),
new SqlParameter("@ANumber2", SqlDbType.Int),
new SqlParameter("@ID", SqlDbType.Int)
};
parameters[0].Value = money.Reason;
parameters[1].Value = money.Status;
parameters[2].Value = money.ANumber1;
parameters[3].Value = money.ANumber2;
parameters[4].Value = money.Id;
int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">申请者信息</param>
/// <returns>是否添加成功</returns>
public bool Add(Model.Money model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Money(");
strSql.Append("UID,MID,Status,ANumber1,ANumber2,Reason)");
strSql.Append(" values (");
strSql.Append("@UID,@MID,@Status,@ANumber1,@ANumber2,@Reason)");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.Int),
new SqlParameter("@MID", SqlDbType.Int),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@ANumber1", SqlDbType.Int),
new SqlParameter("@ANumber2", SqlDbType.Int),
new SqlParameter("@Reason", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.UID;
parameters[1].Value = model.MID;
parameters[2].Value = model.Status;
parameters[3].Value = model.ANumber1;
parameters[4].Value = model.ANumber2;
parameters[5].Value = model.Reason;
int rows = DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool updateReasonSHE(String reason, int selectID, int adminID, int status)
{
Model.Money money = new Model.Money();
money.Reason = reason;
money.Id = selectID;
money.Status = status;
money.ANumber1 = adminID;
return(d_money.update2(money));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int uid = (int)Session["UID"];
BLL.B_Money b_money = new BLL.B_Money();
Model.Money model = b_money.GetMoney(uid); //获取审核信息
if (model != null) //如果存在审核信息
{
switch (model.Status)
{
case 0: //一级审核失败
lb_Status.Text = "数据不全，一级审核失败，请填写完善资料";
break;
case 1: //一级审核成功等待二级审核
lb_Status.Text = "一级审核成功，正在等待二级审核";
break;
case 2: //二级审核失败
lb_Status.Text = "二级审核失败...";
lb_Reason.Text = model.Reason;
lb_ANumber1.Text = model.ANumber1.ToString();
lb_Reason0.Visible = true;
break;
case 3: //二级审核成功等待三级审核
lb_Status.Text = "二级审核成功，正在等待三级审核";
lb_ANumber1.Text = model.ANumber1.ToString();
break;
case 4: //三级审核失败
lb_Status.Text = "三级审核失败...";
lb_ANumber1.Text = model.ANumber1.ToString();
lb_ANumber2.Text = model.ANumber2.ToString();
lb_Reason.Text = model.Reason;
lb_Reason0.Visible = true;
break;
case 5: //审核成功
lb_Status.Text = "恭喜你，审核通过！";
lb_ANumber1.Text = model.ANumber1.ToString();
lb_ANumber2.Text = model.ANumber2.ToString();
break;
default:
break;
}
}
else
{
webclass.Show(this, "您还未申请老年津贴，快去申请吧！");
}
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
public Model.Money GetModel(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Money ");
strSql.Append(" where ");
strSql.Append(strWhere);
Model.Money model = new Model.Money();
DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), DB.DbHelperSQL.maindataConnectionString);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 判断是否可以申请
/// </summary>
/// <param name="UID"></param>
/// <param name="UTypes"></param>
/// <param name="tishi"></param>
/// <returns></returns>
public bool CanApply(int UID, int UTypes, out string tishi)
{
Model.ApplyInfo model = new Model.ApplyInfo();
if (!d_apply.Exists("UID=" + UID + " and Types=" + UTypes))//如果不存在该用户的申请信息
{
tishi = "apply";
return(true);
}
else//存在该用户申请信息
{
//判断申请状态
model = d_apply.GetModel("UID=" + UID + " and Types=" + UTypes);
if (UTypes == 0)//优待卡
{
DAL.D_Card d_card = new DAL.D_Card();
Model.Card card = d_card.GetModel("UID=" + UID);
if (card != null)
{
return(CanReapply(card.Status, out tishi));
}
else
{
tishi = "判断是否可以重新申请时出错";
return(false);
}
}
else if (UTypes == 1)//老年津贴
{
DAL.D_Money d_money = new DAL.D_Money();
Model.Money money = d_money.GetModel("UID=" + UID);
return(CanReapply(money.Status, out tishi));
}
else
{
tishi = "错误";
return(false);
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Money DataRowToModel(DataRow row)
{
//@ID,@UID,@MID,@Status,@ANumber1,@ANumber2,@Reason
Model.Money model = new Model.Money();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.Id = (int)row["ID"];
}
if (row["UID"] != null && row["UID"].ToString() != "")
{
model.UID = (int)row["UID"];
}
if (row["MID"] != null && row["MID"].ToString() != "")
{
model.MID = (int)row["MID"];
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = (int)row["Status"];
}
if (row["ANumber1"] != null && row["ANumber1"].ToString() != "")
{
model.ANumber1 = (int)row["ANumber1"];
}
if (row["ANumber2"] != null && row["ANumber2"].ToString() != "")
{
model.ANumber2 = (int)row["ANumber2"];
}
if (row["Reason"] != null && row["Reason"].ToString() != "")
{
model.Reason = row["Reason"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Money GetModels(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,TotalMoney,NoTaxlMoney,ProjectId,projectcost,CostQuotation,SalesQuotation,Actualamountofpayment,Financialcost,Totaltaxcost,SalesQuotations,TaxSum,NonTaxCostCombined,Totaltaxcosttow,Grossprofit,Unpaidchannel,Employeebonus,Undistributedprofit,Percentageofprofit,AMargemBrutapercentual,Olucrolíquido,Aporcentagemdelucrolíquido from Money ");
strSql.Append(" where ProjectId=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Model.Money model = new Model.Money();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="id">申请人ID</param>
/// <returns>老年津贴审核信息</returns>
public Model.Money GetModel(int uid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Money ");
strSql.Append(" where UID=@UID ");
SqlParameter[] parameters =
{
new SqlParameter("@UID", SqlDbType.Int)
};
parameters[0].Value = uid;
Model.Money model = new Model.Money();
DataSet ds = DB.DbHelperSQL.Query(strSql.ToString(), parameters, DB.DbHelperSQL.maindataConnectionString);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Money model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Money(");
strSql.Append("TotalMoney,NoTaxlMoney,ProjectId,projectcost,CostQuotation,SalesQuotation,Actualamountofpayment,Financialcost,Totaltaxcost,SalesQuotations,TaxSum,NonTaxCostCombined,Totaltaxcosttow,Grossprofit,Unpaidchannel,Employeebonus,Undistributedprofit,Percentageofprofit,AMargemBrutapercentual,Olucrolíquido,Aporcentagemdelucrolíquido)");
strSql.Append(" values (");
strSql.Append("@TotalMoney,@NoTaxlMoney,@ProjectId,@projectcost,@CostQuotation,@SalesQuotation,@Actualamountofpayment,@Financialcost,@Totaltaxcost,@SalesQuotations,@TaxSum,@NonTaxCostCombined,@Totaltaxcosttow,@Grossprofit,@Unpaidchannel,@Employeebonus,@Undistributedprofit,@Percentageofprofit,@AMargemBrutapercentual,@Olucrolíquido,@Aporcentagemdelucrolíquido)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@NoTaxlMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ProjectId", SqlDbType.Int, 4),
new SqlParameter("@projectcost", SqlDbType.Decimal, 9),
new SqlParameter("@CostQuotation", SqlDbType.Decimal, 9),
new SqlParameter("@SalesQuotation", SqlDbType.Decimal, 9),
new SqlParameter("@Actualamountofpayment", SqlDbType.Decimal, 9),
new SqlParameter("@Financialcost", SqlDbType.Decimal, 9),
new SqlParameter("@Totaltaxcost", SqlDbType.Decimal, 9),
new SqlParameter("@SalesQuotations", SqlDbType.Decimal, 9),
new SqlParameter("@TaxSum", SqlDbType.Decimal, 9),
new SqlParameter("@NonTaxCostCombined", SqlDbType.Decimal, 9),
new SqlParameter("@Totaltaxcosttow", SqlDbType.Decimal, 9),
new SqlParameter("@Grossprofit", SqlDbType.Decimal, 9),
new SqlParameter("@Unpaidchannel", SqlDbType.Decimal, 9),
new SqlParameter("@Employeebonus", SqlDbType.Decimal, 9),
new SqlParameter("@Undistributedprofit", SqlDbType.Decimal, 9),
new SqlParameter("@Percentageofprofit", SqlDbType.NVarChar, 200),
new SqlParameter("@AMargemBrutapercentual", SqlDbType.NVarChar, 200),
new SqlParameter("@Olucrolíquido", SqlDbType.Decimal, 9),
new SqlParameter("@Aporcentagemdelucrolíquido", SqlDbType.NVarChar, 200),
};
parameters[0].Value = model.TotalMoney;
parameters[1].Value = model.NoTaxlMoney;
parameters[2].Value = model.ProjectId;
parameters[3].Value = model.projectcost;
parameters[4].Value = model.CostQuotation;
parameters[5].Value = model.SalesQuotation;
parameters[6].Value = model.Actualamountofpayment;
parameters[7].Value = model.Financialcost;
parameters[8].Value = model.Totaltaxcost;
parameters[9].Value = model.SalesQuotations;
parameters[10].Value = model.TaxSum;
parameters[11].Value = model.NonTaxCostCombined;
parameters[12].Value = model.Totaltaxcosttow;
parameters[13].Value = model.Grossprofit;
parameters[14].Value = model.Unpaidchannel;
parameters[15].Value = model.Employeebonus;
parameters[16].Value = model.Undistributedprofit;
parameters[17].Value = model.Percentageofprofit;
parameters[18].Value = model.AMargemBrutapercentual;
parameters[19].Value = model.Olucrolíquido;
parameters[20].Value = model.Aporcentagemdelucrolíquido;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Money DataRowToModel(DataRow row)
{
Model.Money model = new Model.Money();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["TotalMoney"] != null && row["TotalMoney"].ToString() != "")
{
model.TotalMoney = decimal.Parse(row["TotalMoney"].ToString());
}
if (row["NoTaxlMoney"] != null && row["NoTaxlMoney"].ToString() != "")
{
model.NoTaxlMoney = decimal.Parse(row["NoTaxlMoney"].ToString());
}
if (row["ProjectId"] != null && row["ProjectId"].ToString() != "")
{
model.ProjectId = int.Parse(row["ProjectId"].ToString());
}
if (row["projectcost"] != null && row["projectcost"].ToString() != "")
{
model.projectcost = decimal.Parse(row["projectcost"].ToString());
}
if (row["CostQuotation"] != null && row["CostQuotation"].ToString() != "")
{
model.CostQuotation = decimal.Parse(row["CostQuotation"].ToString());
}
if (row["SalesQuotation"] != null && row["SalesQuotation"].ToString() != "")
{
model.SalesQuotation = decimal.Parse(row["SalesQuotation"].ToString());
}
if (row["Actualamountofpayment"] != null && row["Actualamountofpayment"].ToString() != "")
{
model.Actualamountofpayment = decimal.Parse(row["Actualamountofpayment"].ToString());
}
if (row["Financialcost"] != null && row["Financialcost"].ToString() != "")
{
model.Financialcost = decimal.Parse(row["Financialcost"].ToString());
}
if (row["Totaltaxcost"] != null && row["Totaltaxcost"].ToString() != "")
{
model.Totaltaxcost = decimal.Parse(row["Totaltaxcost"].ToString());
}
if (row["SalesQuotations"] != null && row["SalesQuotations"].ToString() != "")
{
model.SalesQuotations = decimal.Parse(row["SalesQuotations"].ToString());
}
if (row["TaxSum"] != null && row["TaxSum"].ToString() != "")
{
model.TaxSum = decimal.Parse(row["TaxSum"].ToString());
}
if (row["NonTaxCostCombined"] != null && row["NonTaxCostCombined"].ToString() != "")
{
model.NonTaxCostCombined = decimal.Parse(row["NonTaxCostCombined"].ToString());
}
if (row["Totaltaxcosttow"] != null && row["Totaltaxcosttow"].ToString() != "")
{
model.Totaltaxcosttow = decimal.Parse(row["Totaltaxcosttow"].ToString());
}
if (row["Grossprofit"] != null && row["Grossprofit"].ToString() != "")
{
model.Grossprofit = decimal.Parse(row["Grossprofit"].ToString());
}
if (row["Unpaidchannel"] != null && row["Unpaidchannel"].ToString() != "")
{
model.Unpaidchannel = decimal.Parse(row["Unpaidchannel"].ToString());
}
if (row["Employeebonus"] != null && row["Employeebonus"].ToString() != "")
{
model.Employeebonus = decimal.Parse(row["Employeebonus"].ToString());
}
if (row["Undistributedprofit"] != null && row["Undistributedprofit"].ToString() != "")
{
model.Undistributedprofit = decimal.Parse(row["Undistributedprofit"].ToString());
}
if (row["Percentageofprofit"] != null)
{
model.Percentageofprofit = row["Percentageofprofit"].ToString();
}
if (row["AMargemBrutapercentual"] != null)
{
model.AMargemBrutapercentual = row["AMargemBrutapercentual"].ToString();
}
if (row["Olucrolíquido"] != null && row["Olucrolíquido"].ToString() != "")
{
model.Olucrolíquido = decimal.Parse(row["Olucrolíquido"].ToString());
}
if (row["Aporcentagemdelucrolíquido"] != null)
{
model.Aporcentagemdelucrolíquido = row["Aporcentagemdelucrolíquido"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Money model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Money set ");
strSql.Append("TotalMoney=@TotalMoney,");
strSql.Append("NoTaxlMoney=@NoTaxlMoney,");
strSql.Append("ProjectId=@ProjectId,");
strSql.Append("projectcost=@projectcost,");
strSql.Append("CostQuotation=@CostQuotation,");
strSql.Append("SalesQuotation=@SalesQuotation,");
strSql.Append("Actualamountofpayment=@Actualamountofpayment,");
strSql.Append("Financialcost=@Financialcost,");
strSql.Append("Totaltaxcost=@Totaltaxcost,");
strSql.Append("SalesQuotations=@SalesQuotations,");
strSql.Append("TaxSum=@TaxSum,");
strSql.Append("NonTaxCostCombined=@NonTaxCostCombined,");
strSql.Append("Totaltaxcosttow=@Totaltaxcosttow,");
strSql.Append("Grossprofit=@Grossprofit,");
strSql.Append("Unpaidchannel=@Unpaidchannel,");
strSql.Append("Employeebonus=@Employeebonus,");
strSql.Append("Undistributedprofit=@Undistributedprofit,");
strSql.Append("Percentageofprofit=@Percentageofprofit,");
strSql.Append("AMargemBrutapercentual=@AMargemBrutapercentual,");
strSql.Append("Olucrolíquido=@Olucrolíquido,");
strSql.Append("Aporcentagemdelucrolíquido=@Aporcentagemdelucrolíquido");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@TotalMoney", SqlDbType.Decimal, 9),
new SqlParameter("@NoTaxlMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ProjectId", SqlDbType.Int, 4),
new SqlParameter("@projectcost", SqlDbType.Decimal, 9),
new SqlParameter("@CostQuotation", SqlDbType.Decimal, 9),
new SqlParameter("@SalesQuotation", SqlDbType.Decimal, 9),
new SqlParameter("@Actualamountofpayment", SqlDbType.Decimal, 9),
new SqlParameter("@Financialcost", SqlDbType.Decimal, 9),
new SqlParameter("@Totaltaxcost", SqlDbType.Decimal, 9),
new SqlParameter("@SalesQuotations", SqlDbType.Decimal, 9),
new SqlParameter("@TaxSum", SqlDbType.Decimal, 9),
new SqlParameter("@NonTaxCostCombined", SqlDbType.Decimal, 9),
new SqlParameter("@Totaltaxcosttow", SqlDbType.Decimal, 9),
new SqlParameter("@Grossprofit", SqlDbType.Decimal, 9),
new SqlParameter("@Unpaidchannel", SqlDbType.Decimal, 9),
new SqlParameter("@Employeebonus", SqlDbType.Decimal, 9),
new SqlParameter("@Undistributedprofit", SqlDbType.Decimal, 9),
new SqlParameter("@Percentageofprofit", SqlDbType.NVarChar, 200),
new SqlParameter("@AMargemBrutapercentual", SqlDbType.NVarChar, 200),
new SqlParameter("@Olucrolíquido", SqlDbType.Decimal, 9),
new SqlParameter("@Aporcentagemdelucrolíquido", SqlDbType.NVarChar, 200),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.TotalMoney;
parameters[1].Value = model.NoTaxlMoney;
parameters[2].Value = model.ProjectId;
parameters[3].Value = model.projectcost;
parameters[4].Value = model.CostQuotation;
parameters[5].Value = model.SalesQuotation;
parameters[6].Value = model.Actualamountofpayment;
parameters[7].Value = model.Financialcost;
parameters[8].Value = model.Totaltaxcost;
parameters[9].Value = model.SalesQuotations;
parameters[10].Value = model.TaxSum;
parameters[11].Value = model.NonTaxCostCombined;
parameters[12].Value = model.Totaltaxcosttow;
parameters[13].Value = model.Grossprofit;
parameters[14].Value = model.Unpaidchannel;
parameters[15].Value = model.Employeebonus;
parameters[16].Value = model.Undistributedprofit;
parameters[17].Value = model.Percentageofprofit;
parameters[18].Value = model.AMargemBrutapercentual;
parameters[19].Value = model.Olucrolíquido;
parameters[20].Value = model.Aporcentagemdelucrolíquido;
parameters[21].Value = model.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Money model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Money model)
{
return(dal.Add(model));
}
