| | |
|---|
| | | //Biz.Db.Fastest<WMS_WAREHOUSE>().BulkUpdate(data, new string[] { "ID" }, new string[] { "UPDATE_TIME", "UPDATE_USER" }); |
|---|
| | | //Biz.Db.Insertable(data, "Interface").ExecuteCommand(); |
|---|
| | | |
|---|
| | | var root = new SugarParameter("root", "system01"); |
|---|
| | | var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_SYS_GET_MENU", root);//返回dt |
|---|
| | | var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("SP_SYS_GET_MENU", root);//返回List |
|---|
| | | //var root = new SugarParameter("root", "system01"); |
|---|
| | | //var dt = Biz.Db.Ado.UseStoredProcedure().GetDataTable("SP_SYS_GET_MENU", root);//返回dt |
|---|
| | | //var data = Biz.Db.Ado.UseStoredProcedure().SqlQuery<SYS_MENU>("SP_SYS_GET_MENU", root);//返回List |
|---|
| | | ; |
|---|
| | | //var data = Biz.Db.Queryable<BIZ_SRM_DLVY>() |
|---|
| | | // .IncludesAllFirstLayer() |
|---|
| | |
|---|
| | | //{ |
|---|
| | | // throw dbTran.ErrorException; |
|---|
| | | //} |
|---|
| | | |
|---|
| | | var data = Biz.Db.Queryable<BIZ_U9_ASN>().Where(q => q.ORDER_NO.Contains(param.IsNullOrEmpty("没有单号不查询ASN单"))).Select(q => q.ID).ToList().IsNullOrEmpty(new() { "查询不到ASN单" }); |
|---|
| | | return Ok(data); |
|---|
| | | } |
|---|
| | | /// <summary> |
|---|
