/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(JSYCRM.Models.z_parameter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into z_parameter(");
strSql.Append("ID,TYPE,NAME,VALUE,DESCRIPTION,CREATE_USER_ID,CREATE_DATETIME,UPDATE_USER_ID,UPDATE_DATETIME,DELETE_FLG)");
strSql.Append(" values (");
strSql.Append("@ID,@TYPE,@NAME,@VALUE,@DESCRIPTION,@CREATE_USER_ID,@CREATE_DATETIME,@UPDATE_USER_ID,@UPDATE_DATETIME,@DELETE_FLG)");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@TYPE", SqlDbType.NVarChar,50),
new SqlParameter("@NAME", SqlDbType.NVarChar,50),
new SqlParameter("@VALUE", SqlDbType.NVarChar,50),
new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar,100),
new SqlParameter("@CREATE_USER_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CREATE_DATETIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_USER_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@UPDATE_DATETIME", SqlDbType.DateTime),
new SqlParameter("@DELETE_FLG", SqlDbType.Char,1)};
parameters[0].Value = model.ID;
parameters[1].Value = model.TYPE;
parameters[2].Value = model.NAME;
parameters[3].Value = model.VALUE;
parameters[4].Value = model.DESCRIPTION;
parameters[5].Value = model.CREATE_USER_ID;
parameters[6].Value = model.CREATE_DATETIME;
parameters[7].Value = model.UPDATE_USER_ID;
parameters[8].Value = model.UPDATE_DATETIME;
parameters[9].Value = model.DELETE_FLG;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JSYCRM.Models.z_parameter model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update z_parameter set ");
strSql.Append("TYPE=@TYPE,");
strSql.Append("NAME=@NAME,");
strSql.Append("VALUE=@VALUE,");
strSql.Append("DESCRIPTION=@DESCRIPTION,");
strSql.Append("CREATE_USER_ID=@CREATE_USER_ID,");
strSql.Append("CREATE_DATETIME=@CREATE_DATETIME,");
strSql.Append("UPDATE_USER_ID=@UPDATE_USER_ID,");
strSql.Append("UPDATE_DATETIME=@UPDATE_DATETIME,");
strSql.Append("DELETE_FLG=@DELETE_FLG");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@TYPE", SqlDbType.NVarChar,50),
new SqlParameter("@NAME", SqlDbType.NVarChar,50),
new SqlParameter("@VALUE", SqlDbType.NVarChar,50),
new SqlParameter("@DESCRIPTION", SqlDbType.NVarChar,100),
new SqlParameter("@CREATE_USER_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@CREATE_DATETIME", SqlDbType.DateTime),
new SqlParameter("@UPDATE_USER_ID", SqlDbType.UniqueIdentifier,16),
new SqlParameter("@UPDATE_DATETIME", SqlDbType.DateTime),
new SqlParameter("@DELETE_FLG", SqlDbType.Char,1),
new SqlParameter("@ID", SqlDbType.UniqueIdentifier,16)};
parameters[0].Value = model.TYPE;
parameters[1].Value = model.NAME;
parameters[2].Value = model.VALUE;
parameters[3].Value = model.DESCRIPTION;
parameters[4].Value = model.CREATE_USER_ID;
parameters[5].Value = model.CREATE_DATETIME;
parameters[6].Value = model.UPDATE_USER_ID;
parameters[7].Value = model.UPDATE_DATETIME;
parameters[8].Value = model.DELETE_FLG;
parameters[9].Value = model.ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
