/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.DealerBrandInfo model) { SqlParameter[] parameters = { new SqlParameter("@CustID", SqlDbType.VarChar, 20), new SqlParameter("@DealerID", SqlDbType.Int, 4), new SqlParameter("@BrandID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@CreateUserID", SqlDbType.Int, 4) }; parameters[0].Value = model.CustID; parameters[1].Value = model.DealerID; parameters[2].Value = model.BrandID; parameters[3].Value = model.CreateTime; parameters[4].Value = model.CreateUserID; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_DEALERBRANDINFO_INSERT, parameters); }
private Entities.DealerBrandInfo LoadSingleDealerBrandInfo(DataRow row) { Entities.DealerBrandInfo model = new Entities.DealerBrandInfo(); model.CustID = row["CustID"].ToString(); if (row["DealerID"].ToString() != "") { model.DealerID = int.Parse(row["DealerID"].ToString()); } if (row["BrandID"].ToString() != "") { model.BrandID = int.Parse(row["BrandID"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateUserID"].ToString() != "") { model.CreateUserID = int.Parse(row["CreateUserID"].ToString()); } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Insert(Entities.DealerBrandInfo model) { Dal.DealerBrandInfo.Instance.Insert(model); }