public PaperWindow(string projectCode) { InitializeComponent(); this.projectcode = projectCode; this.cablePaper = new CablePaper(); this.DataContext = cablePaper; }
public PaperWindow(CablePaper cablePaper) { InitializeComponent(); this.projectcode = cablePaper.ProjectNO; this.cablePaper = cablePaper; this.txtfixcode.IsEnabled = false; this.DataContext = cablePaper; }
public static CablePaper GetPaper(CablePaper paper) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectString())) { cnn.Open(); string sql = "Select * From Fixture Where FixtureCode=@FixtureCode"; return(cnn.Query <CablePaper>(sql, paper).SingleOrDefault()); } }
public static int UpdatePaper(CablePaper paper) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectString())) { cnn.Open(); string sql = "Update Fixture Set ProjectNO=@ProjectNO,FixtureName=@FixtureName,ImagePath=@ImagePath,LEDAddress=@LEDAddress,IsSafeBox=@IsSafeBox Where FixtureCode=@FixtureCode"; return(cnn.Execute(sql, paper)); } }
public static int DeletePaper(CablePaper paper) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectString())) { cnn.Open(); string sql = "delete from Fixture where FixtureCode=@FixtureCode"; return(cnn.Execute(sql, paper)); } }
public static int AddPaper(CablePaper paper) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectString())) { cnn.Open(); string sql = "Insert into Fixture(ProjectNO,FixtureName,FixtureCode,ImagePath,LEDAddress,IsSafeBox)" + "Values(@ProjectNO,@FixtureName,@FixtureCode,@ImagePath,@LEDAddress,@IsSafeBox)"; return(cnn.Execute(sql, paper)); } }