public bool Update(Model_SyncFileToSchoolData model) { StringBuilder builder = new StringBuilder(); builder.Append("update SyncFileToSchoolData set "); builder.Append("SchoolId=@SchoolId,"); builder.Append("SchoolName=@SchoolName,"); builder.Append("SchoolUrl=@SchoolUrl,"); builder.Append("BookAllCount=@BookAllCount,"); builder.Append("BookTobeCount=@BookTobeCount,"); builder.Append("Remark=@Remark,"); builder.Append("CreateUser=@CreateUser,"); builder.Append("CreateTime=@CreateTime"); builder.Append(" where SyncFileToSchoolData_Id=@SyncFileToSchoolData_Id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SchoolId", SqlDbType.VarChar, 50), new SqlParameter("@SchoolName", SqlDbType.VarChar, 500), new SqlParameter("@SchoolUrl", SqlDbType.VarChar, 200), new SqlParameter("@BookAllCount", SqlDbType.Int, 4), new SqlParameter("@BookTobeCount", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 0x3e8), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@SyncFileToSchoolData_Id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.SchoolId; cmdParms[1].Value = model.SchoolName; cmdParms[2].Value = model.SchoolUrl; cmdParms[3].Value = model.BookAllCount; cmdParms[4].Value = model.BookTobeCount; cmdParms[5].Value = model.Remark; cmdParms[6].Value = model.CreateUser; cmdParms[7].Value = model.CreateTime; cmdParms[8].Value = model.SyncFileToSchoolData_Id; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_SyncFileToSchoolData DataRowToModel(DataRow row) { Model_SyncFileToSchoolData data = new Model_SyncFileToSchoolData(); if (row != null) { if (row["SyncFileToSchoolData_Id"] != null) { data.SyncFileToSchoolData_Id = row["SyncFileToSchoolData_Id"].ToString(); } if (row["SchoolId"] != null) { data.SchoolId = row["SchoolId"].ToString(); } if (row["SchoolName"] != null) { data.SchoolName = row["SchoolName"].ToString(); } if (row["SchoolUrl"] != null) { data.SchoolUrl = row["SchoolUrl"].ToString(); } if ((row["BookAllCount"] != null) && (row["BookAllCount"].ToString() != "")) { data.BookAllCount = new int?(int.Parse(row["BookAllCount"].ToString())); } if ((row["BookTobeCount"] != null) && (row["BookTobeCount"].ToString() != "")) { data.BookTobeCount = new int?(int.Parse(row["BookTobeCount"].ToString())); } if (row["Remark"] != null) { data.Remark = row["Remark"].ToString(); } if (row["CreateUser"] != null) { data.CreateUser = row["CreateUser"].ToString(); } if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != "")) { data.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString())); } } return(data); }
public List <Model_SyncFileToSchoolData> DataTableToList(DataTable dt) { List <Model_SyncFileToSchoolData> list = new List <Model_SyncFileToSchoolData>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_SyncFileToSchoolData item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add(Model_SyncFileToSchoolData model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into SyncFileToSchoolData("); builder.Append("SyncFileToSchoolData_Id,SchoolId,SchoolName,SchoolUrl,BookAllCount,BookTobeCount,Remark,CreateUser,CreateTime)"); builder.Append(" values ("); builder.Append("@SyncFileToSchoolData_Id,@SchoolId,@SchoolName,@SchoolUrl,@BookAllCount,@BookTobeCount,@Remark,@CreateUser,@CreateTime)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SyncFileToSchoolData_Id", SqlDbType.Char, 0x24), new SqlParameter("@SchoolId", SqlDbType.VarChar, 50), new SqlParameter("@SchoolName", SqlDbType.VarChar, 500), new SqlParameter("@SchoolUrl", SqlDbType.VarChar, 200), new SqlParameter("@BookAllCount", SqlDbType.Int, 4), new SqlParameter("@BookTobeCount", SqlDbType.Int, 4), new SqlParameter("@Remark", SqlDbType.VarChar, 0x3e8), new SqlParameter("@CreateUser", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; cmdParms[0].Value = model.SyncFileToSchoolData_Id; cmdParms[1].Value = model.SchoolId; cmdParms[2].Value = model.SchoolName; cmdParms[3].Value = model.SchoolUrl; cmdParms[4].Value = model.BookAllCount; cmdParms[5].Value = model.BookTobeCount; cmdParms[6].Value = model.Remark; cmdParms[7].Value = model.CreateUser; cmdParms[8].Value = model.CreateTime; return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add(Model_SyncFileToSchoolData model) { return(this.dal.Add(model)); }
public bool Update(Model_SyncFileToSchoolData model) { return(this.dal.Update(model)); }