/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCode_ProxyServer GetModel(int n_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_ID,s_ProxyServer,s_Port,s_UserName,s_Password,s_Domain,s_IfProxy from TCode_ProxyServer ");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = n_ID;
IPSP.Model.TCode_ProxyServer model = new IPSP.Model.TCode_ProxyServer();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Model.wx_hotel_dingdan GetLastUserModel(string openid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from wx_hotel_dingdan ");
strSql.Append(" where openid =@id and isDelete='0' ORDER BY orderTime DESC ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.VarChar, 200)
};
parameters[0].Value = openid;
WeiXinPF.Model.wx_hotel_dingdan model = new WeiXinPF.Model.wx_hotel_dingdan();
DataSet ds = DbHelperSQL.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.daikuan_repay GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from daikuan_repay");
strSql.Append(" where id=@id ");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.daikuan_repay model = new Model.daikuan_repay();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public lgk.Model.tb_goods GetModel(long ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,GoodsCode,GoodsName,Price,RealityPrice,Standard,IsHave,TypeID,GoodsType,Pic1,Pic2,Pic3,Pic4,Pic5,Summary,Remarks,AddTime,Goods001,Goods002,Goods003,Goods004,Goods005,Goods006,Goods007,Goods008,GoodsName_en,Remarks_en,StateType,City,ShopPrice,Inventory,SaleNum from tb_goods ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.BigInt)
};
parameters[0].Value = ID;
lgk.Model.tb_goods model = new lgk.Model.tb_goods();
DataSet ds = DbHelperSQL.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.photos GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,ContentType,postedFileFileName,FileName,fileExtension,qishu,fenlei2 from photos ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Maticsoft.Model.photos model = new Maticsoft.Model.photos();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MyERP.Model.STEEL_GG_BOM GetModel(int temID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 temID,INTERNAL_CODE,SEQUENCE,ITEM_INTERNAL_CODE,ITEM_CODE,ITEM_NAME,SPECIFICATIONS,KD,QUANTITY,CREATE_NAME,CREATE_DATE,UPDATE_NAME,UPDATE_DATE,REMARK from STEEL_GG_BOM ");
strSql.Append(" where temID=@temID");
SqlParameter[] parameters =
{
new SqlParameter("@temID", SqlDbType.Int, 4)
};
parameters[0].Value = temID;
MyERP.Model.STEEL_GG_BOM model = new MyERP.Model.STEEL_GG_BOM();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_fc_aboutWe GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,name,telephone,mobilephone,address,logoAddress,lngX,latY,sort_id,newsDetail,createDate,wid,fid from wx_fc_aboutWe ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
MxWeiXinPF.Model.wx_fc_aboutWe model = new MxWeiXinPF.Model.wx_fc_aboutWe();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public VipSoft.Model.MemCard GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CardID,CardMianID,Name,Sex,Password,Mobile,Photo,LevelID,IsPast,PastTime,Point,State,IsPointAuto,Money,TotalMoney,ShopID,ShopName,LastTime,Email,PayMoney,Remark,CardTypeID from MemCard ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
VipSoft.Model.MemCard model = new VipSoft.Model.MemCard();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 查找不存在的商品并删除
/// </summary>
private void DeleteGoodsList(SqlConnection conn, SqlTransaction trans, List <Model.order_goods> models, int order_id)
{
StringBuilder idList = new StringBuilder();
if (models != null)
{
foreach (Model.order_goods modelt in models)
{
if (modelt.id > 0)
{
idList.Append(modelt.id + ",");
}
}
}
string id_list = Utils.DelLastChar(idList.ToString(), ",");
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from dt_order_goods where order_id=" + order_id);
if (!string.IsNullOrEmpty(id_list))
{
strSql.Append(" and id not in(" + id_list + ")");
}
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public book_shop.Model.ActionGroupModel GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,GroupName,GroupType,DelFlag,Sort from ActionGroup ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
book_shop.Model.ActionGroupModel model = new book_shop.Model.ActionGroupModel();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_ucard_store GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,storeName,logo,storeCatagory,cardBrief,consumePwd,tel,addr,xPoint,yPoint,createDate,sort_id,isRecommend,hfPic from wx_ucard_store ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_ucard_store model = new MxWeiXinPF.Model.wx_ucard_store();
DataSet ds = DbHelperSQL.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.weixin_request_content GetModel(int rule_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,account_id,rule_id,title,content,link_url,img_url,media_id,media_url,meida_hd_url,sort_id,add_time");
strSql.Append(" from " + databaseprefix + "weixin_request_content");
strSql.Append(" where rule_id=@rule_id");
SqlParameter[] parameters =
{
new SqlParameter("@rule_id", SqlDbType.Int, 4)
};
parameters[0].Value = rule_id;
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_ucard_udegree GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,degreeNum,callName,score_min,score_max,createDate,sId from wx_ucard_udegree ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
WeiXinPF.Model.wx_ucard_udegree model = new WeiXinPF.Model.wx_ucard_udegree();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(IPSP.Model.TCode_ProxyServer model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TCode_ProxyServer(");
strSql.Append("s_ProxyServer,s_Port,s_UserName,s_Password,s_Domain,s_IfProxy)");
strSql.Append(" values (");
strSql.Append("@s_ProxyServer,@s_Port,@s_UserName,@s_Password,@s_Domain,@s_IfProxy)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@s_ProxyServer", SqlDbType.NVarChar, 50),
new SqlParameter("@s_Port", SqlDbType.NVarChar, 10),
new SqlParameter("@s_UserName", SqlDbType.NVarChar, 500),
new SqlParameter("@s_Password", SqlDbType.NVarChar, 500),
new SqlParameter("@s_Domain", SqlDbType.NVarChar, 100),
new SqlParameter("@s_IfProxy", SqlDbType.NVarChar, 1)
};
parameters[0].Value = model.s_ProxyServer;
parameters[1].Value = model.s_Port;
parameters[2].Value = model.s_UserName;
parameters[3].Value = model.s_Password;
parameters[4].Value = model.s_Domain;
parameters[5].Value = model.s_IfProxy;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MxWeiXinPF.Model.wx_industry_defaultModule GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,role_id,typeName,mName,isArticle,url,sort_id,createDate,remark from wx_industry_defaultModule ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
MxWeiXinPF.Model.wx_industry_defaultModule model = new MxWeiXinPF.Model.wx_industry_defaultModule();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(decimal id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from td_standard_price ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Decimal)
};
parameters[0].Value = id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.MemberAssign GetModel(int AssignId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AssignId,MemberId,ManagerId,Creator,CreateTime from MemberAssign ");
strSql.Append(" where AssignId=SQL2012AssignId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012AssignId", SqlDbType.Int, 4)
};
parameters[0].Value = AssignId;
abc.Model.Model.MemberAssign model = new abc.Model.Model.MemberAssign();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 获得前几行数据
/// </summary>
public DataSet GetList(int Top, string strSelect, string strWhere, string filedOrder)
{
if (strSelect != "")
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (Top > 0)
{
strSql.Append(" top " + Top.ToString());
}
strSql.Append(strSelect);
strSql.Append(" FROM td_standard_price ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
strSql.Append(" order by " + filedOrder);
return(DbHelperSQL.Query(strSql.ToString()));
}
else
{
return(GetList(Top, strWhere, filedOrder));
}
}
/// <summary>
/// 获得訂單贈品ID列表,以逗號分割
/// </summary>
public string GetGiftList(int orderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,gift_id ");
strSql.Append(" FROM " + databaseprefix + "order_gift ");
strSql.Append(" where order_id=" + orderID.ToString());
strSql.Append(" order by id desc");
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
if (dt.Rows.Count > 0)
{
string returnStr = "0";
foreach (DataRow dr in dt.Rows)
{
returnStr += ("," + dr["gift_id"].ToString());
}
return(returnStr);
}
else
{
return("0");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.User.userspaybank GetModel(int userid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,userid,accoutType,pmode,account,payeeName,BankCode,payeeBank,provinceCode,bankProvince,cityCode,bankCity,bankAddress,status,AddTime,updateTime from userspaybank ");
strSql.Append(" where userid=@userid");
SqlParameter[] parameters =
{
new SqlParameter("@userid", SqlDbType.Int, 4)
};
parameters[0].Value = userid;
Model.User.userspaybank model = new Model.User.userspaybank();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public CardCenter.Entity.ManagerRoleOperation GetModel(Guid OperationId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OperationId,RoleId,MemuName,MemuCode,OperationCode,OperationName,OperationType,OperationNumber from ManagerRoleOperation ");
strSql.Append(" where OperationId=@OperationId ");
SqlParameter[] parameters =
{
new SqlParameter("@OperationId", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = OperationId;
CardCenter.Entity.ManagerRoleOperation model = new CardCenter.Entity.ManagerRoleOperation();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DNSABC.Model.DNSABC_ProductModelDns model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DNSABC_ProductModelDns(");
strSql.Append("ProductID,isHost,isTtl,isMonitor,isGroupID,Remark)");
strSql.Append(" values (");
strSql.Append("@ProductID,@isHost,@isTtl,@isMonitor,@isGroupID,@Remark)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductID", SqlDbType.Int, 4),
new SqlParameter("@isHost", SqlDbType.Int, 4),
new SqlParameter("@isTtl", SqlDbType.Int, 4),
new SqlParameter("@isMonitor", SqlDbType.Int, 4),
new SqlParameter("@isGroupID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 500)
};
parameters[0].Value = model.ProductID;
parameters[1].Value = model.isHost;
parameters[2].Value = model.isTtl;
parameters[3].Value = model.isMonitor;
parameters[4].Value = model.isGroupID;
parameters[5].Value = model.Remark;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MesWeb.Model.T_Report_Product_Standard GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,ConductorStruct,VerticalDia,EdgeDiaAvg,EdgeDiaMin,SheathAvg,SheathMin,Resistance,VoltageTest from T_Report_Product_Standard ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
MesWeb.Model.T_Report_Product_Standard model = new MesWeb.Model.T_Report_Product_Standard();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public MES.Server.Model.OQC_OrderPrintConfig GetModel(string OrderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,PackLot,PrintType,TriggerCount,LabName,LabPath,LabID from OQC_OrderPrintConfig ");
strSql.Append(" where OrderID=@OrderID ");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 50)
};
parameters[0].Value = OrderID;
MES.Server.Model.OQC_OrderPrintConfig model = new MES.Server.Model.OQC_OrderPrintConfig();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Maticsoft.Model.photos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into photos(");
strSql.Append("ContentType,postedFileFileName,FileName,fileExtension,qishu,fenlei2)");
strSql.Append(" values (");
strSql.Append("@ContentType,@postedFileFileName,@FileName,@fileExtension,@qishu,@fenlei2)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ContentType", SqlDbType.NVarChar, 50),
new SqlParameter("@postedFileFileName", SqlDbType.NVarChar, 50),
new SqlParameter("@FileName", SqlDbType.NVarChar, 50),
new SqlParameter("@fileExtension", SqlDbType.NVarChar, 50),
new SqlParameter("@qishu", SqlDbType.NVarChar, 50),
new SqlParameter("@fenlei2", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ContentType;
parameters[1].Value = model.postedFileFileName;
parameters[2].Value = model.FileName;
parameters[3].Value = model.fileExtension;
parameters[4].Value = model.qishu;
parameters[5].Value = model.fenlei2;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebDemo.Model.WebDemo.TaskPlan GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,TaskID,CollectorID,TaskName,CommandID,CommandInfo,MeterAddr,MeterType,MeterItem,FreezeDate,TaskMonth,TaskDay,TaskHour,TaskMinute,ExeMark,ExeDate,ExeError,TaskMark,TaskType,TaskError,TryNum,HostAddr,InsDate,MeterID,TaskFrequency,ExeInfo,OperatorID,DeptID,TaskWeek,PriceTypeID,ServerId,ExeType from TaskPlan ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
WebDemo.Model.WebDemo.TaskPlan model = new WebDemo.Model.WebDemo.TaskPlan();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Model.wx_hotel_dingdan GetModel(string outTradeNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,hotelid,openid,oderName,orderNumber,wxOrderNumber,identityNumber,tel,arriveTime,leaveTime,roomType,orderTime,orderNum,price,orderStatus,isDelete,createDate,roomid,yuanjia,remark from wx_hotel_dingdan ");
strSql.Append(" where orderNumber=@orderNumber and isDelete='0' ");
SqlParameter[] parameters =
{
new SqlParameter("@orderNumber", SqlDbType.VarChar, 50)
};
parameters[0].Value = outTradeNo;
WeiXinPF.Model.wx_hotel_dingdan model = new WeiXinPF.Model.wx_hotel_dingdan();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public XCWeiXin.Model.wx_message_blacklist GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,wid,openid,blacktime from wx_message_blacklist ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
XCWeiXin.Model.wx_message_blacklist model = new XCWeiXin.Model.wx_message_blacklist();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public IPSP.Model.TCstmr_AppChangeHistory GetModel(int n_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 n_ID,n_AppID,s_ChangeProject,s_ChangeFrom,s_ChangeTo,s_ChangeDate,s_Notes from TCstmr_AppChangeHistory ");
strSql.Append(" where n_ID=@n_ID");
SqlParameter[] parameters =
{
new SqlParameter("@n_ID", SqlDbType.Int, 4)
};
parameters[0].Value = n_ID;
IPSP.Model.TCstmr_AppChangeHistory model = new IPSP.Model.TCstmr_AppChangeHistory();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int CategoryId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "Category ");
strSql.Append(" where CategoryId=@CategoryId");
SqlParameter[] parameters =
{
new SqlParameter("@CategoryId", SqlDbType.Int, 4)
};
parameters[0].Value = CategoryId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
