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