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