private static Entities.ProjectTask_DMSMember_Brand LoadSingleProjectTask_DMSMember_Brand(DataRow row) { Entities.ProjectTask_DMSMember_Brand model = new Entities.ProjectTask_DMSMember_Brand(); if (row["MemberID"] != DBNull.Value) { model.MemberID = Convert.ToInt32(row["MemberID"].ToString()); } if (row["BrandID"] != DBNull.Value) { model.BrandID = Convert.ToInt32(row["BrandID"].ToString()); } if (row["SerialID"] != DBNull.Value) { model.SerialID = row["SerialID"].ToString(); } if (row["Type"] != DBNull.Value) { model.Type = row["Type"].ToString(); } if (row["CreateTime"] != DBNull.Value) { model.CreateTime = Convert.ToDateTime(row["CreateTime"].ToString()); } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.ProjectTask_DMSMember_Brand model) { SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.Int, 4), new SqlParameter("@BrandID", SqlDbType.Int, 4), new SqlParameter("@SerialID", SqlDbType.VarChar, 50), new SqlParameter("@Type", SqlDbType.Char, 10), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.MemberID; parameters[1].Value = model.BrandID; parameters[2].Value = model.SerialID; parameters[3].Value = model.Type; parameters[4].Value = model.CreateTime; return(SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_DMSMEMBER_BRAND_UPDATE, parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(Entities.ProjectTask_DMSMember_Brand model) { return(Dal.ProjectTask_DMSMember_Brand.Instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.ProjectTask_DMSMember_Brand model) { Dal.ProjectTask_DMSMember_Brand.Instance.Insert(model); }