public List <Model_FileSyncExecRecord> DataTableToList(DataTable dt) { List <Model_FileSyncExecRecord> list = new List <Model_FileSyncExecRecord>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Model_FileSyncExecRecord item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool Add_Operate(Model_FileSyncExecRecord model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into FileSyncExecRecord("); builder.Append("FileSyncExecRecord_id,FileSyncExecRecord_Type,FileSyncExecRecord_TimeStart,FileSyncExecRecord_TimeEnd,FileSyncExecRecord_Status,FileSyncExecRecord_Condition,createUser,FileSyncExecRecord_Remark)"); builder.Append(" values ("); builder.Append("@FileSyncExecRecord_id,@FileSyncExecRecord_Type,@FileSyncExecRecord_TimeStart,@FileSyncExecRecord_TimeEnd,@FileSyncExecRecord_Status,@FileSyncExecRecord_Condition,@createUser,@FileSyncExecRecord_Remark)"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FileSyncExecRecord_id", SqlDbType.Char, 0x24), new SqlParameter("@FileSyncExecRecord_Type", SqlDbType.VarChar, 30), new SqlParameter("@FileSyncExecRecord_TimeStart", SqlDbType.DateTime), new SqlParameter("@FileSyncExecRecord_TimeEnd", SqlDbType.DateTime), new SqlParameter("@FileSyncExecRecord_Status", SqlDbType.VarChar, 10), new SqlParameter("@FileSyncExecRecord_Condition", SqlDbType.VarChar, 100), new SqlParameter("@createUser", SqlDbType.Char, 0x24), new SqlParameter("@FileSyncExecRecord_Remark", SqlDbType.VarChar, 0x3e8) }; cmdParms[0].Value = model.FileSyncExecRecord_id; cmdParms[1].Value = model.FileSyncExecRecord_Type; cmdParms[2].Value = model.FileSyncExecRecord_TimeStart; cmdParms[3].Value = model.FileSyncExecRecord_TimeEnd; cmdParms[4].Value = model.FileSyncExecRecord_Status; cmdParms[5].Value = model.FileSyncExecRecord_Condition; cmdParms[6].Value = model.createUser; cmdParms[7].Value = model.FileSyncExecRecord_Remark; return(DbHelperSQL_Operate.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public Model_FileSyncExecRecord DataRowToModel(DataRow row) { Model_FileSyncExecRecord record = new Model_FileSyncExecRecord(); if (row != null) { if (row["FileSyncExecRecord_id"] != null) { record.FileSyncExecRecord_id = row["FileSyncExecRecord_id"].ToString(); } if (row["FileSyncExecRecord_Type"] != null) { record.FileSyncExecRecord_Type = row["FileSyncExecRecord_Type"].ToString(); } if ((row["FileSyncExecRecord_TimeStart"] != null) && (row["FileSyncExecRecord_TimeStart"].ToString() != "")) { record.FileSyncExecRecord_TimeStart = new DateTime?(DateTime.Parse(row["FileSyncExecRecord_TimeStart"].ToString())); } if ((row["FileSyncExecRecord_TimeEnd"] != null) && (row["FileSyncExecRecord_TimeEnd"].ToString() != "")) { record.FileSyncExecRecord_TimeEnd = new DateTime?(DateTime.Parse(row["FileSyncExecRecord_TimeEnd"].ToString())); } if (row["FileSyncExecRecord_Status"] != null) { record.FileSyncExecRecord_Status = row["FileSyncExecRecord_Status"].ToString(); } if (row["FileSyncExecRecord_Condition"] != null) { record.FileSyncExecRecord_Condition = row["FileSyncExecRecord_Condition"].ToString(); } if (row["createUser"] != null) { record.createUser = row["createUser"].ToString(); } if (row["FileSyncExecRecord_Remark"] != null) { record.FileSyncExecRecord_Remark = row["FileSyncExecRecord_Remark"].ToString(); } } return(record); }
public bool Update_Operate(Model_FileSyncExecRecord model) { StringBuilder builder = new StringBuilder(); builder.Append("update FileSyncExecRecord set "); builder.Append("FileSyncExecRecord_Type=@FileSyncExecRecord_Type,"); builder.Append("FileSyncExecRecord_TimeStart=@FileSyncExecRecord_TimeStart,"); builder.Append("FileSyncExecRecord_TimeEnd=@FileSyncExecRecord_TimeEnd,"); builder.Append("FileSyncExecRecord_Status=@FileSyncExecRecord_Status,"); builder.Append("FileSyncExecRecord_Condition=@FileSyncExecRecord_Condition,"); builder.Append("createUser=@createUser,"); builder.Append("FileSyncExecRecord_Remark=@FileSyncExecRecord_Remark"); builder.Append(" where FileSyncExecRecord_id=@FileSyncExecRecord_id "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@FileSyncExecRecord_Type", SqlDbType.VarChar, 30), new SqlParameter("@FileSyncExecRecord_TimeStart", SqlDbType.DateTime), new SqlParameter("@FileSyncExecRecord_TimeEnd", SqlDbType.DateTime), new SqlParameter("@FileSyncExecRecord_Status", SqlDbType.VarChar, 10), new SqlParameter("@FileSyncExecRecord_Condition", SqlDbType.VarChar, 100), new SqlParameter("@createUser", SqlDbType.Char, 0x24), new SqlParameter("@FileSyncExecRecord_Remark", SqlDbType.VarChar, 0x3e8), new SqlParameter("@FileSyncExecRecord_id", SqlDbType.Char, 0x24) }; cmdParms[0].Value = model.FileSyncExecRecord_Type; cmdParms[1].Value = model.FileSyncExecRecord_TimeStart; cmdParms[2].Value = model.FileSyncExecRecord_TimeEnd; cmdParms[3].Value = model.FileSyncExecRecord_Status; cmdParms[4].Value = model.FileSyncExecRecord_Condition; cmdParms[5].Value = model.createUser; cmdParms[6].Value = model.FileSyncExecRecord_Remark; cmdParms[7].Value = model.FileSyncExecRecord_id; return(DbHelperSQL_Operate.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool Add_Operate(Model_FileSyncExecRecord model) { return(this.dal.Add_Operate(model)); }
public bool Update(Model_FileSyncExecRecord model) { return(this.dal.Update(model)); }