/// <summary> /// 增加一条数据 /// </summary> public int Insert(Entities.ProjectTask_Cust_Brand model) { SqlParameter[] parameters = { new SqlParameter("@PTID", SqlDbType.VarChar), new SqlParameter("@BrandID", SqlDbType.Int, 4), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.PTID; parameters[1].Value = model.BrandID; parameters[2].Value = model.CreateTime; SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_PROJECTTASK_CUST_BRAND_INSERT, parameters); return(Convert.ToInt32(parameters[0].Value.ToString())); }
private Entities.ProjectTask_Cust_Brand LoadSingleProjectTask_Cust_Brand(DataRow row) { Entities.ProjectTask_Cust_Brand model = new Entities.ProjectTask_Cust_Brand(); model.PTID = row["PTID"].ToString(); if (row["BrandID"].ToString() != "") { model.BrandID = int.Parse(row["BrandID"].ToString()); } if (row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } return(model); }
private static Entities.ProjectTask_Cust_Brand LoadSingleCC_Cust_Brand(DataRow row) { Entities.ProjectTask_Cust_Brand model = new Entities.ProjectTask_Cust_Brand(); if (row["PTID"] != DBNull.Value) { model.PTID = row["PTID"].ToString(); } if (row["BrandID"] != DBNull.Value) { model.BrandID = Convert.ToInt32(row["BrandID"].ToString()); } if (row["CreateTime"] != DBNull.Value) { model.CreateTime = Convert.ToDateTime(row["CreateTime"].ToString()); } return(model); }