/// <summary> /// 由一行数据得到一个实体 /// </summary> private Hi.Model.SYS_GType GetModel(DataRow r) { Hi.Model.SYS_GType model = new Hi.Model.SYS_GType(); model.ID = SqlHelper.GetInt(r["ID"]); model.TypeCode = SqlHelper.GetString(r["TypeCode"]); model.TypeName = SqlHelper.GetString(r["TypeName"]); model.ParentId = SqlHelper.GetInt(r["ParentId"]); model.Deep = SqlHelper.GetInt(r["Deep"]); model.FullCode = SqlHelper.GetString(r["FullCode"]); model.IsEnd = SqlHelper.GetBool(r["IsEnd"]); model.SortIndex = SqlHelper.GetString(r["SortIndex"]); model.IsEnabled = SqlHelper.GetBool(r["IsEnabled"]); model.SVdef1 = SqlHelper.GetString(r["SVdef1"]); model.SVdef2 = SqlHelper.GetString(r["SVdef2"]); model.SVdef3 = SqlHelper.GetString(r["SVdef3"]); model.CreateUser = SqlHelper.GetString(r["CreateUser"]); model.CreateDate = SqlHelper.GetDateTime(r["CreateDate"]); model.ts = SqlHelper.GetDateTime(r["ts"]); model.dr = SqlHelper.GetBool(r["dr"]); return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Hi.Model.SYS_GType model) { model.ID = GetMaxId() + 1; StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [SYS_GType]("); strSql.Append("[ID],[TypeCode],[TypeName],[ParentId],[Deep],[FullCode],[IsEnd],[SortIndex],[IsEnabled],[SVdef1],[SVdef2],[SVdef3],[CreateUser],[CreateDate],[ts],[dr])"); strSql.Append(" values ("); strSql.Append("@ID,@TypeCode,@TypeName,@ParentId,@Deep,@FullCode,@IsEnd,@SortIndex,@IsEnabled,@SVdef1,@SVdef2,@SVdef3,@CreateUser,@CreateDate,@ts,@dr)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@TypeCode", SqlDbType.NVarChar, 30), new SqlParameter("@TypeName", SqlDbType.NVarChar, 30), new SqlParameter("@ParentId", SqlDbType.Int), new SqlParameter("@Deep", SqlDbType.Int), new SqlParameter("@FullCode", SqlDbType.NVarChar, 50), new SqlParameter("@IsEnd", SqlDbType.Bit), new SqlParameter("@SortIndex", SqlDbType.NVarChar, 20), new SqlParameter("@IsEnabled", SqlDbType.Bit), new SqlParameter("@SVdef1", SqlDbType.NVarChar, 100), new SqlParameter("@SVdef2", SqlDbType.NVarChar, 100), new SqlParameter("@SVdef3", SqlDbType.NVarChar, 100), new SqlParameter("@CreateUser", SqlDbType.Char, 36), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.Bit) }; parameters[0].Value = model.ID; if (model.TypeCode != null) { parameters[1].Value = model.TypeCode; } else { parameters[1].Value = DBNull.Value; } parameters[2].Value = model.TypeName; parameters[3].Value = model.ParentId; parameters[4].Value = model.Deep; if (model.FullCode != null) { parameters[5].Value = model.FullCode; } else { parameters[5].Value = DBNull.Value; } parameters[6].Value = model.IsEnd; if (model.SortIndex != null) { parameters[7].Value = model.SortIndex; } else { parameters[7].Value = DBNull.Value; } parameters[8].Value = model.IsEnabled; if (model.SVdef1 != null) { parameters[9].Value = model.SVdef1; } else { parameters[9].Value = DBNull.Value; } if (model.SVdef2 != null) { parameters[10].Value = model.SVdef2; } else { parameters[10].Value = DBNull.Value; } if (model.SVdef3 != null) { parameters[11].Value = model.SVdef3; } else { parameters[11].Value = DBNull.Value; } parameters[12].Value = model.CreateUser; parameters[13].Value = model.CreateDate; parameters[14].Value = model.ts; parameters[15].Value = model.dr; if (SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0) { return(model.ID); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hi.Model.SYS_GType model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [SYS_GType] set "); strSql.Append("[TypeCode]=@TypeCode,"); strSql.Append("[TypeName]=@TypeName,"); strSql.Append("[ParentId]=@ParentId,"); strSql.Append("[Deep]=@Deep,"); strSql.Append("[FullCode]=@FullCode,"); strSql.Append("[IsEnd]=@IsEnd,"); strSql.Append("[SortIndex]=@SortIndex,"); strSql.Append("[IsEnabled]=@IsEnabled,"); strSql.Append("[SVdef1]=@SVdef1,"); strSql.Append("[SVdef2]=@SVdef2,"); strSql.Append("[SVdef3]=@SVdef3,"); strSql.Append("[CreateUser]=@CreateUser,"); strSql.Append("[CreateDate]=@CreateDate,"); strSql.Append("[ts]=@ts,"); strSql.Append("[dr]=@dr"); strSql.Append(" where [ID]=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@TypeCode", SqlDbType.NVarChar, 30), new SqlParameter("@TypeName", SqlDbType.NVarChar, 30), new SqlParameter("@ParentId", SqlDbType.Int), new SqlParameter("@Deep", SqlDbType.Int), new SqlParameter("@FullCode", SqlDbType.NVarChar, 50), new SqlParameter("@IsEnd", SqlDbType.Bit), new SqlParameter("@SortIndex", SqlDbType.NVarChar, 20), new SqlParameter("@IsEnabled", SqlDbType.Bit), new SqlParameter("@SVdef1", SqlDbType.NVarChar, 100), new SqlParameter("@SVdef2", SqlDbType.NVarChar, 100), new SqlParameter("@SVdef3", SqlDbType.NVarChar, 100), new SqlParameter("@CreateUser", SqlDbType.Char, 36), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@ts", SqlDbType.DateTime), new SqlParameter("@dr", SqlDbType.Bit) }; parameters[0].Value = model.ID; if (model.TypeCode != null) { parameters[1].Value = model.TypeCode; } else { parameters[1].Value = DBNull.Value; } parameters[2].Value = model.TypeName; parameters[3].Value = model.ParentId; parameters[4].Value = model.Deep; if (model.FullCode != null) { parameters[5].Value = model.FullCode; } else { parameters[5].Value = DBNull.Value; } parameters[6].Value = model.IsEnd; if (model.SortIndex != null) { parameters[7].Value = model.SortIndex; } else { parameters[7].Value = DBNull.Value; } parameters[8].Value = model.IsEnabled; if (model.SVdef1 != null) { parameters[9].Value = model.SVdef1; } else { parameters[9].Value = DBNull.Value; } if (model.SVdef2 != null) { parameters[10].Value = model.SVdef2; } else { parameters[10].Value = DBNull.Value; } if (model.SVdef3 != null) { parameters[11].Value = model.SVdef3; } else { parameters[11].Value = DBNull.Value; } parameters[12].Value = model.CreateUser; parameters[13].Value = model.CreateDate; parameters[14].Value = model.ts; parameters[15].Value = model.dr; return(SqlHelper.ExecuteSql(SqlHelper.LocalSqlServer, strSql.ToString(), parameters) > 0); }