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