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