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