public static Hashtable Add(Model.MConfigChange model, Hashtable MyHs) { return(MyHs); StringBuilder sqlstr = new StringBuilder("insert into MConfigChange(MID,SHMID,ChangeDate,ConfigName,ConfigValue,DataType,IsValue) values (@MID,@SHMID,@ChangeDate,@ConfigName,@ConfigValue,@DataType,@IsValue);"); sqlstr.Append("select '" + Guid.NewGuid().ToString() + "'"); SqlParameter[] para = new SqlParameter[] { new SqlParameter("@MID", SqlDbType.VarChar, 20), new SqlParameter("@SHMID", SqlDbType.VarChar, 20), new SqlParameter("@ChangeDate", SqlDbType.DateTime), new SqlParameter("@ConfigName", SqlDbType.VarChar, 20), new SqlParameter("@ConfigValue", SqlDbType.VarChar, 20), new SqlParameter("@DataType", SqlDbType.VarChar, 20), new SqlParameter("@IsValue", SqlDbType.Bit, 1) }; para[0].Value = model.MID; para[1].Value = model.SHMID; para[2].Value = model.ChangeDate; para[3].Value = model.ConfigName; para[4].Value = model.ConfigValue; para[5].Value = model.DataType; para[6].Value = model.IsValue; MyHs.Add(sqlstr.ToString(), para); return(MyHs); }
/// <summary> /// 更新员工参数值 /// </summary> /// <param name="mid">员工账号</param> /// <param name="ConfigValue">参数值</param> /// <param name="ConfigName">参数名称</param> /// <param name="MyHs"></param> /// <returns></returns> public static Hashtable UpdateConfigTran(string mid, string fieldName, string fieldValue, Model.BMember shmodel, bool isEqual, SqlDbType dataType, Hashtable MyHs) { StringBuilder strSql = new StringBuilder(); string guid = Guid.NewGuid().ToString(); strSql.Append("update BMember set "); if (isEqual) { if (dataType == SqlDbType.Int || dataType == SqlDbType.Decimal) { strSql.Append(string.Format("{0} = {1} ", fieldName, fieldValue)); } else { strSql.Append(string.Format("{0} = '{1}' ", fieldName, fieldValue)); } } else { if (dataType == SqlDbType.Int || dataType == SqlDbType.Decimal) { strSql.Append(string.Format("{0} = {0} + {1} ", fieldName, fieldValue)); } else { strSql.Append(string.Format("{0} = '{0}' + '{1}' ", fieldName, fieldValue)); } } strSql.Append(string.Format(" where BMID='{0}' and '{1}'='{1}'", mid, guid)); MyHs.Add(strSql, null); if (shmodel != null) { if (isEqual) { object obj = DbHelperSQL.GetSingle(string.Format("select {0} from BMember where BMID='{1}'", fieldName, mid)); if (obj != null) { fieldValue = obj.ToString(); } } Model.MConfigChange mchange = new Model.MConfigChange { ChangeDate = DateTime.Now, ConfigName = fieldName, ConfigValue = fieldValue.ToString(), DataType = dataType, IsValue = isEqual, MID = mid, SHMID = shmodel.BMID }; DAL.MConfigChange.Add(mchange, MyHs); } return(MyHs); }