public AdvertisementRepository()
{
DbContext.Init(BaseDBConfig.ConnectionString);
context = DbContext.GetDbContext();
db = context.Db;
entityDB = context.GetEntityDB <Advertisement>(db);
}
public UserInfoserve(IUnitOfWork unitOfWork, IBaseRepository <sysUserInfo> dal,
IBaseRepository <Role> roleRepository, IMapper mapper)
{
this._Db = unitOfWork.GetDbClient();
this.BaseDal = dal;
this._roleRepository = roleRepository;
this._mapper = mapper;
}
private void Btn_login_Click(object sender, EventArgs e)
{
Toast.MakeText(this, "开始登录吧！", ToastLength.Short).Show();
SqlSugar.SqlSugarClient db = Common.SqliteHelp.GetInstance();
var insertObj = new Models.UserInfo {
UserName = "******", Pwd = "123"
};
int dd = db.Insertable(insertObj).ExecuteCommand();
}
public (bool isOpen, SqlSugar.ISqlSugarClient client) OpenDatabase(string connectString)
{
try
{
SqlSugar.ISqlSugarClient conn = new SqlSugar.SqlSugarClient(new SqlSugar.ConnectionConfig {
ConnectionString = connectString, DbType = SqlSugar.DbType.MySql, IsAutoCloseConnection = true, InitKeyType = SqlSugar.InitKeyType.Attribute
});
conn.Open();
return(true, conn);
}
catch
{
return(false, null);
}
}
public UserInfoDAL()
{
db = SugarDao.GetInstance();
}
public LiveChatRoomMemberDAL()
{
db = SugarDao.GetInstance();
}
private static int GetCount(SqlSugar.SqlSugarClient db)
{
return(db.Queryable <Order>().Count());
}
public LiveDataDAL()
{
db = SugarDao.GetInstance();
}
public void Create(FormCollection collection)
{
var msg = new Msg();
SqlSugar.SqlSugarClient Db = null;
try
{
var rate = new Rates().GetLast();
// 验证费率信息
var quota = new Quotas().GetLast();
if (rate == null)
{
throw new Exception("请先设置费率信息");
}
///1.获取数据
var cold_water_value = Convert.ToSingle(collection["cold_water_value"]);
var hot_water_value = Convert.ToSingle(collection["hot_water_value"]);
var electric_value = Convert.ToSingle(collection["electric_value"]);
///1.1判断输入数值
if (cold_water_value < 0 || hot_water_value < 0 || electric_value < 0)
{
throw new Exception("数值输入有误，费用不能小于0");
}
var Dorm_id = Convert.ToInt32(collection["dorm_id"]); // 园区ID
var Building_id = Convert.ToInt32(collection["building_id"]); // 宿舍楼ID
var Pid = Convert.ToInt32(collection["pid"]); // 宿舍ID
var Note = collection["note"];
if (Dorm_id < 0 || Building_id < 0 || Pid < 0)
{
throw new Exception("宿舍ID或宿舍楼ID或园区ID输入有误");
}
if (Note.Trim().Length < 3)
{
throw new Exception("手动添加账单时请输入至少3个字符作为说明");
}
/// 生成一个虚拟用量登记
var used = new T_Used()
{
Used_room_id = Pid,
Used_note = "手动添加账单后自动生成的登记信息，并不会更新读表数据",
Used_building_id = Building_id,
Used_dorm_id = Dorm_id,
Used_post_user_id = (int)Session["id"],
};
/// 开始事务
Db = new DbContext().Db;
Db.Ado.BeginTran();
var u = Db.Insertable(used).ExecuteReturnIdentity();
/// 生成账单
var bill = new T_Bill()
{
Bill_note = Note,
Bill_used_id = u,
Bill_room_id = Pid,
Bill_building_id = Building_id,
Bill_dorm_id = Dorm_id,
Bill_cold_water_cost = (decimal)cold_water_value,
Bill_electric_cost = (decimal)hot_water_value,
Bill_hot_water_cost = (decimal)electric_value,
Bill_rates_id = rate.Rate_id,
Bill_quota_id = quota.Quota_id,
};
/// 保存账单
if (Db.Insertable(bill).ExecuteCommand() < 1)
{
throw new Exception("添加账单信息时发生错误！");
}
Db.Ado.CommitTran();// 提交事务
msg.Message = "添加成功！";
}
catch (Exception ex)
{
//发生错误，回滚事务
if (Db != null)
{
Db.Ado.RollbackTran();
}
msg.Code = -1;
msg.Message = ex.Message;
}
Response.Write(msg.ToJson());
Response.End();
}
public MemberQuery(IBaseQueryRepository baseRepository)
{
_db = baseRepository.Context;
}
//初始化list页面
public override ActionResult GetList()
{
GridRequest req = new GridRequest(Request);
int iCount = req.PageCondition.RowCount;
string strSql = Request["strSql"];
// var mq = System.Text.RegularExpressions.Regex.Matches(strSql, @"select (.*?) from (\w*) (where (.*?))? ");
string txtConn = Request["txtConn"];
if (strSql.IndexOf("select") == 0)
{
string sql = @" select top {0} * from
(
select row_number() over(order by id) as rownumber,* from ({2}) _a
) A
where rownumber > {1}";
sql = string.Format(sql, req.PageCondition.PageSize, Request["start"], strSql);
//
string list3;
string str;
using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString))
{
// list3 = db.SqlQueryDynamic(sql);
if (req.PageCondition.RowCount == 0)
{
req.PageCondition.RowCount = db.GetInt(string.Format("select count(*) from ({0}) a", strSql));
}
str = db.SqlQueryJson(sql);
list3 = Newtonsoft.Json.JsonConvert.SerializeObject(new
{
sEcho = Request["draw"],
iTotalRecords = req.PageCondition.RowCount,
iTotalDisplayRecords = req.PageCondition.RowCount,
aaData = "##"
});
str = list3.Replace("\"##\"", str);
}
return(Content(str, "application/json"));
}
else
{
//sql = strSql;
// var rep = _BaseService.Repository.SqlExcute(strSql, 1);
using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString))
{
db.ExecuteCommand(strSql);
}
return(SuccessNotification(""));
}
//实现对用户和多条件的分页的查询，rows表示一共多少条，page表示当前第几页
// var list = GetListEx(predicate, req.PageCondition);// _newsService.GetList(null, null, 10, 10);
}
public ActionResult GetListFirst()
{
string strSql = Request["strSql"];
// var mq = System.Text.RegularExpressions.Regex.Matches(strSql, @"select (.*?) from (\w*) (where (.*?))? ");
string sql = @"select top 1 * from ( {0}) a";
sql = string.Format(sql, strSql);
// dynamic rep = _BaseService.Repository.UnitOfWork.SqlQuery<List<dynamic>>(sql, 1).ToList();
string txtConn = Request["txtConn"];
object list3;
string str;
List <object> aa;
using (var db = new SqlSugar.SqlSugarClient(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString))
{
str = db.SqlQueryJson(sql);
// list3 = db.SqlQueryDynamic(sql);
aa = Newtonsoft.Json.JsonConvert.DeserializeObject <List <object> >(str);
}
var dd = (aa[0].GetType()).GetProperties(System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.DeclaredOnly)[0];
var ddd = (Collection <JToken>)dd.GetValue(aa[0]);
StringBuilder sb = new StringBuilder();
foreach (var dddd in ddd)
{
dynamic da = dddd;
sb.AppendFormat(",{0}", da.Name);
}
if (!string.IsNullOrEmpty(str))
{
return(Content(sb.ToString().Substring(1)));
}
else
{
return(Content(""));
}
//using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[txtConn].ConnectionString))
//{
// connection.Open();
// brand = connection.Query<dynamic>(sql).ToList();
//}
//return Content(str, "application/json");
//return Json(list3, JsonRequestBehavior.AllowGet);
// return Content(str);
//实现对用户和多条件的分页的查询，rows表示一共多少条，page表示当前第几页
// var list = GetListEx(predicate, req.PageCondition);// _newsService.GetList(null, null, 10, 10);
}
