/**
* 新增数据
**/
public static bool AddData(Common_Rail_Injector_Test data)
{
bool flag = false;
SqlSugarClient db = DBConnect.GetInstance();
flag = db.Insertable(data).ExecuteCommandIdentityIntoEntity();
return(true);
}
/**
* get all data from table
**/
//public static List<Common_Rail_Injector_Test> QueryForAll()
//{
// List<Common_Rail_Injector_Test> common_Rail_Injector_Tests = new List<Common_Rail_Injector_Test>();
// SqlSugarClient db = DBConnect.GetInstance();
// common_Rail_Injector_Tests = db.Queryable<Common_Rail_Injector_Test>().ToList();
// return common_Rail_Injector_Tests;
//}
/**
* 根据model_no和step_name获取数据
* */
public static Common_Rail_Injector_Test QueryByModelNoAndStepName(string model_no, string step_name)
{
Common_Rail_Injector_Test common_Rail_Injector_Test = new Common_Rail_Injector_Test();
SqlSugarClient db = DBConnect.GetInstance();
//查询单条，不用single，single超过一条会报错。
common_Rail_Injector_Test = db.Queryable <Common_Rail_Injector_Test>().Where(it => it.Model_no == model_no && it.Step_name == step_name).First();
return(common_Rail_Injector_Test);
}
/**
* 根据model_no和step_name更新选中的数据
* */
public static bool UpdateData(Common_Rail_Injector_Test common_Rail_Injector_Test)
{
bool flag = false;
SqlSugarClient db = DBConnect.GetInstance();
var a = db.Updateable <Common_Rail_Injector_Test>(common_Rail_Injector_Test).Where(it => it.Model_no == common_Rail_Injector_Test.Model_no && it.Step_name == common_Rail_Injector_Test.Step_name).ExecuteCommand();
if (a == 1)
{
flag = true;
return(flag);
}
else
{
return(flag);
}
}