/// <summary> /// 更新一条数据 /// </summary> public bool Update(Eday.Model.ISOTrain_Trainer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ISOTrain_Trainer set "); strSql.Append("TrainerInitial=@TrainerInitial,"); strSql.Append("CourseCode=@CourseCode,"); strSql.Append("TaskLevel=@TaskLevel,"); strSql.Append("EffectiveDate=@EffectiveDate,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("bak1=@bak1,"); strSql.Append("bak2=@bak2,"); strSql.Append("bak3=@bak3,"); strSql.Append("bak4=@bak4,"); strSql.Append("bak5=@bak5"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@TrainerInitial", SqlDbType.NVarChar, 50), new SqlParameter("@CourseCode", SqlDbType.NVarChar, 50), new SqlParameter("@TaskLevel", SqlDbType.NVarChar, 50), new SqlParameter("@EffectiveDate", SqlDbType.DateTime), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@bak1", SqlDbType.NVarChar, 50), new SqlParameter("@bak2", SqlDbType.NVarChar, 50), new SqlParameter("@bak3", SqlDbType.NVarChar, 50), new SqlParameter("@bak4", SqlDbType.NVarChar, 50), new SqlParameter("@bak5", SqlDbType.NVarChar, 50), new SqlParameter("@ID", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.TrainerInitial; parameters[1].Value = model.CourseCode; parameters[2].Value = model.TaskLevel; parameters[3].Value = model.EffectiveDate; parameters[4].Value = model.CreateDate; parameters[5].Value = model.bak1; parameters[6].Value = model.bak2; parameters[7].Value = model.bak3; parameters[8].Value = model.bak4; parameters[9].Value = model.bak5; parameters[10].Value = model.ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eday.Model.ISOTrain_Trainer DataRowToModel(DataRow row) { Eday.Model.ISOTrain_Trainer model = new Eday.Model.ISOTrain_Trainer(); if (row != null) { if (row["ID"] != null) { model.ID = row["ID"].ToString(); } if (row["TrainerInitial"] != null) { model.TrainerInitial = row["TrainerInitial"].ToString(); } if (row["CourseCode"] != null) { model.CourseCode = row["CourseCode"].ToString(); } if (row["TaskLevel"] != null) { model.TaskLevel = row["TaskLevel"].ToString(); } if (row["EffectiveDate"] != null && row["EffectiveDate"].ToString() != "") { model.EffectiveDate = DateTime.Parse(row["EffectiveDate"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["bak1"] != null) { model.bak1 = row["bak1"].ToString(); } if (row["bak2"] != null) { model.bak2 = row["bak2"].ToString(); } if (row["bak3"] != null) { model.bak3 = row["bak3"].ToString(); } if (row["bak4"] != null) { model.bak4 = row["bak4"].ToString(); } if (row["bak5"] != null) { model.bak5 = row["bak5"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Eday.Model.ISOTrain_Trainer model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ISOTrain_Trainer("); strSql.Append("ID,TrainerInitial,CourseCode,TaskLevel,EffectiveDate,CreateDate,bak1,bak2,bak3,bak4,bak5)"); strSql.Append(" values ("); strSql.Append("@ID,@TrainerInitial,@CourseCode,@TaskLevel,@EffectiveDate,@CreateDate,@bak1,@bak2,@bak3,@bak4,@bak5)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 50), new SqlParameter("@TrainerInitial", SqlDbType.NVarChar, 50), new SqlParameter("@CourseCode", SqlDbType.NVarChar, 50), new SqlParameter("@TaskLevel", SqlDbType.NVarChar, 50), new SqlParameter("@EffectiveDate", SqlDbType.DateTime), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@bak1", SqlDbType.NVarChar, 50), new SqlParameter("@bak2", SqlDbType.NVarChar, 50), new SqlParameter("@bak3", SqlDbType.NVarChar, 50), new SqlParameter("@bak4", SqlDbType.NVarChar, 50), new SqlParameter("@bak5", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.ID; parameters[1].Value = model.TrainerInitial; parameters[2].Value = model.CourseCode; parameters[3].Value = model.TaskLevel; parameters[4].Value = model.EffectiveDate; parameters[5].Value = model.CreateDate; parameters[6].Value = model.bak1; parameters[7].Value = model.bak2; parameters[8].Value = model.bak3; parameters[9].Value = model.bak4; parameters[10].Value = model.bak5; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eday.Model.ISOTrain_Trainer GetModel(string ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,TrainerInitial,CourseCode,TaskLevel,EffectiveDate,CreateDate,bak1,bak2,bak3,bak4,bak5 from ISOTrain_Trainer "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.NVarChar, 50) }; parameters[0].Value = ID; Eday.Model.ISOTrain_Trainer model = new Eday.Model.ISOTrain_Trainer(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }