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