public ActionResult SaveNewTicket(TicketCreateVM createModel)
{
try
{
using (var dbContext = new TicketCodeTestDBContext())
{
var dbTicket = new Tticket();
var dbCustom = new Tcustomer();
var dbBill = new Tbill();
dbCustom.Name = createModel.custormername;
dbCustom.SaleMan = createModel.saleman;
dbCustom.SaleCount = createModel.salecount;
dbCustom.SaleAmount = createModel.saleamount;
dbContext.Tcustomer.Add(dbCustom);
}
StringBuilder sbr = new StringBuilder();
DapperWrapper.Insert(sbr.ToString());
return(Json(new { success = true, msg = "保存成功" }));
}
catch (Exception ex)
{
return(Json(new
{
success = false,
msg = ex.ToString()
}));
}
}
public static void Start()
{
One one = new One();
Two two = new Two();
Three three = new Three();
Two_Parent parent = new Two_Parent();
//以实体类进行操作
DapperWrapper <Three, Two, One, Two_Parent> dapper1 = new DapperWrapper <Three, Two, One, Two_Parent>("key");
dapper1.SourceGet(one, two);
dapper1.SourceGets(one, two);
dapper1.SourceAdd(three, one, two);
dapper1.SourcePreDelete(three);
dapper1.SourceAftDelete(one, two);
dapper1.SourceModify(three, one, two);
dapper1.TableGet(one.oid, two.rid);
//以值进行操作
DapperWrapper <Three, Two, One> dapper2 = new DapperWrapper <Three, Two, One>("key");
dapper2.TableGet(one.oid);
dapper2.TableGets(one.oid);
dapper2.TableAdd(three.tid, one.oid);
dapper2.TablePreDelete(three.tid);
dapper2.TableAftDelete(one.oid);
dapper2.TableModify(three.tid, one.oid);
}
public static void Start()
{
VasilyRunner.Run();
Console.WriteLine(SqlEntity <One> .Table);
//table_one
Console.WriteLine(SqlEntity <One> .Primary);
//oid
Console.WriteLine(SqlEntity <One> .SelectAll);
//SELECT * FROM [table_one]
Console.WriteLine(SqlEntity <One> .SelectAllByPrimary);
//SELECT * FROM [table_one] WHERE [oid] = @oid
Console.WriteLine(SqlEntity <One> .SelectAllIn);
//SELECT * FROM [table_one] WHERE [oid] IN @keys
Console.WriteLine(SqlEntity <One> .SelectAllWhere);
//SELECT * FROM [table_one] WHERE
Console.WriteLine(SqlEntity <One> .UpdateAllByPrimary);
//UPDATE [table_one] SET [name]=@name,[create_time]=@create_time,[update_time]=@update_time,[age]=@age,[student_id]=@student_id WHERE [oid]=@oid
Console.WriteLine(SqlEntity <One> .UpdateAllWhere);
//UPDATE [table_one] SET [name]=@name,[create_time]=@create_time,[update_time]=@update_time,[age]=@age,[student_id]=@student_id WHERE
Console.WriteLine(SqlEntity <One> .DeleteByPrimary);
//DELETE FROM [table_one] WHERE [oid] = @oid
Console.WriteLine(SqlEntity <One> .DeleteWhere);
//DELETE FROM [table_one] WHERE
Console.WriteLine(SqlEntity <One> .InsertAll);
//INSERT INTO [table_one] ([name],[create_time],[update_time],[age],[student_id])VALUES(@name, @create_time, @update_time, @age, @student_id)
Console.WriteLine(SqlEntity <One> .RepeateCount);
//SELECT COUNT(*) FROM [table_one] WHERE [student_id] = @student_id
Console.WriteLine(SqlEntity <One> .RepeateEntities);
//SELECT * FROM [table_one] WHERE [student_id] = @student_id
Console.WriteLine(SqlEntity <One> .RepeateId);
//SELECT [oid] FROM [table_one] WHERE [student_id] = @student_id
Console.WriteLine(SqlEntity <One> .SelectCount);
//SELECT Count(*) FROM [table_one]
Console.WriteLine(SqlEntity <One> .SelectCountWhere);
//SELECT Count(*) FROM [table_one] WHERE
//操作对应的是DapperWrapper<One>
One one = new One();
DapperWrapper <One> dapper = new DapperWrapper <One>("key");
dapper.IsRepeat(one);
}
public static void Start()
{
VasilyRunner.Run();
Connector.Add <SqlConnection>("key", "链接字符串");
Connector.Add <SqlConnection>("key-wr", "读-链接字符串", "写-链接字符串");
Connector.AddRead <SqlConnection>("read1", "读-链接字符串");
Connector.AddWrite <SqlConnection>("write2", "写-链接字符串");
//创建driver的三种方式
//wrapper = wrapper1 = wrapper2
DapperWrapper <One> wrapper = new DapperWrapper <One>("key");
DapperWrapper <One> wrapper1 = "key";
var wrapper2 = DapperWrapper <One> .UseKey("key");
//wrapper4 = wrapper5 = wrapper6 = wrapper7
DapperWrapper <One> wrapper4 = new DapperWrapper <One>("read1", "write2");
DapperWrapper <One> wrapper5 = "key-wr | write2 ";
var wrapper6 = DapperWrapper <One> .UseKey("key-wr", "write2");
var wrapper7 = DapperWrapper <One> .UseKey("key-wr");
One one = new One();
One one1 = new One();
One one2 = new One();
//两种调用方式
//指定操作方式,RequestType赋值一次即可。
//RequestType默认为 Complete;
wrapper.RequestType = VasilyRequestType.Complete;
wrapper.GetAll();
//使用属性调用
wrapper.Complete.GetAll();
//获取所有元素
wrapper.GetAll();
wrapper.GetByPrimary(one);
wrapper.GetsIn(1, 2, 3, 4);
wrapper.GetIn(1);
wrapper.IsRepeat(one);
wrapper.NoRepeateAdd(one);
wrapper.GetNoRepeateId <int>(one);
wrapper.GetRepeates(one);
wrapper.ModifyByPrimary(one, one1, one2);
wrapper.Add(one, one1, one2);
wrapper.SingleDeleteByPrimary(1);
wrapper.EntitiesDeleteByPrimary(one, one1, one2);
//SafeInsert = NoRepeateInsert + GetNoRepeateId
wrapper.SafeAdd(one);
}
/// <summary>
/// 静态创建一个Link对象
/// </summary>
/// <param name="handler">DapperWrapper对象</param>
/// <returns></returns>
public static SqlLink <T> Load(DapperWrapper <T> handler)
{
SqlLink <T> instance = new SqlLink <T>();
instance._handler = handler;
instance._model = SqlModel <T> .CopyInstance();
return(instance);
}
public ActionResult GetSupplierName()
{
var ret = new List <object>();
var sql = "select distinct(orderstatus) from dbo.TSupplier";
var orderStatus = DapperWrapper.GetAll <int>(sql);
foreach (var item in orderStatus)
{
ret.Add(new { id = item, name = MapOrderStatus(item) });
}
return(Json(ret));
}
public ActionResult GetSupplierType()
{
var ret = new List <object>();
var sql = "select distinct(suppliertype) from dbo.supplier";
var dbSupplierTypes = DapperWrapper.GetAll <int>(sql);
foreach (var type in dbSupplierTypes)
{
ret.Add(new { id = type, name = type });
}
return(Json(ret));
}
public ActionResult QueryFinanceList(FinanceQueryViewModel queryModel)
{
var results = new List <FinanceViewModel>();
StringBuilder sbr = new StringBuilder();
if (queryModel.customname != null)
{
sbr.Append(" customname=" + queryModel.customname + " and");
}
if (queryModel.batchnumber != null)
{
sbr.Append(" batchnumber=" + queryModel.batchnumber + " and");
}
if (queryModel.returnpaystatus > 0)
{
sbr.Append(" returnpaystatus=" + "'" + queryModel.returnpaystatus + "'" + " and");
}
if (queryModel.billstatus > 0)
{
sbr.Append(" billstatus=" + "'" + queryModel.billstatus + "'" + " and");
}
var condition = sbr.ToString();
var sql = "select * from dbo.financeinfo";
if (!string.IsNullOrEmpty(condition))
{
sql += " where ";
sql += condition;
if (sql.Contains("and"))
{
var charArray = new char[] { 'a', 'n', 'd' };
sql = sql.TrimEnd(charArray);
}
}
var dbFinances = DapperWrapper.GetAll <Tfinance>(sql);
foreach (var item in dbFinances)
{
var financeVM = new FinanceViewModel();
#region convert db to viewmodel
var checkrow = "<a href=\"#\" onclick=\"checkFinance(this)\">查看</a>";
var editrow = "<a href=\"#\" onclick=\"editFinance(this)\">编辑</a>";
financeVM.operation = checkrow + " " + editrow;
#endregion
results.Add(financeVM);
}
return(Json(results));
}
public static void Start()
{
VasilyRunner.Run();
Console.WriteLine(RelationSql <Two, Two, One, Two_Parent> .Table);
//table_relation
Console.WriteLine(RelationSql <Two, Two, One, Two_Parent> .Primary);
//rid
Console.WriteLine(RelationSql <Two, Two, One, Two_Parent> .AddFromSource);
//INSERT INTO [table_relation] ([rid],[one_id],[parent_id])VALUES(@rid, @oid, @rid)
Console.WriteLine(RelationSql <Two, Two, One, Two_Parent> .AddFromTable);
//INSERT INTO [table_relation] ([rid],[one_id],[parent_id])VALUES(@rid, @one_id, @parent_id)
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .DeleteAftFromSource);
//DELETE FROM [table_relation] WHERE [one_id] = @oid AND [parent_id] = @rid
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .DeleteAftFromTable);
//DELETE FROM [table_relation] WHERE [one_id] = @one_id AND [parent_id] = @parent_id
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .DeletePreFromSource);
//DELETE FROM [table_relation] WHERE [three_id] = @tid
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .DeletePreFromTable);
//DELETE FROM [table_relation] WHERE [three_id] = @three_id
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .GetFromSource);
//SELECT [three_id] FROM [table_relation] WHERE [one_id] = @oid AND [parent_id] = @rid
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .GetFromTable);
//SELECT [three_id] FROM [table_relation] WHERE [one_id] = @one_id AND [parent_id] = @parent_id
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .ModifyFromSource);
//UPDATE [table_relation] SET [three_id] = @tid WHERE [one_id] = @oid AND [parent_id] = @rid
Console.WriteLine(RelationSql <Three, Two, One, Two_Parent> .ModifyFromTable);
//UPDATE [table_relation] SET [three_id] = @three_id WHERE [one_id] = @one_id AND [parent_id] = @parent_id
//操作对应的是DapperWrapper<Three, Two, One, Two_Parent>
DapperWrapper <Three, Two, One, Two_Parent> dapper = new DapperWrapper <Three, Two, One, Two_Parent>("key");
}
public VasilyController(string reader, string writter) : this()
{
driver = new DapperWrapper <T>(reader, writter);
c = new SqlCondition <T>();
}
public VasilyController(string key) : this()
{
driver = new DapperWrapper <T>(key);
c = new SqlCondition <T>();
}
public VasilyController(string reader, string writter) : base()
{
driver = new DapperWrapper <T, R, S1>(reader, writter);
}
public VasilyController(string key) : base()
{
driver = new DapperWrapper <T, R, S1>(key);
}
public ActionResult QueryTicketList(TicketQueryVM queryModel)
{
var results = new List <TicketViewModel>();
StringBuilder sbr = new StringBuilder();
if (queryModel.customername != null)
{
sbr.Append(" customername=" + queryModel.customername + " and");
}
if (queryModel.batchnumber != null)
{
sbr.Append(" batchnumber=" + queryModel.batchnumber + " and");
}
if (queryModel.ticketnumber != null)
{
sbr.Append(" ticketnumber=" + "'" + queryModel.ticketnumber + "'" + " and");
}
if (queryModel.ticketstatus != null)
{
sbr.Append(" ticketstatus=" + "'" + queryModel.ticketstatus + "'" + " and");
}
var condition = sbr.ToString();
var sql = "select * from dbo.ticketinfo";
if (!string.IsNullOrEmpty(condition))
{
sql += " where ";
sql += condition;
if (sql.Contains("and"))
{
var charArray = new char[] { 'a', 'n', 'd' };
sql = sql.TrimEnd(charArray);
}
}
var dbTickets = DapperWrapper.GetAll <Tticket>(sql);
foreach (var item in dbTickets)
{
var orderVM = new TicketViewModel();
#region convert db to viewmodel
using (var dbContext = new TicketCodeTestDBContext())
{
var efCustom = dbContext.Tcustomer.ToList().FirstOrDefault(n => n.Code == item.CustomerCode);
orderVM.customername = efCustom.Name;
orderVM.saleman = efCustom.SaleMan;
orderVM.batchnumber = item.Batch;
orderVM.salecount = efCustom.SaleCount.ToString();
orderVM.price = efCustom.Price.ToString();
orderVM.amount = efCustom.SaleAmount.ToString();
}
orderVM.ordertime = item.CreateTime.ToString();
orderVM.validitytime = item.ValidityStartTime.ToString() + item.ValidityEndTime.ToString();
orderVM.ticketnumbers = item.CouponRange;
orderVM.ticketstatus = MapTicketStatus(item.Status);
orderVM.operatorname = item.Operator;
var checkrow = "<a href=\"#\" onclick=\"checkTicket(this)\">查看</a>";
var editrow = "<a href=\"#\" onclick=\"editTicket(this)\">编辑</a>";
var managerow = "<a href=\"#\" onclick=\"manageTicket(this)\">管理劵码</a>";
orderVM.operation = checkrow + " " + editrow + " " + managerow;
#endregion
results.Add(orderVM);
}
return(Json(results));
}