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