/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.IO_COMMUNICATION GetModel(string IO_COMM_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" IO_COMM_ID,IO_COMM_NAME,IO_COMM_LABEL,IO_COMM_REMARK,IO_COMM_STATUS,IO_COMM_DRIVER_ID,IO_SERVER_ID,IO_COMM_PARASTRING ");
strSql.Append(" from IO_COMMUNICATION ");
strSql.Append(" where IO_COMM_ID='" + IO_COMM_ID + "'");
Scada.Model.IO_COMMUNICATION model = new Scada.Model.IO_COMMUNICATION();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Scada.Model.IO_SERVER GetModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" SERVER_ID,SERVER_NAME,SERVER_STATUS,SERVER_IP,SERVER_CREATEDATE,SERVER_REMARK ");
strSql.Append(" from IO_SERVER LIMIT 1");
Scada.Model.IO_SERVER model = new Scada.Model.IO_SERVER();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.ScadaTableDetail GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" Id,TableId,FieldTitles,FieldIOPath,CreateTime,SortCode,CreateUserId,UpdateTime,UpdateUserId ");
strSql.Append(" from ScadaTableDetail ");
strSql.Append(" where Id=" + Id + "");
Scada.Model.ScadaTableDetail model = new Scada.Model.ScadaTableDetail();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.ScadaTable GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" Id,Title,RoleUser,FilterRule,CreateTime,CreateUserId,UpdateTime,UpdateUserId,SortCode ");
strSql.Append(" from ScadaTable ");
strSql.Append(" where Id=" + Id + "");
Scada.Model.ScadaTable model = new Scada.Model.ScadaTable();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.IO_PARA GetModel(string IO_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" * ");
strSql.Append(" from V_IO_PARA ");
strSql.Append(" where IO_ID='" + IO_ID + "' and IO_STATUS=0 ");
Scada.Model.IO_PARA model = new Scada.Model.IO_PARA();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.DeviceGroup GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
strSql.Append(" Id,GroupId,IO_SERVER_ID,IO_COMM_ID,IO_DEVICE_ID ");
strSql.Append(" from DeviceGroup ");
strSql.Append(" where Id=" + Id + "");
Scada.Model.DeviceGroup model = new Scada.Model.DeviceGroup();
DataSet ds = DbHelperSQLite.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private void button1_Click(object sender, EventArgs e)
{
//get the password from the database.
string SQL = "SELECT * FROM FolderInfo WHERE folderName =@folderName";
SQLiteParameter p = new SQLiteParameter("@folderName", path);
DataTable dt = DbHelperSQLite.Query(SQL, p).Tables[0];
//
if (dt.Rows.Count == 0)
{
MessageBox.Show("password is missing");
}
else
{
//the input password should be convert to md5 password;
MD5 md5 = new MD5CryptoServiceProvider();
byte[] plaintext = Encoding.Default.GetBytes(textBox1.Text);
byte[] ciphertext = md5.ComputeHash(plaintext);
string md5Pwd = Convert.ToBase64String(ciphertext);
if (md5Pwd == Convert.ToString(dt.Rows[0][1]))
{
status = true;
MessageBox.Show("The folder is unlocked.");
//delete the record;
string DEL = "DELETE FROM FolderInfo WHERE folderName =@folderName";
DbHelperSQLite.ExecuteSql(DEL, p);
//
SendKeys.SendWait("{f5}");
this.Close();
}
else
{
MessageBox.Show("password is incorrect.");
textBox1.Clear();
textBox1.Focus();
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DXD.Model.insurance_compare GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select id,query_id,feedback_id,report_id,compare_type,less_value,add_user,add_time from insurance_compare ");
strSql.Append(" where id=@id");
SQLiteParameter[] parameters = {
new SQLiteParameter("@id", DbType.Int32,4)
};
parameters[0].Value = id;
DXD.Model.insurance_compare model=new DXD.Model.insurance_compare();
DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
public DataTable GetWebSiteTask(int StepMinuTime)
{
DataSet ds = new DataSet();
StringBuilder strSql = new StringBuilder();
strSql.AppendFormat(@"
Select * From S_WebSite
Where Status=1
--And (julianday(UpdateTime)*24*60 - julianday('now')*24*60)>{0}
Order by UpdateTime Asc Limit 5
", StepMinuTime);
ds = DbHelperSQLite.Query(strSql.ToString());
DataTable dt = ds.Tables[0].Clone();
foreach (DataRow dr in ds.Tables[0].Rows)
{
DateTime upDateTime = Convert.ToDateTime(dr["UpDateTime"]);
if ((DateTime.Now - upDateTime).Minutes >= StepMinuTime)
{
dt.Rows.Add(dr.ItemArray);
}
}
string IDs = string.Empty;
foreach (DataRow dr in dt.Rows)
{
IDs += dr["ID"] + ",";
}
if (!string.IsNullOrEmpty(IDs))
{
IDs = IDs.Remove(IDs.Length - 1);
strSql = new StringBuilder();
strSql.Append(@"
Update S_WebSite set UpdateTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + @"' Where ID in(" + IDs + @")
");
DbHelperSQLite.ExecuteSql(strSql.ToString());
}
return(dt);
}
public DataTable GetModel(string tablename, string fieldStr, string strWhere)
{
if (string.IsNullOrEmpty(fieldStr))
{
fieldStr = "*";
}
string sql = string.Format("select {0} from [{1}] ", fieldStr, tablename);
if (!string.IsNullOrEmpty(strWhere))
{
sql += " where " + strWhere;
}
sql += " limit 1";
sql = StringHelper.ReplaceBadSQL(sql);
DataSet ds = DbHelperSQLite.Query(sql);
if (ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby );
}
else
{
strSql.Append("order by T.id desc");
}
strSql.Append(")AS Row, T.* from insurance_compare T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
return DbHelperSQLite.Query(strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Blogs.Model.BlogArticle GetModel(int aid)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select aid,acate,aauthor,atitle,acontent,aimgsrc,aplnum,aallowpl,aistop,atag,acick,astatu,aaddtime,aupdatetime,aisdel,ahtmlsrc from BlogArticle ");
strSql.Append(" where aid=@aid");
SQLiteParameter[] parameters = {
new SQLiteParameter("@aid", DbType.Int32,4)
};
parameters[0].Value = aid;
Blogs.Model.BlogArticle model=new Blogs.Model.BlogArticle();
DataSet ds=DbHelperSQLite.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Material.Model.level2 GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select name,level1_id,id2 from level2 ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Material.Model.level2 model = new Material.Model.level2();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MaterialCodeGenerator.Model.MaterialCode GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select iMainClassID,cMainClassName,iLevel1ID,cLevel1Name,iLevel2ID,cLevel2Name,iLevel3ID,cLevel3Name from MaterialCode ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
MaterialCodeGenerator.Model.MaterialCode model = new MaterialCodeGenerator.Model.MaterialCode();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sys_Module GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ModuleType,ModuleCode,ModuleName,ModuleDesc,ModuleConfig,Path,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State from Sys_Module ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sys_Module model = new Bsam.Core.Model.Models.Model.Sys_Module();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到存储的窗体样式
/// </summary>
public static void GetUIInfo()
{
string sqlstr = "SELECT * FROM GSSCONFIG WHERE ID=1";
try
{
DataSet ds = DbHelperSQLite.Query(sqlstr);
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows != null)
{
string[] servinfo = new string[2];
string backcolor = ds.Tables[0].Rows[0]["GSSUIBACKCOLOR"].ToString();
string[] cols = backcolor.Split(',');
_backcolor = Color.FromArgb(int.Parse(cols[0]), int.Parse(cols[1]), int.Parse(cols[2]));
_opacity = Convert.ToDouble(ds.Tables[0].Rows[0]["GSSUIOPACITY"].ToString());
_topmost = ds.Tables[0].Rows[0]["GSSUITOPMOST"].ToString() == "1" ? true : false;
}
_backimage = GetImage();
}
catch (System.Exception ex)
{
//不做处理
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ERPWPF.Model.DingdanDetail GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Gid,Tid,GCode,GName,GGuige,GShuliang,GJinjia,GShoujia,GZhekou,GYouhui,GHeji from DingdanDetail ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
ERPWPF.Model.DingdanDetail model = new ERPWPF.Model.DingdanDetail();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,BillId,MitemCode,PlanQty,ActualQty,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Rcv_Bill_Dtl ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl model = new Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Dtl();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sfc_Customer GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,CustomerCode,CustomerName,CustomerShortName,CustomerPhone,CustomerWebchat,EnterpriseName,EnterpriseLegal,EnterpriseAddress,EnterprisePhone,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Customer ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sfc_Customer model = new Bsam.Core.Model.Models.Model.Sfc_Customer();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sys_User GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,UserName,UserAccount,UserPwd,Address,Phone,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State from Sys_User ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sys_User model = new Bsam.Core.Model.Models.Model.Sys_User();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Inv_Loc GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,LocCode,LocName,LocDesc,LocStatus,LocOrder,Volume,VolumeUnit,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId,DistrictId,InvId from Inv_Loc ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Inv_Loc model = new Bsam.Core.Model.Models.Model.Inv_Loc();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sfc_Production_Bom GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ProductId,MitemId,ReqQty,Version,VersionDesc,BatchNo,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Production_Bom ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sfc_Production_Bom model = new Bsam.Core.Model.Models.Model.Sfc_Production_Bom();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sfc_Mitem GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,MitemCode,MitemName,MitemDesc,MitemType,Brand,Buyer,DutyPerson,SupplierId,DefaultInvId,Uom,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sfc_Mitem ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sfc_Mitem model = new Bsam.Core.Model.Models.Model.Sfc_Mitem();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Inv_Onhand_Qty GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,MitemId,InvId,DistrictId,LocId,Trans_Qty,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Onhand_Qty ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Inv_Onhand_Qty model = new Bsam.Core.Model.Models.Model.Inv_Onhand_Qty();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sys_PermissionGroup GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,PermissionGroupName,PermissionGroupDesc,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Sys_PermissionGroup ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sys_PermissionGroup model = new Bsam.Core.Model.Models.Model.Sys_PermissionGroup();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,RcvType,RcvUserId,RcvUserName,RcvPhone,RcvDateTime,RcvReason,RcvAddress,RentSubject,RentUserId,RentUserName,RentPhone,RrcBillId,PlanRtnDateTime,ActualRtnDateTime,BillStatus,DateTimeCreated,UserCreator,DateTimeModified,UserModified,State,OrgId from Inv_Rcv_Bill_Hd ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd model = new Bsam.Core.Model.Models.Model.Inv_Rcv_Bill_Hd();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role GetModel()
{
//该表无主键信息，请自定义主键/条件字段
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserGroupId,RoleId from Sys_UserGroup_In_Role ");
strSql.Append(" where ");
SQLiteParameter[] parameters =
{
};
Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role model = new Bsam.Core.Model.Models.Model.Sys_UserGroup_In_Role();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public UcJsglEntity GetModel(string ZJ)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ZJ, JSMC, JSLX, CJR, CJSJ, BZ, QYBZ ");
strSql.Append(" from uc_jsgl ");
strSql.Append(" where ZJ=@ZJ ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ZJ", DbType.String)
};
parameters[0].Value = ZJ;
UcJsglEntity model = new UcJsglEntity();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
model.ZJ = ds.Tables[0].Rows[0]["ZJ"].ToString();
model.JSMC = ds.Tables[0].Rows[0]["JSMC"].ToString();
model.JSLX = ds.Tables[0].Rows[0]["JSLX"].ToString();
model.CJR = ds.Tables[0].Rows[0]["CJR"].ToString();
model.CJSJ = ds.Tables[0].Rows[0]["CJSJ"].ToString();
model.BZ = ds.Tables[0].Rows[0]["BZ"].ToString();
if (ds.Tables[0].Rows[0]["QYBZ"].ToString() != "")
{
model.QYBZ = int.Parse(ds.Tables[0].Rows[0]["QYBZ"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Scada.Model.Classify_DRIVER GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id,ClassifyName,CreateTime,UpdateTime,Description from Classify_DRIVER ");
strSql.Append(" where Id=@Id ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@Id", DbType.Int32, 8)
};
parameters[0].Value = Id;
Scada.Model.Classify_DRIVER model = new Scada.Model.Classify_DRIVER();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo GetModel(int ReaderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ReaderID,ReaderPointID,ReaderType,ReaderName,ReaderLocation,ReaderVersion,ReaderSAM,ReaderSAMType,CardType,CardReadArea,FingerEnable,SercurityAccessLevel,SupervisedMode,PINIdentify,ReaderPIN,DuressCode,ArmPassword,UnarmPassword,CommunicateType,ReaderMAC,ReaderIP,ReaderSubnet,ReaderGateway,ReaderPort,ReaderDNS,ReaderBuDNS,ReaderAddr483,ReaderBaudrate,ReaderDataBits,ReaderStopBits,ReaderParityCheck,ReaderFlowControl,ReaderUsage,ReadTimeAccessID from ReaderInfo ");
strSql.Append(" where ReaderID=@ReaderID ");
SQLiteParameter[] parameters =
{
new SQLiteParameter("@ReaderID", DbType.Int32, 4)
};
parameters[0].Value = ReaderID;
KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo model = new KryptonAccessController.SQLite.Model.ControllerRelation.ReaderInfo();
DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
