/// <summary>
/// 根据选择商品类型列出商品数据
/// </summary>
/// <param name="PageCount"></param>
/// <param name="Counts"></param>
/// <param name="StrCondition"></param>
/// <param name="PageIndex"></param>
/// <param name="PageSize"></param>
/// <param name="SortField"></param>
/// <param name="Sort"></param>
/// <param name="ID"></param>
/// <param name="CorpID"></param>
/// <param name="CommunityId"></param>
/// <param name="SearchType"></param>
/// <param name="SearchColumnName"></param>
/// <returns></returns>
internal static DataSet GetResourcesTypeList(out int PageCount, out int Counts, string StrCondition, int PageIndex, int PageSize, string SortField, int Sort, string ID, string CorpID, string CommunityId, string SearchType, string SearchColumnName)
{
PageCount = 0;
Counts = 0;
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@FldName", "*");
parameters.Add("@PageSize", PageSize);
parameters.Add("@PageIndex", PageIndex);
parameters.Add("@FldSort", SortField);
parameters.Add("@Sort", Sort);
parameters.Add("@StrCondition", StrCondition);
parameters.Add("@Id", ID);
parameters.Add("@PageCount", PageCount);
parameters.Add("@Counts", Counts);
parameters.Add("@CorpID", CorpID);
parameters.Add("@CommunityId", CommunityId);
parameters.Add("@SearchType", SearchType);
parameters.Add("@SearchColumnName", SearchColumnName);
DataSet Ds = con.ExecuteReader("Proc_Tb_Resources_Details_TurnPage_Type", parameters, null, null, CommandType.StoredProcedure).ToDataSet();
return(Ds);
}
/// <summary>
/// 物业订单收款
/// </summary>
/// <param name="CommunityId"></param>
/// <param name="OrderId"></param>
/// <param name="respCode"></param>
/// <param name="respmsg"></param>
/// <returns></returns>
public static string ReceProperyOrder(string CommunityId, string out_trade_no)
{
try
{
//构建链接字符串
string strcon = PubConstant.GetConnectionString("APPConnection");
IDbConnection conn = new SqlConnection(strcon);
string query = "SELECT * FROM Tb_OL_AlipayOrder WHERE out_trade_no=@out_trade_no";
Tb_OL_AlipayOrder T_Order = conn.Query <Tb_OL_AlipayOrder>(query, new { out_trade_no = out_trade_no }).SingleOrDefault();
if (T_Order.IsSucc.ToString() == "1")
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"Result\":\"false\",");
sb.Append("\"data\":");
sb.Append("\"物业订单已下账\"");
sb.Append("}");
return(sb.ToString());
}
else
{
ReceFees(CommunityId, out_trade_no);
StringBuilder sb = new StringBuilder();
sb.Append("{\"Result\":\"true\",");
sb.Append("\"data\":");
sb.Append("\"下账成功\"");
sb.Append("}");
return(sb.ToString());
}
}
catch (Exception E)
{
return(E.Message.ToString());
}
}
/// <summary>
/// 根据调用类型进行密钥分支
/// </summary>
/// <param name="MacType"></param>
private RSAHelperBGY(string MacType)
{
switch (MacType)
{
//银联
case "UnionPay":
//私钥
string UnionPayPrivatekey = File.ReadAllText(@"D:\rsa_private_key.pem").Replace("\n", "");
UnionPayPrivatekey = UnionPayPrivatekey.Replace("-----BEGIN RSA PRIVATE KEY-----", "").Replace("-----END RSA PRIVATE KEY-----", "");
Privatekey = UnionPayPrivatekey;
//公钥
string UnionPayPublickey = File.ReadAllText(@"D:\rsa_public_key.pem").Replace("\n", "");
UnionPayPublickey = UnionPayPublickey.Replace("-----BEGIN PUBLIC KEY-----", "").Replace("-----END PUBLIC KEY-----", "");
Publickey = UnionPayPublickey;
break;
default:
//私钥
UnionPayPrivatekey = File.ReadAllText(PubConstant.GetAppSetString("UnionPayPrivatekey").ToString()).Replace("\n", "");
UnionPayPrivatekey = UnionPayPrivatekey.Replace("-----BEGIN RSA PRIVATE KEY-----", "").Replace("-----END RSA PRIVATE KEY-----", "");
Privatekey = UnionPayPrivatekey;
//公钥
UnionPayPublickey = File.ReadAllText(PubConstant.GetAppSetString("UnionPayPublickey").ToString()).Replace("\n", "");
UnionPayPublickey = UnionPayPublickey.Replace("-----BEGIN PUBLIC KEY-----", "").Replace("-----END PUBLIC KEY-----", "");
Publickey = UnionPayPublickey;
break;
}
_privateKeyRsaProvider = CreateRsaProviderFromPrivateKey(Privatekey);
_publicKeyRsaProvider = CreateRsaProviderFromPublicKey(Publickey);
_privateKeySize = _privateKeyRsaProvider.KeySize / 8;
_publicKeySize = _publicKeyRsaProvider.KeySize / 8;
}
/// <summary>
/// 获取所有存在商品的商品类别
/// </summary>
/// <param name="sql"></param>
/// <returns></returns>
internal static DataSet GetResourcesType(string sql)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
DataSet ds = con.ExecuteReader(sql, null, null, null, CommandType.Text).ToDataSet();
return(ds);
}
//取消下帐
public static string NoAliUnderAccount(string CommunityId, string OrderId)
{
try
{
//构建链接字符串
string strcon = PubConstant.GetConnectionString("APPConnection");
IDbConnection conn = new SqlConnection(strcon);
string query = "SELECT * FROM Tb_OL_UnionPayOrder WHERE orderId=@OrderId";
Tb_OL_UnionPayOrder T_Order = conn.Query <Tb_OL_UnionPayOrder>(query, new { orderId = OrderId }).SingleOrDefault();
if (T_Order.IsSucc.ToString() == "0")
{
return("物业账单未下账");
}
conn.Dispose();
conn = new SqlConnection(strcon);
//更改状态
T_Order.IsSucc = 1;
conn.Update <Tb_OL_UnionPayOrder>(T_Order);
return("success");
}
catch (Exception E)
{
return(E.Message.ToString());
}
}
/// <summary>
/// 退出登录
/// </summary>
/// <returns></returns>
public ActionResult LoginOut()
{
var cookieName = System.Configuration.ConfigurationManager.AppSettings["cookie_name"].ToString();
CookieHelper.DelCookie(cookieName);
return(Redirect(PubConstant.WineGameShowUrl("login", "index")));
}
/// <summary>
/// 获取购物车明细试图
/// </summary>
/// <param name="sqlstr"></param>
/// <returns></returns>
internal static DataTable GetShoppingDetailedView(string sqlstr)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
DataSet ds = con.ExecuteReader("SELECT S.Id,S.ShoppingId,S.Number,S.SubtotalMoney,S.Propertys,R.* FROM Tb_ShoppingDetailed AS S INNER JOIN Tb_Resources_Details AS R ON S.ResourcesID = R.ResourcesID where ISNULL(S.IsDelete,0)=0 " + sqlstr, null, null, null, CommandType.Text).ToDataSet();
return(ds.Tables[0]);
}
/// <summary>
/// 生成物业订单处理过程
/// </summary>
/// <param name="CustId"></param>
/// <param name="FeesIds"></param>
/// <param name="CommID"></param>
/// <param name="Memo"></param>
/// <param name="merId"></param>
/// <param name="txnTime"></param>
/// <param name="CommunityId"></param>
/// <returns></returns>
public DataSet PropertyOrder(string CustId, string FeesIds, string CommID, string Memo, string merId, string txnTime, string CommunityId)
{
//构建链接字符串
string strcon = PubConstant.GetConnectionString("APPConnection");
SqlParameter[] parameters =
{
new SqlParameter("@CustId", SqlDbType.VarChar),
new SqlParameter("@FeesIds", SqlDbType.VarChar),
new SqlParameter("@CommID", SqlDbType.VarChar),
new SqlParameter("@merId", SqlDbType.VarChar),
new SqlParameter("@txnTime", SqlDbType.VarChar),
new SqlParameter("@CommunityId", SqlDbType.VarChar),
new SqlParameter("@Memo", SqlDbType.VarChar)
};
parameters[0].Value = CustId;
parameters[1].Value = FeesIds;
parameters[2].Value = CommID;
parameters[3].Value = merId;
parameters[4].Value = txnTime;
parameters[5].Value = CommunityId;
parameters[6].Value = Memo;
DataSet Ds = new DbHelperSQLP(strcon).RunProcedure("Proc_OL_GenerateOrder_AliPay", parameters, "Ds");
return(Ds);
}
/// <summary>
/// 查询购物车中是否有此物品
/// </summary>
/// <param name="Id"></param>
/// <param name="ResourcesID"></param>
/// <returns></returns>
internal static List <Tb_ShoppingCar> GetShoppingCheck(string Id, string ResourcesID)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
List <Tb_ShoppingCar> m = con.Query <Tb_ShoppingCar>("select * from Tb_ShoppingCar where UserId=@UserId and ResourcesID=@ResourcesID and ISNULL(IsDelete,0)=0", new { UserId = Id, ResourcesID = ResourcesID }).ToList <Tb_ShoppingCar>();
return(m);
}
/// <summary>
/// 查询购物车明细中规格
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static DataSet GetShoppingDetailedCheck(string Id, string Propertys)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
DataSet ds = con.ExecuteReader("select * from Tb_ShoppingDetailed where ShoppingId='" + Id + "' and PropertysId in (" + Propertys + ")", null, null, null, CommandType.Text).ToDataSet();
return(ds);
}
/// <summary>
/// 获取单个购物车明细
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static Tb_ShoppingCar GetShoppingDetailedModel(string Id)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_ShoppingCar m = con.Query <Tb_ShoppingCar>("select * from Tb_ShoppingCar where Id=@Id and ISNULL(IsDelete,0)=0", new { Id = Id }).SingleOrDefault <Tb_ShoppingCar>();
return(m);
}
/// <summary>
/// 获取购物车明细
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static List <Tb_ShoppingDetailed> GetShoppingDetailedList(string Id)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
List <Tb_ShoppingDetailed> list = con.Query <Tb_ShoppingDetailed>("select * from Tb_ShoppingDetailed where ShoppingId=@ShoppingId and ISNULL(IsDelete,0)=0", new { ShoppingId = Id }).ToList <Tb_ShoppingDetailed>();
return(list);
}
/// <summary>
/// 商品查询
/// </summary>
/// <param name="Id">ID查询商品</param>
/// <returns></returns>
internal static Tb_Resources_Details GetResourcesModel(string Id)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_Resources_Details m = con.Query <Tb_Resources_Details>("select * from dbo.Tb_Resources_Details where ResourcesID=@UserId and isnull( IsDelete,0)=0", new { UserId = Id }).SingleOrDefault <Tb_Resources_Details>();
return(m);
}
/// <summary>
/// 查询购物车
/// </summary>
/// <param name="UserId">用户编码</param>
/// <returns></returns>
internal static Tb_ShoppingCar GetShoppingCarModel(string UserId)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_ShoppingCar m = con.Query <Tb_ShoppingCar>("select * from dbo.Tb_ShoppingCar where UserId=@UserId and isnull( IsDelete,0)=0", new { UserId = UserId }).SingleOrDefault <Tb_ShoppingCar>();
return(m);
}
/// <summary>
/// 获取订单实体
/// </summary>
/// <param name="ReceiptCode"></param>
/// <returns></returns>
public static Tb_Charge_Receipt GetChargeReceiptModel(string ReceiptCode)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_Charge_Receipt m = con.Query <Tb_Charge_Receipt>("select * from Tb_Charge_Receipt where Id=@ReceiptCode", new { ReceiptCode = ReceiptCode }).SingleOrDefault <Tb_Charge_Receipt>();
return(m);
}
/// <summary>
/// 生成物业订单
/// </summary>
/// <param name="CommunityId"></param>
/// <param name="FeesIds"></param>
/// <param name="txnTime"></param>
/// <param name="CustID"></param>
/// <param name="Memo"></param>
/// <param name="Row"></param>
/// <param name="IsOk">是否成功生成物业代收订单</param>
/// <param name="Amount">订单总金额</param>
/// <param name="PropertyOrderId"></param>
/// <returns></returns>
public string GeneratePropertyOrder(string CommunityId, string FeesIds, string txnTime, string CustID, string Memo, ref bool IsOk, ref string Amount, ref string PropertyOrderId)
{
//构建链接字符串
string strcon = PubConstant.GetConnectionString("APPConnection");
////增加订单验证【检测费用是否存在于未下帐订单明细中】
//List<string> list = CheckFees(FeesIds, strcon);
//if (list.Count > 0)
//{
// string str = "";
// foreach (string item in list)
// {
// str += item + ",";
// }
// return "费项：" + str + "已支付成功，等待下帐！";
//}
//生成物业订单
DataSet Ds = PropertyOrder(CustID, FeesIds, CommunityId, Memo, c.seller_id.ToString(), txnTime, CommunityId);
if (Ds.Tables.Count > 0)
{
DataRow DRow = Ds.Tables[0].Rows[0];
Amount = DRow["Amount"].ToString();//总金额
IsOk = true;
PropertyOrderId = DRow["orderId"].ToString();
return("生成物业账单成功");
}
else
{
IsOk = false;
return("生成物业账单失败,请检查选择的费用是否未提交,如若有未交款费项的订单,请先取消订单");
}
}
/// <summary>
/// 获取收货地址
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static Tb_User_Address GetAddressModel(string Id)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_User_Address m = con.Query <Tb_User_Address>("select * from Tb_User_Address where Id=@Id", new { Id = Id }).SingleOrDefault <Tb_User_Address>();
return(m);
}
private string GetCustID(string RoomID)
{
string strcon = PubConstant.GetConnectionString("APPConnection");
string custid = new DbHelperSQLP(strcon).GetSingle("select CustID from Tb_HSPR_CustomerLive where IsActive=1 and RoomID=" + RoomID).ToString();
return(custid);
}
/// <summary>
/// 获取商品属性例如颜色
/// </summary>
/// <param name="BussId"></param>
/// <param name="ResourcesID"></param>
/// <returns></returns>
internal static DataSet GetResourcesProperty(string BussId, string ResourcesID)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
string sql = "select r.BussId,r.ResourcesID,p.PropertyName,p.Id from Tb_Resources_PropertyRelation as r inner join Tb_Resources_Property as p on r.PropertyId = p.Id where r.BussId='" + BussId + "' and r.ResourcesID='" + ResourcesID + "' order by p.Sort asc ";
return(con.ExecuteReader(sql, null, null, null, CommandType.Text).ToDataSet());
}
/// <summary>
/// 配置支付请求参数,根据当前小区获取【仅供验签使用】
/// </summary>
/// <param name="Row"></param>
public bool GenerateConfig(string CommunityId, out SDKConfig con)
{
//构建链接字符串
string strcon = PubConstant.GetConnectionString("APPConnection");
DataTable CertificateTable = new DbHelperSQLP(strcon).Query("SELECT * FROM Tb_UnionPayCertificate WHERE CommunityId='" + DataSecurity.FilteSQLStr(CommunityId) + "'").Tables[0];
SDKConfig c = new SDKConfig();
con = c;
if (CertificateTable.Rows.Count > 0)
{
DataRow DRow = CertificateTable.Rows[0];
//获取配置参数
con.signCertPath = DRow["signCertPath"].ToString();
con.signCertPwd = DRow["signCertPwd"].ToString();
con.validateCertDir = DRow["validateCertDir"].ToString();
con.encryptCert = DRow["encryptCert"].ToString();
con.merId = DRow["merId"].ToString();
con.AccNo = DRow["AccNo"].ToString();
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取商品规格例如：红、黄、蓝
/// </summary>
/// <param name="PrepertyId"></param>
/// <returns></returns>
internal static DataSet GetGetResourcesProperty(string PrepertyId)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
string sql = "select Id,PropertyId,SpecName from Tb_Resources_Specifications where PropertyId='" + PrepertyId + "' order by Sort asc";
return(con.ExecuteReader(sql, null, null, null, CommandType.Text).ToDataSet());
}
protected void Application_End()
{
Thread.Sleep(1000);
string url = PubConstant.GetConnectionString("homeUrl");
//#if Debug
//#endif
//#if P17
// url = "http://192.168.1.17:9005/Base/Default";
//#endif
//#if Test
// url = "http://ttt.515.com/Base/Default";
//#endif
//#if Release
// url = "http://qqq.515.com/Base/Default";
//#endif
string[] urls = url.Split(',');
for (int i = 0; i < urls.Length; i++)
{
string u = urls[i];
HttpWebRequest Request = (HttpWebRequest)WebRequest.Create(u);
HttpWebResponse Response = (HttpWebResponse)Request.GetResponse();
Stream receiveStream = Response.GetResponseStream();//得到回写的字节流
}
}
public Alipay_Xxw() //获取小区、项目信息
{
base.Token = "20170416Alipay_Xxw";
c = new Config();
//从配置文件获取支付报返回通知地址
c.notify_url = PubConstant.GetConnectionString("AliPayBackURL");
}
/// <summary>
/// 小区是否支持红色物业
/// </summary>
/// <param name="row"></param>
/// <param name="trans"></param>
/// <returns></returns>
private string CheckRedWuYeInfo(DataRow row, Transfer trans)
{
string result = "0";
if (!row.Table.Columns.Contains("CommunityId") && String.IsNullOrEmpty(row["CommunityId"].ToString()))
{
return(result);
}
string CommunityId = row["CommunityId"].ToString();
string sql = string.Format("select CommID from Tb_Community where Id='{0}'", row["CommunityId"].ToString());
DataTable dTable = new DbHelperSQLP(PubConstant.GetConnectionString("UnifiedConnectionString")).Query(sql.ToString()).Tables[0];
if (dTable.Rows.Count > 0)
{
string CommID = dTable.Rows[0]["CommID"].ToString();
if (!string.IsNullOrEmpty(CommID))
{
string haveRedWuYe = Global_Fun.AppWebSettings("HaveRedWuYeCommID").ToString();
if (!string.IsNullOrEmpty(haveRedWuYe))
{
if (haveRedWuYe.Contains(CommunityId))
{
result = "1";
}
}
}
}
return(result);
}
/// <summary>
/// 获取符合要求的样品详情
/// </summary>
/// <param name="model">查询实体</param>
/// <returns>返回对应实体信息</returns>
public E_tb_ExpePlan GetExpePlanInfo(E_tb_ExpePlan model)
{
StringBuilder strWhere = new StringBuilder();
if (model.SampleID > 0) //样品ID
{
strWhere.AddWhere($"SampleID={model.SampleID}");
}
if (model.ProjectID > 0) //项目ID
{
strWhere.AddWhere($"ProjectID={model.ProjectID}");
}
if (!string.IsNullOrEmpty(model.TaskNo)) //样品编号
{
strWhere.AddWhere($"TaskNo='{model.TaskNo}'");
}
StringBuilder strSql = new StringBuilder();
strSql.Append($@"select top 1 * from tb_ExpePlan {strWhere.ToString()}");
using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString()))
{
model = conn.Query <E_tb_ExpePlan>(strSql.ToString(), model)?.FirstOrDefault();
}
return(model);
}
public string RefreshOrder(string CommunityId, string out_trade_no)
{
string strcon = PubConstant.GetConnectionString("APPConnection");
string BankResult = SearchBankOrder(CommunityId, out_trade_no);
IDbConnection conn = new SqlConnection(strcon);
string query = "SELECT * FROM Tb_OL_WeiXinOrder WHERE out_trade_no=@out_trade_no";
Tb_OL_WeiXinPayOrder T_Order = conn.Query <Tb_OL_WeiXinPayOrder>(query, new { out_trade_no = out_trade_no }).SingleOrDefault();
if (BankResult == "00")
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "成功");
if (T_Order.IsSucc.ToString() != "1")
{
//下账
ReceProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString());
return(JSONHelper.FromString(true, "订单状态已更新并下账成功，请刷新订单"));
}
else
{
return(JSONHelper.FromString(true, "订单状态已更新,请刷新订单"));
}
}
else
{
//更新订单状态
UpdateProperyOrder(T_Order.CommunityId.ToString(), T_Order.out_trade_no.ToString(), BankResult, "失败");
}
return("");
}
protected void Session_End(object sender, EventArgs e)
{
//下面的代码是关键，可解决IIS应用程序池自动回收的问题
System.Threading.Thread.Sleep(1000);
//触发事件, 写入提示信息
TaskAction.SetContent();
//这里设置你的web地址，可以随便指向你的任意一个aspx页面甚至不存在的页面，目的是要激发Application_Start
//使用您自己的URL
//#if DEBUG
// string url = "http://localhost:25664//api/OnLinePlay/GetOnLineUser?pageSize=112&pageIndex=1";
//#endif
//#if R17
// string url = "http://192.168.1.17:8017/api/OnLinePlay/GetOnLineUser?pageSize=112&pageIndex=1";
//#endif
//#if Release
// string url = "http://api.515.com/api/OnLinePlay/GetOnLineUser?pageSize=10&pageIndex=1";
//#endif
//#if Test
// string url = "http://tapi.515.com/api/OnLinePlay/GetOnLineUser?pageSize=10&pageIndex=1";
//#endif
string url = PubConstant.GetConnectionString("homeUrl");
System.Net.HttpWebRequest myHttpWebRequest = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(url);
System.Net.HttpWebResponse myHttpWebResponse = (System.Net.HttpWebResponse)myHttpWebRequest.GetResponse();
System.IO.Stream receiveStream = myHttpWebResponse.GetResponseStream();//得到回写的字节流
// 在会话结束时运行的代码。
// 注意: 只有在 Web.config 文件中的 sessionstate 模式设置为 InProc 时，才会引发 Session_End 事件。
// 如果会话模式设置为 StateServer
// 或 SQLServer，则不会引发该事件。
}
/// <summary>
/// 清空购物车 DelShoppingCarAll
/// </summary>
/// <param name="row"></param>
/// UserId 用户编码【必填】
/// 返回：
/// true:
/// false:删除失败
/// <returns></returns>
private string DelShoppingCarAll(DataRow row)
{
if (!row.Table.Columns.Contains("UserId") || string.IsNullOrEmpty(row["UserId"].ToString()))
{
return(JSONHelper.FromString(false, "用户编码不能为空"));
}
string str = "";
try
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
//批量删除购物车明细
con.ExecuteScalar(" update Tb_ShoppingCar set IsDelete=1 where UserId=@ShoppingId", new { ShoppingId = row["UserId"].ToString() }, null, null, CommandType.Text);
}
catch (Exception ex)
{
str = ex.Message;
}
if (str != "")
{
return(JSONHelper.FromString(false, str));
}
else
{
return(JSONHelper.FromString(true, ""));
}
}
/// <summary>
/// 获取人员列表
/// </summary>
/// <param name="model">查询参数实体</param>
/// <returns>返回人员列表集合</returns>
public List <E_tb_InPersonnel> GetList(E_tb_InPersonnel model)
{
List <E_tb_InPersonnel> list = new List <E_tb_InPersonnel>();
//拼接查询条件
StringBuilder strwhere = new StringBuilder();
strwhere.AddWhere($"isdelete=0"); //未删除数据
if (model.AreaID > 0) //区域ID
{
strwhere.AddWhere($"AreaID={model.AreaID}");
}
//主查询Sql
StringBuilder search = new StringBuilder();
search.AppendFormat(@"select * from tb_InPersonnel {0} ", strwhere.ToString());
//执行查询语句
using (IDbConnection conn = new SqlConnection(PubConstant.GetConnectionString()))
{
list = conn.Query <E_tb_InPersonnel>(search.ToString(), model)?.ToList();
}
return(list);
}
public DBOperationManagment()
{
if (string.IsNullOrEmpty(defaultConnectStr))
{
defaultConnectStr = PubConstant.ConnectionString();
}
sqlHelper = new DbHelperSQL(defaultConnectStr);
}
