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