public bool AddNotReturn(Model.torquecheckrecord checkrecord)
{
try
{
string sqldep = string.Format("select * from torquechecktarget where id='{0}'", checkrecord.TorqueCheckTargetID);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
torquechecktarget dep = DataTableToList.GetList <torquechecktarget>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
checkrecord.TorqueCheckTargetID = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO torquecheckrecord(TorqueCheckTargetID_id,TesterID,errorRangeMax,errorRangeMin,analyserValue,torqueTargetValue,checkTime,passedFlag,isEffective,isTurn,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()",
checkrecord.TorqueCheckTargetID, checkrecord.TesterID, checkrecord.errorRangeMax, checkrecord.errorRangeMin, checkrecord.analyserValue, checkrecord.torqueTargetValue, checkrecord.checkTime, checkrecord.passedFlag == true ? 1 : 0, checkrecord.isEffective == true ? 1 : 0, checkrecord.isTurn == true ? 1 : 0, checkrecord.comment, checkrecord.guid
);
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public bool Add(List <Model.torquechecktarget> listtorquechecktarget)
{
try
{
string sql = "";
foreach (torquechecktarget torquechecktarget in listtorquechecktarget)
{
string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
torquechecktarget.wrenchID = dep.guid;
}
}
sql +=
string.Format
(
"INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;",
torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid
) + "\r";
}
sql += " select last_insert_rowid()";
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch { return(false); }
}
public ActionResult ReadXls()
{
AjaxMsgModel amm = new Message().NewAmm;
amm.Msg = "导入文件格式不正确！";
#region 第一步EXCEL转DT
int rowindex = 2; //开始行
int sheetindex = 0; //工作表索引
amm = new ExcelHelper().ToDataTable(System.Web.HttpContext.Current.Request.Files, sheetindex, rowindex, amm);
if (amm.Statu == AjaxStatu.err) //如果转DT不成功
{
return(ObjToJson.GetToJson(amm, true));
}
DataTable dt = amm.Data as DataTable;
amm.Data = null;
#endregion
#region 第二步DT转LIST
amm = DataTableToList <SYS_MEMBER> .ConvertToList(dt, rowindex, amm); //转换为LIST集合
if (amm.Statu == AjaxStatu.err) //如果转LIST不成功
{
return(ObjToJson.GetToJson(amm, true));
}
List <SYS_MEMBER> list_SYS_MEMBER = amm.Data as List <SYS_MEMBER>;
amm.Data = null;
#endregion
#region 第三步业务判断并插入数据库
//错误集合
List <TableToListErrorModel> errorList = new List <TableToListErrorModel>();
int rowline = 0;
foreach (SYS_MEMBER member in list_SYS_MEMBER)
{
rowline++;
if (member.NAME == "")//如果没有姓名
{
amm.Statu = AjaxStatu.err;
errorList.Add(
new TableToListErrorModel()
{
rowIndex = rowindex + rowline,
columnIndex = 0,//dt.Columns.IndexOf(tempName) + 1
errorInfo = "姓名必须输入",
errorCause = "姓名必须输入"
});
}
}
if (amm.Statu == AjaxStatu.err)//如果不存在
{
amm.Data = errorList;
return(ObjToJson.GetToJson(amm, true));
}
//业务判断并插入数据库
return(ObjToJson.GetToJson(Model_SYS_MEMBER.AddList(list_SYS_MEMBER), true));
#endregion
}
public string AddReturnGuid(Model.torquechecktarget torquechecktarget)
{
try
{
string sqldep = string.Format("select * from wrench where id='{0}'", torquechecktarget.wrenchID);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
wrench dep = DataTableToList.GetList <wrench>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
torquechecktarget.wrenchID = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO torquechecktarget(wrenchID_id,checkDate,qaID,operatorID,torqueTargetValue,errorRangeMax,errorRangeMin,count,arry,is_good,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}') ;select last_insert_rowid()",
torquechecktarget.wrenchID, torquechecktarget.checkDate, torquechecktarget.qaID, torquechecktarget.operatorID, torquechecktarget.torqueTargetValue, torquechecktarget.errorRangeMax, torquechecktarget.errorRangeMin, torquechecktarget.count, torquechecktarget.arry, torquechecktarget.is_good == true?1:0, torquechecktarget.comment, torquechecktarget.guid
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
return(ds.ToString());
}
catch
{
return("-1");
}
}
public List <torquechecktarget> SelectByContion(Dictionary <string, string> dict, int pagesize, int pageno)
{
try
{
string temp = "";
foreach (var d in dict)
{
if (d.Key == "starttime")
{
temp += string.Format("checkDate>='{0}' and ", d.Value);
continue;
}
if (d.Key == "endtime")
{
temp += string.Format("checkDate<'{0}' and ", d.Value);
continue;
}
temp += string.Format("{0}='{1}' and ", d.Key, d.Value);
}
string contion = temp.Count() > 4 ? temp.Remove(temp.Count() - 4) : "";
contion += string.Format("LIMIT {0},{1}", (pageno * pagesize), pagesize);
string sql = "select * from torquechecktarget where " + contion;
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <torquechecktarget>(ds.Tables[0]));
}
return(null);
}
catch { return(null); }
}
public bool Add(Model.duties duty)
{
try
{
string sqldep = string.Format("select * from department where id='{0}'", duty.department);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
duty.department = dep.guid;
}
}
string sql =
string.Format
(
"INSERT INTO duties(department_id,dutiesName,comment,guid) VALUES('{0}','{1}','{2}','{3}') ;select last_insert_rowid();",
duty.department, duty.dutiesName, duty.comment, duty.guid
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
/// <summary>
/// 抓取所有数据元
/// Add by xlb 2013-04-12
/// </summary>
/// <returns></returns>
public List <DateElementEntity> GetAllDateElement()
{
try
{
SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured);
p_result.Direction = ParameterDirection.Output;
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@ElementId", SqlDbType.VarChar, 50),
new SqlParameter("@ElementName", SqlDbType.VarChar, 50),
new SqlParameter("@ElementClass", SqlDbType.VarChar, 50),
new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50),
p_result
};
sqlParams[0].Value = "";
sqlParams[1].Value = "";
sqlParams[2].Value = "";
sqlParams[3].Value = "";
DataTable dtDateTable = DS_SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure);
List <DateElementEntity> dataList = DataTableToList <DateElementEntity> .ConvertToModel(dtDateTable);
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
public string GetAllCategory()
{
string sql = string.Format(@"SELECT FirstId,FirstName
FROM dbo.CpkFirstCategory
WHERE FirstName IN('菜系','菜式','食材') ORDER BY FirstId"); //根据用户需求只显示菜系 菜式 食材三种
var q = DataTableToList.ConvertTo <RCategory>(dataContext.ExecuteDataTable(CommandType.Text, sql));
List <RCategory> rlist = new List <RCategory>();
foreach (var item in q)
{
// sql = string.Format(@"SELECT c.SecondId,c.SecondName,COUNT(1) Total FROM dbo.CpkCaiPinBasicInfo a
// JOIN dbo.CpkCaiPinCategory b ON b.CaiPinId = a.CaiPinId
// JOIN dbo.CpkSecondCategory c ON c.SecondId=b.SecondCategoryId
// WHERE a.IsEnable=1 AND a.IsPublish =1 AND c.IsEnable =1 AND c.IsPublish =1 AND c.FirstId ={0}
// GROUP BY c.SecondId,c.SecondName", item.FirstId);
sql = string.Format(@"SELECT a.SecondId,a.SecondName, SUM(CASE WHEN b.CaiPinId IS NULL THEN 0 ELSE 1 END) Total
FROM CpkSecondCategory a
LEFT JOIN CpkCaiPinCategory b ON a.SecondId=b.SecondCategoryId
LEFT JOIN CpkCaiPinBasicInfo c ON c.CaiPinId = b.CaiPinId AND c.IsEnable =1 AND c.IsPublish =1
WHERE a.IsEnable=1 AND a.IsPublish =1 AND a.FirstId ={0}
GROUP BY a.SecondId,a.SecondName", item.FirstId);
DataTable dt2 = dataContext.ExecuteDataTable(CommandType.Text, sql);
item.SecondList = dt2;
item.Total = dt2.Rows.Count > 0 ? Convert.ToInt16(dt2.Compute("Sum(Total)", "true")) : 0;
rlist.Add(item);
}
return(JsonConvert.SerializeObject(rlist));
}
public bool Add(Model.role userroler)
{
try
{
string sqldep = string.Format("select * from system where id='{0}'", userroler.system);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
system system = DataTableToList.GetList <system>(dps.Tables[0]).FirstOrDefault();
if (system != null)
{
userroler.system = system.guid;
}
}
string sql =
string.Format
(
"INSERT INTO role(roleName,system_id,roleDM,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}') ;select last_insert_rowid()",
userroler.roleName, userroler.system, userroler.roleDM, userroler.comment, userroler.guid
);
var ds = SqliteHelper.ExecuteScalar(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
public List <UserModel> GetAllUsers()
{
var db = new TableBasedSp(RunSpName);
var dt = db.GetFirstTableOfData("uspGetUsers", ConnectionString);
var users = new DataTableToList().Convert <UserModel>(dt);
return(users);
}
public List <SchemesRecordModel> Get()
{
var dal = new DAL_CM();
var ds = dal.Get_Schemes_Record(null);
DataTable dt = ds.Tables[0];
var model = new List <SchemesRecordModel>();
model = DataTableToList.ConvertDataTable <SchemesRecordModel>(dt);
return(model);
}
public List <DistrictAllocationModel> GetDistrictAllocation()
{
var dal = new DAL_CM();
var ds = dal.Get_District_Allocation();
DataTable dt = ds.Tables[0];
var model = new List <DistrictAllocationModel>();
model = DataTableToList.ConvertDataTable <DistrictAllocationModel>(dt);
return(model);
}
/// <summary>
/// 根据小说编号获取小说章节数据
/// </summary>
/// <param name="novelId">小说编号</param>
/// <returns></returns>
public List <Chapters> ChapterList(string novelId)
{
var list = new List <Chapters>();
DataSet ds = ChapterDal.ChapterData(novelId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = new DataTableToList <Chapters>(ds.Tables[0]).ToList();
}
return(list);
}
/// <summary>
/// 获取小说站点分页数据
/// </summary>
/// <param name="paramList">查询及分页参数</param>
/// <returns></returns>
public List <WebSites> PageWebList(Dictionary <string, string> paramList)
{
var list = new List <WebSites>();
DataSet ds = WebDal.PageWebData(paramList);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = new DataTableToList <WebSites>(ds.Tables[0]).ToList();
}
return(list);
}
/// <summary>
/// 获取小说抓取参数列表
/// </summary>
/// <param name="webId">站点编号</param>
/// <param name="novelId">小说编号</param>
/// <returns></returns>
public List <Model.Novels> CrawlList(string webId, string novelId)
{
List <Model.Novels> list = null;
DataSet ds = NovelDal.CrawlData(webId, novelId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList();
}
return(list);
}
/// <summary>
/// 获取小说抓取参数实体
/// </summary>
/// <param name="webId">站点编号</param>
/// <param name="novelId">小说编号</param>
/// <returns></returns>
public Model.Novels CrawlModel(string webId, string novelId)
{
Model.Novels model = null;
DataSet ds = NovelDal.CrawlData(webId, novelId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
model = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList().FirstOrDefault();
}
return(model);
}
/// <summary>
/// 获取小说定义分页数据
/// </summary>
/// <param name="paramList">查询及分页参数</param>
/// <returns></returns>
public List <Model.Novels> PageNovelList(Dictionary <string, string> paramList)
{
var list = new List <Model.Novels>();
DataSet ds = NovelDal.PageNovelData(paramList);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = new DataTableToList <Model.Novels>(ds.Tables[0]).ToList();
}
return(list);
}
/// <summary>
/// 根据章节编号获取章节数据
/// </summary>
/// <param name="chapterId">章节编号</param>
/// <returns></returns>
public Chapters ChapterModel(string chapterId)
{
Chapters model = null;
DataSet ds = ChapterDal.ChapterDataByChapterId(chapterId);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
model = new DataTableToList <Chapters>(ds.Tables[0]).ToList().FirstOrDefault();
}
return(model);
}
public List <UserModel> GetProgramUsers(UserStatusEnum userStatusEnum = UserStatusEnum.All)
{
var db = new TableBasedSp(RunSpName);
var parameters = new Dictionary <string, string>
{
{ "ProgramId", ProgramId.ToString() },
{ "Enable", ((int)userStatusEnum).ToString() }
};
var dt = db.GetFirstTableOfData("uspGetProgramUsers", ConnectionString, parameters);
var users = new DataTableToList().Convert <UserModel>(dt);
return(users);
}
public bool addlist(List <Model.wrench> wrenchlist)
{
try
{
string sql = "";
foreach (wrench wrenchtool in wrenchlist)
{
string sqldep = string.Format("select * from wrenchspecies where id='{0}'", wrenchtool.species);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
wrenchtool.species = dep.guid;
}
}
sqldep = string.Format("select * from wrenchstatus where id='{0}'", wrenchtool.status);
dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
wrenchstatus dep = DataTableToList.GetList <wrenchstatus>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
wrenchtool.status = dep.guid;
}
}
sql +=
string.Format
(
"INSERT INTO wrench(wrenchCode,wrenchBarCode,rangeMin,rangeMax,factory,createDate,IP,port,species_id,status_id,lastrepair,cycletime,isallowcheck,targetvalue,targetvalue1,targetvalue2,unit,comment,guid,offPset) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}');",
wrenchtool.wrenchCode, wrenchtool.wrenchBarCode, wrenchtool.rangeMin, wrenchtool.rangeMax, wrenchtool.factory, wrenchtool.createDate, wrenchtool.IP, wrenchtool.port, wrenchtool.species, wrenchtool.status, wrenchtool.lastrepair, wrenchtool.cycletime, wrenchtool.isallowcheck == true ? 1 : 0, wrenchtool.targetvalue, wrenchtool.targetvalue1, wrenchtool.targetvalue2, wrenchtool.unit, wrenchtool.comment, wrenchtool.guid, wrenchtool.offPset
) + "\r";
}
sql += "select last_insert_rowid();";
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
static void Main(string[] args)
{
DataTableToList datatabletolist = new DataTableToList();
datatabletolist.SingleTest(); //DataTable => Object
datatabletolist.ListTest(); //DataTable => List
datatabletolist.ListFilterTest(); //DataTable => List, filter포함
DataBaseTest databasetest = new DataBaseTest();
databasetest.MultiTransationTest(); //멀티트랜잭션 테스트
databasetest.OutputTest(); //파라미터 output테스트
databasetest.PerformanceTest(); //성능테스트
Console.ReadLine();
}
public bool Add(List <Model.users> userlist)
{
try
{
string sql = "";
foreach (users user in userlist)
{
string sqldep = string.Format("select * from department where id='{0}'", user.department);
DataSet dps = SqliteHelper.ExecuteDataSet(con, sqldep, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
department dep = DataTableToList.GetList <department>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
user.department = dep.guid;
}
}
string sqlduty = string.Format("select * from duties where id='{0}'", user.duties);
dps = SqliteHelper.ExecuteDataSet(con, sqlduty, CommandType.Text);
if (dps != null && dps.Tables.Count > 0)
{
duties dep = DataTableToList.GetList <duties>(dps.Tables[0]).FirstOrDefault();
if (dep != null)
{
user.duties = dep.guid;
}
}
sql +=
string.Format
(
"INSERT INTO users(username,is_superuser,password,is_staff,joinDate,department_id,duties_id,empID,cardID,phoneNumber,IDNum,mail,comment,guid) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}');",
user.username, user.is_superuser == true?1:0, user.password, user.is_staff == true?1:0, user.joinDate, user.department, user.duties, user.empID, user.cardID, user.phoneNumber, user.IDNum, user.mail, user.comment, user.guid
) + "\r";
}
sql += "select last_insert_rowid()";
var ds = SqliteHelper.ExecuteNonQuery(con, sql, CommandType.Text);
if (Convert.ToInt32(ds) > 0)
{
return(true);
}
return(false);
}
catch
{
return(false);
}
}
/// <summary>
/// 通过病人病案号抓取相应的使用对象集合
/// Add by xlb 2013-04-12
/// </summary>
/// <returns></returns>
public List <IemMainPageExceptUse> GetIemExceptUse(string noofinpat)
{
try
{
SqlParameter[] sps = { new SqlParameter("@noofinpat", noofinpat) };
DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlGetIemUseByNoof, sps, CommandType.Text);
List <IemMainPageExceptUse> iemExceptUse = DataTableToList <IemMainPageExceptUse> .ConvertToModel(dt);
return(iemExceptUse);
}
catch (Exception ex)
{
throw ex;
}
}
public List<ProgramsModel> GetPrograms()
{
var db = new TableBasedSp(RunSpName);
try
{
var dt = db.GetFirstTableOfData("uspGetPrograms", ConnectionString);
var programs = new DataTableToList().Convert<ProgramsModel>(dt);
return programs;
}
catch (Exception ex)
{
throw ex;
}
}
public string GetById(int ZhuanTiId)
{
ReturnJson r = new ReturnJson();
string sql = string.Format(@"SELECT a.ZhuanTiId,a.ZhuanTiName,a.ZhuanTiURL,b.ZtContentId,b.Content
FROM dbo.CpkZhuanTi a JOIN dbo.CpkZhuanTiContent b ON b.ZhuanTiId = a.ZhuanTiId AND b.IsEnable=1
WHERE a.IsEnable = 1 AND a.ZhuanTiId = {0}", ZhuanTiId);
var data = dataContext.ExecuteDataTable(CommandType.Text, sql);
var ztList = DataTableToList.ConvertTo <RZhuanTi>(data);
foreach (var item in ztList)
{
item.CaiPinList = GetCaiPinByZhuanTiContentId(item.ZtContentId);
}
return(JsonConvert.SerializeObject(ztList));
}
/// <summary>
/// 获取病人对象
/// </summary>
private void GeInpat()
{
try
{
DataTable dtInpat = DS_SqlHelper.ExecuteDataTable(@"select noofinpat,patid,outhosdept,
outhosward,outbed,name from inpatient where noofinpat=@noofinpat",
new SqlParameter[] { new SqlParameter("@noofinpat", CurrentNoofinpat) },
CommandType.Text);
//datatable->inpatientsim
inpatient = DataTableToList <InpatientSim> .ConvertToModelOne(dtInpat);
}
catch (Exception ex)
{
throw ex;
}
}
public List <Model.department> SelectByFlag(bool flag = false)
{
try
{
string sql = string.Format("select * from department where delDepartment={0}", flag == true?1:0);
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <department>(ds.Tables[0]));
}
return(null);
}
catch
{
return(null);
}
}
public Model.wrenchspecies selectByGuid(string guid)
{
try
{
string sql = string.Format("select * from wrenchspecies where guid='{0}'", guid);
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <wrenchspecies>(ds.Tables[0]).FirstOrDefault());
}
return(null);
}
catch
{
return(null);
}
}
public List <Model.wrenchspecies> selectbyname(string name)
{
try
{
string sql = string.Format("select * from wrenchspecies where speciesName='{0}'", name);
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <wrenchspecies>(ds.Tables[0]));
}
return(null);
}
catch
{
return(null);
}
}
public List <Model.wrenchstatus> selectAll()
{
try
{
string sql = string.Format("select * from wrenchstatus");
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <wrenchstatus>(ds.Tables[0]));
}
return(null);
}
catch
{
return(null);
}
}
public List <Model.torquecheckrecord> SelectByCheckTargetID(string checktargetguid)
{
try
{
string sql = string.Format("select * from torquecheckrecord where TorqueCheckTargetID_id='{0}' ", checktargetguid);
DataSet ds = SqliteHelper.ExecuteDataSet(con, sql, CommandType.Text);
if (ds != null && ds.Tables.Count > 0)
{
return(DataTableToList.GetList <torquecheckrecord>(ds.Tables[0]));
}
return(null);
}
catch
{
return(null);
}
}
