/// <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); }