/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Hi.Model.SYS_UserMessage GetModel(DataRow r)
{
Hi.Model.SYS_UserMessage model = new Hi.Model.SYS_UserMessage();
model.ID = SqlHelper.GetInt(r["ID"]);
model.UserName = SqlHelper.GetString(r["UserName"]);
model.UserPhone = SqlHelper.GetString(r["UserPhone"]);
model.UserMailQQ = SqlHelper.GetString(r["UserMailQQ"]);
model.UserMessge = SqlHelper.GetString(r["UserMessge"]);
model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]);
model.ModifyDate = SqlHelper.GetDateTime(r["ModifyDate"]);
model.ModifyUser = SqlHelper.GetInt(r["ModifyUser"]);
model.State = SqlHelper.GetInt(r["State"]);
model.Remark = SqlHelper.GetString(r["Remark"]);
model.dr = SqlHelper.GetInt(r["dr"]);
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hi.Model.SYS_UserMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [SYS_UserMessage](");
strSql.Append("[UserName],[UserPhone],[UserMailQQ],[UserMessge],[CreateDate],[ModifyDate],[ModifyUser],[State],[Remark])");
strSql.Append(" values (");
strSql.Append("@UserName,@UserPhone,@UserMailQQ,@UserMessge,@CreateDate,@ModifyDate,@ModifyUser,@State,@Remark)");
strSql.Append(";select @@Identity");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@UserMailQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@UserMessge", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifyDate", SqlDbType.DateTime),
new SqlParameter("@ModifyUser", SqlDbType.Int),
new SqlParameter("@State", SqlDbType.Int),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500)
};
if (model.UserName != null)
{
parameters[0].Value = model.UserName;
}
else
{
parameters[0].Value = DBNull.Value;
}
parameters[1].Value = model.UserPhone;
if (model.UserMailQQ != null)
{
parameters[2].Value = model.UserMailQQ;
}
else
{
parameters[2].Value = DBNull.Value;
}
if (model.UserMessge != null)
{
parameters[3].Value = model.UserMessge;
}
else
{
parameters[3].Value = DBNull.Value;
}
parameters[4].Value = model.CreateDate;
if (model.ModifyDate != DateTime.MinValue)
{
parameters[5].Value = model.ModifyDate;
}
else
{
parameters[5].Value = DBNull.Value;
}
parameters[6].Value = model.ModifyUser;
parameters[7].Value = model.State;
if (model.Remark != null)
{
parameters[8].Value = model.Remark;
}
else
{
parameters[8].Value = DBNull.Value;
}
return(SqlHelper.GetInt(SqlHelper.GetSingle(SqlHelper.LocalSqlServer, strSql.ToString(), parameters)));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Hi.Model.SYS_UserMessage model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [SYS_UserMessage] set ");
strSql.Append("[UserName]=@UserName,");
strSql.Append("[UserPhone]=@UserPhone,");
strSql.Append("[UserMailQQ]=@UserMailQQ,");
strSql.Append("[UserMessge]=@UserMessge,");
strSql.Append("[CreateDate]=@CreateDate,");
strSql.Append("[ModifyDate]=@ModifyDate,");
strSql.Append("[ModifyUser]=@ModifyUser,");
strSql.Append("[State]=@State,");
strSql.Append("[Remark]=@Remark,");
strSql.Append("[dr]=@dr");
strSql.Append(" where [ID]=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@UserName", SqlDbType.NVarChar, 50),
new SqlParameter("@UserPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@UserMailQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@UserMessge", SqlDbType.NVarChar, 2000),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifyDate", SqlDbType.DateTime),
new SqlParameter("@ModifyUser", SqlDbType.Int),
new SqlParameter("@State", SqlDbType.Int),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@dr", SqlDbType.SmallInt)
};
parameters[0].Value = model.ID;
if (model.UserName != null)
{
parameters[1].Value = model.UserName;
}
else
{
parameters[1].Value = DBNull.Value;
}
parameters[2].Value = model.UserPhone;
if (model.UserMailQQ != null)
{
parameters[3].Value = model.UserMailQQ;
}
else
{
parameters[3].Value = DBNull.Value;
}
if (model.UserMessge != null)
{
parameters[4].Value = model.UserMessge;
}
else
{
parameters[4].Value = DBNull.Value;
}
parameters[5].Value = model.CreateDate;
if (model.ModifyDate != DateTime.MinValue)
{
parameters[6].Value = model.ModifyDate;
}
else
{
parameters[6].Value = DBNull.Value;
}
parameters[7].Value = model.ModifyUser;
parameters[8].Value = model.State;
if (model.Remark != null)
{
parameters[9].Value = model.Remark;
}
else
{
parameters[9].Value = DBNull.Value;
}
parameters[10].Value = model.dr;
return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0);
}
