/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_amount_log GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,[value],[remark],add_time from " + databaseprefix + "user_amount_log "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; DataMap.Model.user_amount_log model = new DataMap.Model.user_amount_log(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.dicom GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,PID,Period,Heterogeneity,LobeSplit,TreatLobeVolumn,UnTreatLobeVolumn,CheckDate,File from dicom "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; Maticsoft.Model.dicom model = new Maticsoft.Model.dicom(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public cycms.Model.Themes GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,dbo_ThemesName,dbo_Ifuse from dbo_Themes "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; cycms.Model.Themes model = new cycms.Model.Themes(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据编码获取编号 /// </summary> /// <param name="codeNo">编码</param> /// <returns>编号</returns> public int GetIdByCodeNo(string codeNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id from tb_Category "); strSql.Append(" where codeNo=@codeNo "); OleDbParameter[] parameters = { new OleDbParameter("@codeNo", OleDbType.VarChar, 10) }; parameters[0].Value = codeNo; int id = 0; DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } } return(id); }
/// <summary> /// 得到一个对象实体 /// </summary> public AOC.Perf.Model.OBSTACLES GetModel(int OBSTACLECODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OBSTACLECODE,OBSTACLENATURECODE,DISTANCE,ELEVATION,LATERALDISTANCE,COMMENTS,CREATIONDATE,UPDATEDATE,UPDATETIME,LASTUPDATE,QFUCODE,CRC from OBSTACLES "); strSql.Append(" where OBSTACLECODE=@OBSTACLECODE"); OleDbParameter[] parameters = { new OleDbParameter("@OBSTACLECODE", OleDbType.Integer, 4) }; parameters[0].Value = OBSTACLECODE; AOC.Perf.Model.OBSTACLES model = new AOC.Perf.Model.OBSTACLES(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Express.Model.OrderInfo GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from OrderInfo "); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = Id; Express.Model.OrderInfo model = new Express.Model.OrderInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public hm.Model.ed_productAttribute GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,title,valueList from ed_productAttribute "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; hm.Model.ed_productAttribute model = new hm.Model.ed_productAttribute(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "") { model.title = ds.Tables[0].Rows[0]["title"].ToString(); } if (ds.Tables[0].Rows[0]["valueList"] != null && ds.Tables[0].Rows[0]["valueList"].ToString() != "") { model.valueList = ds.Tables[0].Rows[0]["valueList"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Dong.Model.Category GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,Pid,Name from Category "); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = Id; Dong.Model.Category model = new Dong.Model.Category(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DSJL.Model.TB_StandTestRefe GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,StandID,TestID from TB_StandTestRefe "); strSql.Append(" where ID=OLEDBID"); OleDbParameter[] parameters = { new OleDbParameter("OLEDBID", OleDbType.Integer, 4) }; parameters[0].Value = ID; DSJL.Model.TB_StandTestRefe model = new DSJL.Model.TB_StandTestRefe(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["StandID"].ToString() != "") { model.StandID = int.Parse(ds.Tables[0].Rows[0]["StandID"].ToString()); } if (ds.Tables[0].Rows[0]["TestID"].ToString() != "") { model.TestID = int.Parse(ds.Tables[0].Rows[0]["TestID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Dong.Model.GoodsInfo GetModelById(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,Code,GoodName,Category,CategoryName,Unit,UnitName,Factory,Supplier,SupplierName,Price0,Price1,Price2,Counts from GoodsInfo "); strSql.Append(" where Id=@Id"); OleDbParameter[] parameters = { new OleDbParameter("@Id", OleDbType.Integer, 4) }; parameters[0].Value = id; Dong.Model.GoodsInfo model = new Dong.Model.GoodsInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.ProductInfo GetModel(int productid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select productid,productname,promoney "); strSql.Append(" where productid=@productid"); OleDbParameter[] parameters = { new OleDbParameter("@productid", OleDbType.Integer, 4) }; parameters[0].Value = productid; KPS.Model.ProductInfo model = new KPS.Model.ProductInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Dong.Model.OperInfo GetModel(string Code) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,Code,Pwd,Name,Sex,CId,Phone,Role from OperInfo "); strSql.Append(" where Code=@Code "); OleDbParameter[] parameters = { new OleDbParameter("@Code", OleDbType.VarChar, 50) }; parameters[0].Value = Code; Dong.Model.OperInfo model = new Dong.Model.OperInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.mail_template GetModel(string call_index) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,title,call_index,maill_title,content,is_sys"); strSql.Append(" from " + databaseprefix + "mail_template"); strSql.Append(" where call_index=@call_index"); OleDbParameter[] parameters = { new OleDbParameter("@call_index", OleDbType.VarChar, 50) }; parameters[0].Value = call_index; DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据订单号返回一个实体 /// </summary> public Model.orders GetModel(string order_no) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,order_no,trade_no,user_id,user_name,payment_id,payment_fee,payment_status,payment_time,express_id,express_no,express_fee,express_status,express_time,accept_name,post_code,telphone,mobile,email,area,address,message,remark,is_invoice,invoice_title,invoice_taxes,payable_amount,real_amount,order_amount,point,status,add_time,confirm_time,complete_time"); strSql.Append(" from " + databaseprefix + "orders"); strSql.Append(" where order_no=@order_no"); OleDbParameter[] parameters = { new OleDbParameter("@order_no", OleDbType.VarChar, 100) }; parameters[0].Value = order_no; DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public KPS.Model.PermissionInfo GetModel(int permissionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select permissionID,userName,moduleInfoID from PSI_Permission "); strSql.Append(" where permissionID=@permissionID"); OleDbParameter[] parameters = { new OleDbParameter("@permissionID", OleDbType.Integer, 4) }; parameters[0].Value = permissionID; KPS.Model.PermissionInfo model = new KPS.Model.PermissionInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AOC.Perf.Model.QFUSETSELEMENTS GetModel(int QFUSETCODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select QFUSETCODE,QFUCODE from QFUSETSELEMENTS "); strSql.Append(" where QFUSETCODE=@QFUSETCODE "); OleDbParameter[] parameters = { new OleDbParameter("@QFUSETCODE", OleDbType.Integer, 4) }; parameters[0].Value = QFUSETCODE; AOC.Perf.Model.QFUSETSELEMENTS model = new AOC.Perf.Model.QFUSETSELEMENTS(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AOC.Perf.Model.QFU GetModel(int QFUCODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select QFUCODE,IDENT,TORA,ASDA,LDA,TODA,ENTRYANGLE,SLOPE,THRESHOLDLATITUDE,THRESHOLDLONGITUDE,THRESHOLDELEVATION,APPROACHSLOPE,COMMENTS,TOCOMMENTS,LDCOMMENTS,CREATIONDATE,UPDATEDATE,UPDATETIME,LASTUPDATE,TAKEOFFSHIFT,GROOVEDPFCSURFACETO,GROOVEDPFCSURFACELD,GLIDESLOPE,IncrementGAHeight,GROOVEDPFCSTOPWAY,RUNWAYPAVEMENT,MinKVs,MaxKVs,APPLICABILITY,RUNWAYPAVEMENTCBR,CRC,THRUSTREDUCTIONHEIGHT,ACCELERATIONHEIGHT,CLIMBSPEEDLIMITSTATUS,INITIALCLIMBSPEED,SPEEDLIMITALT,FINALCLIMBSPEED from QFU "); strSql.Append(" where QFUCODE=@QFUCODE"); OleDbParameter[] parameters = { new OleDbParameter("@QFUCODE", OleDbType.Integer, 4) }; parameters[0].Value = QFUCODE; AOC.Perf.Model.QFU model = new AOC.Perf.Model.QFU(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Patient GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,Name,IDCode,SignDate,ModifyDate from Patient "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; Maticsoft.Model.Patient model = new Maticsoft.Model.Patient(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.COPDMedication GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,PID,COPDTypeID,COPDTypeName,DrugName,Dose,[Usage] from COPDMedication "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; Maticsoft.Model.COPDMedication model = new Maticsoft.Model.COPDMedication(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public cycms.Model.FriendLink GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,dbo_FactoryLink,dbo_FactoryProductName,dbo_FactoryLogoSrc,dbo_ProductImgLink,dbo_ProductImgSrc,dbo_ProductImgName,dbo_ProductInfo from dbo_FriendLink "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; cycms.Model.FriendLink model = new cycms.Model.FriendLink(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public Rain.Model.article_category GetModel( OleDbConnection conn, OleDbTransaction trans, int id) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description"); stringBuilder.Append(" from " + this.databaseprefix + "article_category "); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)id; Rain.Model.article_category articleCategory = new Rain.Model.article_category(); DataSet dataSet = DbHelperOleDb.Query(conn, trans, stringBuilder.ToString(), oleDbParameterArray); if (dataSet.Tables[0].Rows.Count > 0) { return(this.DataRowToModel(dataSet.Tables[0].Rows[0])); } return((Rain.Model.article_category)null); }
/// <summary> /// 得到一个对象实体 /// </summary> public cycms.Model.TeacherInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,dbo_LoginName,dbo_PassWord,dbo_Name,dbo_Photo,dbo_Email,dbo_Title,dbo_Degree,dbo_Professional,dbo_Group,dbo_InfoBase,dbo_InfoTeac,dbo_InfoStudy,dbo_Order,dbo_Sex,dbo_Minzu,dbo_BirthDay,dbo_JiGuan,dbo_Party,dbo_ParthTime,dbo_ForeignLang,dbo_XueLi,dbo_WorkTime,dbo_EmpTime,dbo_EmpNum,dbo_School,dbo_Remarks,dbo_OfficePhone,dbo_HomePhone,dbo_MobilePhone,dbo_ShortNumber,dbo_HomeAddress,dbo_IsDisplay from dbo_TeacherInfo "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; cycms.Model.TeacherInfo model = new cycms.Model.TeacherInfo(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public string GetNextNodeByID(string PID) { string ResStr = string.Empty; StringBuilder strSql = new StringBuilder(); strSql.Append("select id from tb_Category "); strSql.Append(" where parentid in (" + PID + ")"); DataSet ds = DbHelperOleDb.Query(strSql.ToString()); if (ds != null) { DataTable dttemp = ds.Tables[0]; foreach (DataRow dr in dttemp.Rows) { ResStr += dr["id"] + ","; } } if (!string.IsNullOrEmpty(ResStr)) { ResStr = ResStr.Substring(0, ResStr.Length - 1); } return(ResStr); }
/// <summary> /// 根据商品ID查询商品实体 /// </summary> public Model.article_goods GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,article_id,goods_no,spec_ids,spec_text,stock_quantity,market_price,sell_price from " + databaseprefix + "article_goods"); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Model.article_goods model = new Model.article_goods(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TFXK.Model.Permission GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,roleID,moduleID from tb_Permission "); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; TFXK.Model.Permission model = new TFXK.Model.Permission(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if (ds.Tables[0].Rows[0]["roleID"].ToString() != "") { model.roleID = int.Parse(ds.Tables[0].Rows[0]["roleID"].ToString()); } if (ds.Tables[0].Rows[0]["moduleID"].ToString() != "") { model.moduleID = int.Parse(ds.Tables[0].Rows[0]["moduleID"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.user_code GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,[type],str_code,[count],status,user_ip,eff_time,add_time"); strSql.Append(" from " + databaseprefix + "user_code "); strSql.Append(" where id=@id"); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public cycms.Model.ArticleType GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,dbo_TypeName,dbo_LinkUrl,dbo_Fatherid,dbo_IsDisplay,dbo_SpecialityId,dbo_IsArticleType from dbo_ArticleType "); strSql.Append(" where ID=@ID"); OleDbParameter[] parameters = { new OleDbParameter("@ID", OleDbType.Integer, 4) }; parameters[0].Value = ID; cycms.Model.ArticleType model = new cycms.Model.ArticleType(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 根据生成码得到一个对象实体 /// </summary> public Model.user_code GetModel(string str_code) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,user_id,user_name,[type],str_code,[count],status,user_ip,eff_time,add_time"); strSql.Append(" from " + databaseprefix + "user_code "); strSql.Append(" where status=0 and datediff('d',eff_time,now())<=0 and str_code=@str_code"); OleDbParameter[] parameters = { new OleDbParameter("@str_code", OleDbType.VarChar, 255) }; parameters[0].Value = str_code; DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public HR_Test.Model.GBT282892012_TwistSel GetModel(string methodName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,methodName,FMmax,M,M_,SM,Mc,saveCurve from tb_GBT282892012_TwistSel "); strSql.Append(" where methodName=@methodName"); OleDbParameter[] parameters = { new OleDbParameter("@methodName", OleDbType.VarChar) }; parameters[0].Value = methodName; HR_Test.Model.GBT282892012_TwistSel model = new HR_Test.Model.GBT282892012_TwistSel(); DataSet ds = DbHelperOleDb.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体,带事务 /// </summary> public Model.channel GetModel(OleDbConnection conn, OleDbTransaction trans, int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,site_id,[name],title,is_albums,is_attach,is_spec,sort_id from " + databaseprefix + "channel "); strSql.Append(" where id=@id "); OleDbParameter[] parameters = { new OleDbParameter("@id", OleDbType.Integer, 4) }; parameters[0].Value = id; Model.channel model = new Model.channel(); DataSet ds = DbHelperOleDb.Query(conn, trans, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(conn, trans, ds.Tables[0].Rows[0])); } else { return(null); } }