/// <summary>
/// 更新申请提现为已审核哈希表
/// </summary>
/// <param name="CID"></param>
/// <returns></returns>
public static Hashtable UpdataTran(Model.ChangeMoney changemoney, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ChangeMoney set ");
strSql.Append("CState=@CState,");
strSql.Append("CRemarks=@CRemarks,");
strSql.Append("ChangeDate=@ChangeDate,");
strSql.Append("ToMID=@ToMID");
strSql.Append(" where CID=@CID ");
SqlParameter[] parameters =
{
new SqlParameter("@CState", SqlDbType.Bit, 1),
new SqlParameter("@CID", SqlDbType.Int, 4),
new SqlParameter("@ToMID", SqlDbType.VarChar, 20),
new SqlParameter("@CRemarks", SqlDbType.VarChar, 200),
new SqlParameter("@ChangeDate", SqlDbType.DateTime, 8)
};
parameters[0].Value = changemoney.CState;
parameters[1].Value = changemoney.CID;
parameters[2].Value = changemoney.ToMID;
parameters[3].Value = changemoney.CRemarks;
parameters[4].Value = DateTime.Now;
MyHs.Add(strSql, parameters);
return(MyHs);
}
protected override void SetValue()
{
Model.ChangeMoney change2 = BLL.ChangeMoney.GetTopModel("DL", true, TModel.MID);
if (change2 != null)
{
UpDFHMoney = change2.ChangeDate.ToString("yyyy-MM-dd HH:mm:ss");
}
//DayFHMoney = TModel.MAgencyType.DLMoney;
}
protected override void SetValue()
{
//Model.ChangeMoney change = BLL.ChangeMoney.GetTopModel("KT", true, BllModel.TModel.MID);
//if (change != null)
// UpKTMoney = change.ChangeDate.ToString("yyyy-MM-dd HH:mm:ss");
Model.ChangeMoney change2 = BLL.ChangeMoney.GetTopModel("DFH", true, BllModel.TModel.MID);
if (change2 != null)
{
UpDFHMoney = change2.ChangeDate.ToString("yyyy-MM-dd HH:mm:ss");
}
//DayFHMoney = TModel.MAgencyType.Money * TModel.MAgencyType.DayFHFloat;
//DayKTMoney = ((int)(BllModel.TModel.MConfig.TJMoney / BLL.Configuration.Model.KTBaseMoney)) * BLL.Configuration.Model.DayKTMoney;
//DayFLMoney = BllModel.GetMemberAndConfigEntityList("FMID='" + BllModel.TModel.MID + "'").Where(emp => emp.MConfig.JTFHState).Count() * BLL.Configuration.Model.DayFLMoney;
}
/// <summary>
/// 插入实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static Hashtable InsertTran(Model.ChangeMoney model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ChangeMoney(");
strSql.Append("FromMID,ToMID,Money,ChangeDate,ChangeType,MoneyType,CState,SHMID,TakeOffMoney,ReBuyMoney,MCWMoney,CRemarks,extra1,source,source1,source2)");
strSql.Append(" values (");
strSql.Append("@FromMID,@ToMID,@Money,@ChangeDate,@ChangeType,@MoneyType,@CState,@SHMID,@TakeOffMoney,@ReBuyMoney,@MCWMoney,@CRemarks,@extra1,@source,@source1,@source2)");
SqlParameter[] parameters =
{
new SqlParameter("@FromMID", SqlDbType.VarChar, 20),
new SqlParameter("@ToMID", SqlDbType.VarChar, 20),
new SqlParameter("@Money", SqlDbType.Decimal),
new SqlParameter("@ChangeDate", SqlDbType.DateTime),
new SqlParameter("@ChangeType", SqlDbType.VarChar, 10),
new SqlParameter("@MoneyType", SqlDbType.VarChar, 10),
new SqlParameter("@SHMID", SqlDbType.VarChar, 20),
new SqlParameter("@CState", SqlDbType.Bit, 1),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal),
new SqlParameter("@MCWMoney", SqlDbType.Decimal),
new SqlParameter("@CRemarks", SqlDbType.VarChar, 200),
new SqlParameter("@extra1", SqlDbType.Decimal),
new SqlParameter("@source", SqlDbType.VarChar, 200),
new SqlParameter("@source1", SqlDbType.VarChar, 200),
new SqlParameter("@source2", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.FromMID;
parameters[1].Value = model.ToMID;
parameters[2].Value = model.Money;
parameters[3].Value = model.ChangeDate;
parameters[4].Value = model.ChangeType;
parameters[5].Value = model.MoneyType;
parameters[6].Value = model.SHMID;
parameters[7].Value = model.CState;
parameters[8].Value = model.TakeOffMoney;
parameters[9].Value = model.ReBuyMoney;
parameters[10].Value = model.MCWMoney;
parameters[11].Value = model.CRemarks;
parameters[12].Value = model.extra1;
parameters[13].Value = model.source;
parameters[14].Value = model.source1;
parameters[15].Value = model.source2;
MyHs.Add(strSql, parameters);
return(MyHs);
}
/// <summary>
/// 插入实体
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static Hashtable InsertTran(Model.ChangeMoney model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ChangeMoney(");
strSql.Append("FromMID,ToMID,Money,ChangeDate,ChangeType,MoneyType,CState,SHMID,TakeOffMoney,ReBuyMoney,MCWMoney,CRemarks,CFileds,CFileds2,CompleteTime,OrderState)");
strSql.Append(" values (");
strSql.Append("@FromMID,@ToMID,@Money,@ChangeDate,@ChangeType,@MoneyType,@CState,@SHMID,@TakeOffMoney,@ReBuyMoney,@MCWMoney,@CRemarks,@CFileds,@CFileds2,@CompleteTime,@OrderState)");
SqlParameter[] parameters =
{
new SqlParameter("@FromMID", SqlDbType.VarChar, 20),
new SqlParameter("@ToMID", SqlDbType.VarChar, 20),
new SqlParameter("@Money", SqlDbType.Decimal, 9),
new SqlParameter("@ChangeDate", SqlDbType.DateTime),
new SqlParameter("@ChangeType", SqlDbType.VarChar, 20),
new SqlParameter("@MoneyType", SqlDbType.VarChar, 20),
new SqlParameter("@SHMID", SqlDbType.VarChar, 20),
new SqlParameter("@CState", SqlDbType.Bit, 1),
new SqlParameter("@TakeOffMoney", SqlDbType.Decimal, 9),
new SqlParameter("@ReBuyMoney", SqlDbType.Decimal, 9),
new SqlParameter("@MCWMoney", SqlDbType.Decimal, 9),
new SqlParameter("@CRemarks", SqlDbType.VarChar, 200),
new SqlParameter("@CFileds", SqlDbType.VarChar, 50),
new SqlParameter("@CFileds2", SqlDbType.VarChar, 50),
new SqlParameter("@CompleteTime", SqlDbType.DateTime),
new SqlParameter("@OrderState", SqlDbType.Int, 4)
};
parameters[0].Value = model.FromMID;
parameters[1].Value = model.ToMID;
parameters[2].Value = model.Money;
parameters[3].Value = model.ChangeDate;
parameters[4].Value = model.ChangeType;
parameters[5].Value = model.MoneyType;
parameters[6].Value = model.SHMID;
parameters[7].Value = model.CState;
parameters[8].Value = model.TakeOffMoney;
parameters[9].Value = model.ReBuyMoney;
parameters[10].Value = model.MCWMoney;
parameters[11].Value = model.CRemarks;
parameters[12].Value = model.CFileds;
parameters[13].Value = model.CFileds2;
parameters[14].Value = model.CompleteTime;
parameters[15].Value = model.OrderState;
MyHs.Add(strSql, parameters);
return(MyHs);
}
