public int fun2(string _assetExpression, out DataTable _table)
{
AppInit.Init();
string sql = string.Format(@"select Assets.assetsBarcode,
Assets.assetsName,
AssetsClass.assetsClassName assetsClassName,
Assets.assetsNo,
D.departmentName departmentName,
StoreSite.storeSiteName storeSiteName,
Assets.spec,
Assets.purchaseDate,
{1} DuetoDate,
A.userName usePeopleName,
B.userName keeperName,
(select departmentName from AppDepartment C where D.companyId=C.departmentId ) CompanyName
from Assets
left join AppDepartment D on D.departmentId=Assets.departmentId
left join StoreSite on StoreSite.storeSiteId=Assets.storeSiteId
left join AssetsUses on AssetsUses.assetsUsesId=Assets.assetsUsesId
left join AssetsClass on AssetsClass.assetsClassId=Assets.assetsClassId
left join EquityOwner on EquityOwner.equityOwnerId=Assets.equityOwnerId
left join ProjectManage on ProjectManage.projectManageId=Assets.projectManageId
left join AppUser A on A.userId=Assets.usePeople
left join AppUser B on B.userId=Assets.keeper where 1=1 {0}", _assetExpression, DuetoDateSql());
_table = AppMember.DbHelper.GetDataSet(sql).Tables[0];
_table.TableName = "Assets";
return(1);
}
[WebMethod] // 删除指定模板
public int fun10(int _class, string _LabelId)
{
AppInit.Init();
DataUpdate dbUpdate = new DataUpdate();
BarcodePrintRepository rep = new BarcodePrintRepository();
try
{
dbUpdate.BeginTransaction();
rep.DbUpdate = dbUpdate;
string labelType = "";
if (_class == 0)
{
labelType = "Z";
}
else
{
labelType = "C";
}
rep.DeleteStyle(labelType, _LabelId, "Print Tools Update");
dbUpdate.Commit();
return(1);
}
catch (Exception)
{
dbUpdate.Rollback();
return(0);
}
finally
{
dbUpdate.Close();
}
}
[WebMethod] // 取得所有模板数据.LabelId, LabelName, LabelContent, IsDefault
public int fun7(int _class, out DataTable _table)
{
AppInit.Init();
BarcodePrintRepository repository = new BarcodePrintRepository();
if (_class == 0)
{
_table = repository.GetLabelStyleByPrintTools("Z");
}
else
{
_table = repository.GetLabelStyleByPrintTools("C");
}
return(1);
}
public int fun5(int _class, out string _labelStyle)
{
AppInit.Init();
BarcodePrintRepository repository = new BarcodePrintRepository();
if (_class == 0)
{
_labelStyle = repository.GetLabelStyleByType("Z");
}
else
{
_labelStyle = repository.GetLabelStyleByType("C");
}
return(1);
}
public int fun4(string _storeSiteExpression, out DataTable _table)
{
AppInit.Init();
string sql = string.Format(@"select
StoreSite.storeSiteNo storeSiteNo,
StoreSite.storeSiteName storeSiteName,
T.storeSiteName parentStoreSiteName,
D.departmentName companyName
from StoreSite left join AppUser U1 on StoreSite.createId=U1.userId
left join AppUser U2 on StoreSite.updateId=U2.userId
left join StoreSite T on StoreSite.parentId=T.storeSiteId
left join AppDepartment D on StoreSite.companyId=D.departmentId
where 1=1 {0}", _storeSiteExpression);
_table = AppMember.DbHelper.GetDataSet(sql).Tables[0];
return(1);
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RegisterRoutes(RouteTable.Routes);
AppInit.Init();
AppLog.DeleteLog();
Thread thread = new Thread(new ThreadStart(AutoDepreciationTask));
thread.Start();
Thread thread2 = new Thread(new ThreadStart(AutoDBBackUpTask));
thread2.Start();
Thread thread3 = new Thread(new ThreadStart(AutoMonthUpdateTask));
thread3.Start();
}
public AutoTask()
{
AppInit.Init();
}