/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.MGetHelp model, Hashtable MyHs) { model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); //校验编号是否重复,重复的话重新生成 while (CommonBase.GetSingle("select SQCode from MGetHelp where SQCode='" + model.SQCode + "'") != null) { model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); } string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MGetHelp("); strSql.Append("SQMID,SQMoney,SQCode,SQDate,PPState,ConfirmState,MFLMoney,Remark,MatchMoney,HelpType,MoneyType,ComfirmDate"); strSql.Append(") values ("); strSql.Append("@SQMID,@SQMoney,@SQCode,@SQDate,@PPState,@ConfirmState,@MFLMoney,@Remark,@MatchMoney,@HelpType,@MoneyType,@ComfirmDate"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@SQMID", SqlDbType.VarChar, 50), new SqlParameter("@SQMoney", SqlDbType.Decimal, 9), new SqlParameter("@SQCode", SqlDbType.VarChar, 50), new SqlParameter("@SQDate", SqlDbType.DateTime), new SqlParameter("@PPState", SqlDbType.Int, 4), new SqlParameter("@ConfirmState", SqlDbType.Int, 4), new SqlParameter("@MFLMoney", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@MatchMoney", SqlDbType.Decimal, 9), new SqlParameter("@HelpType", SqlDbType.Int, 4), new SqlParameter("@MoneyType", SqlDbType.VarChar, 50), new SqlParameter("@ComfirmDate", SqlDbType.DateTime) }; parameters[0].Value = model.SQMID; parameters[1].Value = model.SQMoney; parameters[2].Value = model.SQCode; parameters[3].Value = model.SQDate; parameters[4].Value = model.PPState; parameters[5].Value = model.ConfirmState; parameters[6].Value = model.MFLMoney; parameters[7].Value = model.Remark; parameters[8].Value = model.MatchMoney; parameters[9].Value = model.HelpType; parameters[10].Value = model.MoneyType; parameters[11].Value = model.ComfirmDate; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }
/// <summary> /// 增加一条数据 /// </summary> public static Hashtable Insert(Model.MOfferHelp model, Hashtable MyHs) { ////计算利息 //var dic = DAL.ConfigDictionary.GetConfigDictionary((int)model.SQMoney, "LiXi", ""); //if (dic != null) //{ // model.DayInterest = Convert.ToDecimal(dic.DValue); //} model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); //校验编号是否重复,重复的话重新生成 while (CommonBase.GetSingle("select SQCode from MOfferHelp where SQCode='" + model.SQCode + "'") != null) { model.SQCode = Guid.NewGuid().ToString().Replace("-", "").Replace(" ", "").ToUpper().Substring(0, 15); } string guid = Guid.NewGuid().ToString(); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into MOfferHelp("); strSql.Append("TotalInterest,TotalInterestDays,TotalSincerity,TotalSincerityDays,SincerityState,InterestState,SQCode,SQMID,SQMoney,SQDate,PPState,DKState,MFLMoney,Remark,MatchMoney,dayInterest,HelpType,MoneyType"); strSql.Append(") values ("); strSql.Append("@TotalInterest,@TotalInterestDays,@TotalSincerity,@TotalSincerityDays,@SincerityState,@InterestState,@SQCode,@SQMID,@SQMoney,@SQDate,@PPState,@DKState,@MFLMoney,@Remark,@MatchMoney,@dayInterest,@HelpType,@MoneyType"); strSql.Append(") "); strSql.AppendFormat(";select '{0}'", guid); SqlParameter[] parameters = { new SqlParameter("@TotalInterest", SqlDbType.Decimal, 9), new SqlParameter("@TotalInterestDays", SqlDbType.Int, 4), new SqlParameter("@TotalSincerity", SqlDbType.Decimal, 9), new SqlParameter("@TotalSincerityDays", SqlDbType.Int, 4), new SqlParameter("@SincerityState", SqlDbType.Int, 4), new SqlParameter("@InterestState", SqlDbType.Int, 4), new SqlParameter("@SQCode", SqlDbType.VarChar, 50), new SqlParameter("@SQMID", SqlDbType.VarChar, 50), new SqlParameter("@SQMoney", SqlDbType.Decimal, 9), new SqlParameter("@SQDate", SqlDbType.DateTime), new SqlParameter("@PPState", SqlDbType.Int, 4), new SqlParameter("@DKState", SqlDbType.Int, 4), new SqlParameter("@MFLMoney", SqlDbType.Decimal, 9), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@MatchMoney", SqlDbType.Decimal, 9), new SqlParameter("@dayInterest", SqlDbType.Decimal, 9), new SqlParameter("@HelpType", SqlDbType.Int, 4), new SqlParameter("@MoneyType", SqlDbType.VarChar, 50) }; parameters[0].Value = model.TotalInterest; parameters[1].Value = model.TotalInterestDays; parameters[2].Value = model.TotalSincerity; parameters[3].Value = model.TotalSincerityDays; parameters[4].Value = model.SincerityState; parameters[5].Value = model.InterestState; parameters[6].Value = model.SQCode; parameters[7].Value = model.SQMID; parameters[8].Value = model.SQMoney; parameters[9].Value = model.SQDate; parameters[10].Value = model.PPState; parameters[11].Value = model.DKState; parameters[12].Value = model.MFLMoney; parameters[13].Value = model.Remark; parameters[14].Value = model.MatchMoney; parameters[15].Value = model.DayInterest; parameters[16].Value = model.HelpType; parameters[17].Value = model.MoneyType; MyHs.Add(strSql.ToString(), parameters); return(MyHs); }