public static int Insert(MountItem mountItem)
{
string command = "INSERT INTO mountitem (MountItemNum,MountNum,Xpos,Ypos,OrdinalPos,Width,Height) VALUES ("
+ "'" + POut.PInt(mountItem.MountItemNum) + "',"
+ "'" + POut.PInt(mountItem.MountNum) + "',"
+ "'" + POut.PInt(mountItem.Xpos) + "',"
+ "'" + POut.PInt(mountItem.Ypos) + "',"
+ "'" + POut.PInt(mountItem.OrdinalPos) + "',"
+ "'" + POut.PInt(mountItem.Width) + "',"
+ "'" + POut.PInt(mountItem.Height) + "')";
return(General2.NonQEx(command, true));
}
public static int Update(MountItem mountItem)
{
string command = "UPDATE mountitem SET "
+ "MountNum='" + POut.PInt(mountItem.MountNum) + "',"
+ "Xpos='" + POut.PInt(mountItem.Xpos) + "',"
+ "Ypos='" + POut.PInt(mountItem.Ypos) + "',"
+ "OrdinalPos='" + POut.PInt(mountItem.OrdinalPos) + "',"
+ "Width='" + POut.PInt(mountItem.Width) + "',"
+ "Height='" + POut.PInt(mountItem.Height) + "' "
+ "WHERE MountItemNum='" + POut.PInt(mountItem.MountItemNum) + "'";
return(General2.NonQEx(command));
}
public static int Insert(Mount mount)
{
string command = "INSERT INTO mount (MountNum,PatNum,DocCategory,DateCreated,Description,Note,ImgType,Width,Height) VALUES ("
+ "'" + POut.PInt(mount.MountNum) + "',"
+ "'" + POut.PInt(mount.PatNum) + "',"
+ "'" + POut.PInt(mount.DocCategory) + "',"
+ POut.PDate(mount.DateCreated) + ","
+ "'" + POut.PString(mount.Description) + "',"
+ "'" + POut.PString(mount.Note) + "',"
+ "'" + POut.PInt((int)mount.ImgType) + "',"
+ "'" + POut.PInt(mount.Width) + "',"
+ "'" + POut.PInt(mount.Height) + "')";
return(General2.NonQEx(command, true));
}
public static int Update(Mount mount)
{
string command = "UPDATE mount SET "
+ "PatNum='" + POut.PInt(mount.PatNum) + "',"
+ "DocCategory='" + POut.PInt(mount.DocCategory) + "',"
+ "DateCreated=" + POut.PDate(mount.DateCreated) + ","
+ "Description='" + POut.PString(mount.Description) + "',"
+ "Note='" + POut.PString(mount.Note) + "',"
+ "ImgType='" + POut.PInt((int)mount.ImgType) + "',"
+ "Width='" + POut.PInt(mount.Width) + "',"
+ "Height='" + POut.PInt(mount.Height) + "' "
+ "WHERE MountNum='" + POut.PInt(mount.MountNum) + "'";
return(General2.NonQEx(command));
}
public static void Delete(MountItem mountItem)
{
string command = "DELETE FROM mountitem WHERE MountItemNum='" + POut.PInt(mountItem.MountItemNum) + "'";
General2.NonQEx(command);
}
public static void Delete(Mount mount)
{
string command = "DELETE FROM mount WHERE MountNum='" + POut.PInt(mount.MountNum) + "'";
General2.NonQEx(command);
}