public List <ClassStudentMapViewEntity> GetSearch(int?classID, string keyString, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format(@"select cs.ID, c.ClassID, c.Code as 'ClassCode', c.Name as 'ClassName',
u.ID as 'StudentID', u.Code as 'StudentCode', u.Name as 'StudentName'
from ClassStudentMap(nolock) cs
inner join UserInfo(nolock) u on u.ID = cs.StudentID and u.valid = 'T'
inner join ClassInfo(nolock) c on c.ClassID = cs.ClassID and c.valid = 'T'
where cs.valid = 'T' {1} and (c.Code like '%{0}%' or c.Name like '%{0}%'
or u.Code like '%{0}%' or u.Name like '%{0}%') ",
keyString, classID == null ? "" : " and cs.ClassID = " + classID);
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by cs.ClassID {0}", order), null, offset / pageSize, pageSize, out pageCount, out total);
List <ClassStudentMapViewEntity> list = new List <ClassStudentMapViewEntity>();
foreach (DataRow dr in dt.Rows)
{
ClassStudentMapViewEntity entity = new ClassStudentMapViewEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.ClassID = Ext.ToInt(dr["ClassID"]);
entity.ClassCode = Ext.ToString(dr["ClassCode"]);
entity.ClassName = Ext.ToString(dr["ClassName"]);
entity.StudentID = Ext.ToInt(dr["StudentID"]);
entity.StudentCode = Ext.ToString(dr["StudentCode"]);
entity.StudentName = Ext.ToString(dr["StudentName"]);
list.Add(entity);
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(int?typeX)
{
SplitPage splitPage = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "isnull(isOK,-1)", Value = typeX.ToStringV()
}
}
};
splitPage.order = "desc";
splitPage.sort = "createDate";
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "CR_CreditMoney", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
public List <SchoolInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from SchoolInfo(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%')", keyString);
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <SchoolInfoEntity> list = new List <SchoolInfoEntity>();
foreach (DataRow dr in dt.Rows)
{
SchoolInfoEntity entity = new SchoolInfoEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.Code = Ext.ToString(dr["Code"]);
entity.Name = Ext.ToString(dr["Name"]);
entity.Address = Ext.ToString(dr["Address"]);
entity.Description = Ext.ToString(dr["Description"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.Company = Ext.ToString(dr["Company"]);
entity.Valid = Ext.ToString(dr["Valid"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
public List <StudentClassHistoryEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from StudentClassHistory(nolock) where valid = 'T'");
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <StudentClassHistoryEntity> list = new List <StudentClassHistoryEntity>();
foreach (DataRow dr in dt.Rows)
{
StudentClassHistoryEntity entity = new StudentClassHistoryEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.StudentID = Ext.ToInt(dr["StudentID"]);
entity.ArrangeClassID = Ext.ToInt(dr["ArrangeClassID"]);
entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]);
entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]);
entity.Score = Ext.ToIntOrNull(dr["Score"]);
entity.IsAttend = Ext.ToString(dr["IsAttend"]);
entity.IsPass = Ext.ToString(dr["IsPass"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.Valid = Ext.ToString(dr["Valid"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
/// <summary>
/// 日志列表
/// </summary>
public ActionResult GetPageListV1(Pagination pagination, SplitPage splitPage, int?CategoryId)
{
pagination.sidx = pagination.sort;
pagination.sord = pagination.order;
pagination.page = (pagination.page <= 0 ? 1 : pagination.page);
pagination.rows = (pagination.rows <= 0 ? 0 : pagination.rows);
List <Conditions> lisWhere = new List <Conditions>();
if (splitPage.Conditions == null)
{
lisWhere = new List <Conditions>();
}
else
{
lisWhere = splitPage.Conditions.ToList <Conditions>();
}
if (CategoryId.ToInt() > 0)
{
lisWhere.Add(new Conditions()
{
Key = "CategoryId", Value = CategoryId.ToStringV()
});
}
splitPage.Conditions = lisWhere.ToArray();
var data = LogBLL.GetPageListV(pagination, splitPage);
var jsonData = new
{
rows = data,
total = pagination.records,
};
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取文件信息
/// </summary>
public ActionResult GetFileData(string cinvCode, string picStr, string picType)
{
//含原始文件
SplitPage spPic = new SplitPage();
List <Conditions> listCon = new List <Conditions>();
listCon.Add(new Conditions()
{
Key = "billType", Value = cinvCode
});
listCon.Add(new Conditions()
{
Key = "category", Value = picStr
});
if (!string.IsNullOrEmpty(picType))
{
listCon.Add(new Conditions()
{
Key = "picType", Value = picType
}); //1 原始，2 内部，3 工序
}
spPic.Conditions = listCon.ToArray();
var attach = attachmentbll.GetList(spPic);
return(ToJsonResult(attach));
}
/// <summary>
/// 我的提醒列表
/// </summary>
/// <param name="splitPage">查询参数</param>
/// <param name="usage">使用范围(前台使用)</param>
/// <returns>返回分页列表Json</returns>
public ActionResult getMyTixing(SplitPage splitPage, string usage)
{
List <Conditions> lisWhere = new List <Conditions>();
if (splitPage.Conditions == null)
{
lisWhere = new List <Conditions>();
}
else
{
lisWhere = splitPage.Conditions.ToList <Conditions>();
}
lisWhere.Add(new Conditions()
{
Key = "receiver", Value = OperatorProvider.Provider.Current().UserId
});
lisWhere.Add(new Conditions()
{
Key = "isDelete", Value = "0"
});
splitPage.order = "asc";
splitPage.sort = "CreateDate";
splitPage.Conditions = lisWhere.ToArray();
var data = tixingbll.GetMyList(splitPage, usage);
return(Content(data.ToJson()));
}
public List <ClassInfoEntity> GetSearch(string keyString, string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from ClassInfo(nolock) where valid = 'T' and (code like '%{0}%' or name like '%{0}%')", keyString);
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <ClassInfoEntity> list = new List <ClassInfoEntity>();
foreach (DataRow dr in dt.Rows)
{
ClassInfoEntity entity = new ClassInfoEntity();
entity.ClassID = Ext.ToInt(dr["ClassID"]);
entity.Code = Ext.ToString(dr["Code"]);
entity.Name = Ext.ToString(dr["Name"]);
entity.Type = Ext.ToString(dr["Type"]);
entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]);
entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]);
entity.TeacherID = Ext.ToIntOrNull(dr["TeacherID"]);
entity.Company = Ext.ToString(dr["Company"]);
entity.Department = Ext.ToString(dr["Department"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.Valid = Ext.ToString(dr["Valid"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
public List <LoginLogEntity> GetSearch(string whereCondition, string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from LoginLog(nolock) {0}", whereCondition);
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <LoginLogEntity> list = new List <LoginLogEntity>();
foreach (DataRow dr in dt.Rows)
{
LoginLogEntity entity = new LoginLogEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.Guid = Ext.ToString(dr["Guid"]);
entity.Type = Ext.ToString(dr["Type"]);
entity.LoginID = Ext.ToInt(dr["LoginName"]);
entity.LoginName = Ext.ToString(dr["LoginName"]);
entity.LoginType = Ext.ToString(dr["LoginType"]);
entity.Action = Ext.ToString(dr["Action"]);
entity.TimeRecord = Ext.ToDateOrNull(dr["TimeRecord"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.MachineID = Ext.ToString(dr["MachineID"]);
entity.LoginIP = Ext.ToString(dr["LoginIP"]);
entity.LoginIP2 = Ext.ToString(dr["LoginIP2"]);
entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]);
entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
list.Add(entity);
}
return(list);
}
/// <summary>
/// 获取列表
/// </summary>
public ActionResult GetDataGridJsonV(string userID)
{
SplitPage s = new SplitPage()
{
Conditions = new Conditions[]
{
new Conditions()
{
Key = "userID", Value = userID
}
}
};
s.sort = "CreateDate";
s.order = "desc";
int total = 0;
string sqlw = SxSqlHelperBLL.getSqlw(s);
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", s, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
public List <ArrangeClassEntity> GetSearch(string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from ArrangeClass(nolock) where valid = 'T'");
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize, pageSize, out pageCount, out total);
List <ArrangeClassEntity> list = new List <ArrangeClassEntity>();
foreach (DataRow dr in dt.Rows)
{
ArrangeClassEntity entity = new ArrangeClassEntity();
entity.ID = Ext.ToInt(dr["ID"]);
entity.CurriculumID = Ext.ToInt(dr["CurriculumID"]);
entity.ClassID = Ext.ToInt(dr["ClassID"]);
entity.ClassRoomID = Ext.ToInt(dr["ClassRoomID"]);
entity.TeacherID = Ext.ToInt(dr["TeacherID"]);
entity.StartTime = Ext.ToDateOrNull(dr["StartTime"]);
entity.EndTime = Ext.ToDateOrNull(dr["EndTime"]);
entity.Remark = Ext.ToString(dr["Remark"]);
entity.BespeakCount = Ext.ToIntOrNull(dr["BespeakCount"]);
entity.AttendCount = Ext.ToIntOrNull(dr["AttendCount"]);
entity.PassedCount = Ext.ToIntOrNull(dr["PassedCount"]);
entity.Valid = Ext.ToString(dr["Valid"]);
entity.CreateTime = Ext.ToDate(dr["CreateTime"]);
entity.CreateBy = Ext.ToString(dr["CreateBy"]);
entity.UpdateTime = Ext.ToDate(dr["UpdateTime"]);
entity.UpdateBy = Ext.ToString(dr["UpdateBy"]);
list.Add(entity);
}
return(list);
}
/// <summary>
/// 我的待办数量
/// </summary>
/// <returns>返回分页列表Json</returns>
public ActionResult getMyMissionNum(SplitPage splitPage)
{
List <Conditions> lisWhere = new List <Conditions>();
if (splitPage.Conditions == null)
{
lisWhere = new List <Conditions>();
}
else
{
lisWhere = splitPage.Conditions.ToList <Conditions>();
}
lisWhere.Add(new Conditions()
{
Key = "receiver", Value = OperatorProvider.Provider.Current().UserId
});
lisWhere.Add(new Conditions()
{
Key = "isDelete", Value = "0"
});
lisWhere.Add(new Conditions()
{
Key = "completeStatus", Value = "0"
});
splitPage.Conditions = lisWhere.ToArray();
var data = missionbll.GetMyList(splitPage);
var jsonData = new
{
missionNum = data.Count()
};
return(ToJsonResult(jsonData));
}
/// <summary>
/// 我的待办列表
/// </summary>
/// <param name="pagination">分页参数</param>
/// <param name="splitPage">查询参数</param>
/// <param name="usage">使用范围(前台使用)</param>
/// <returns>返回分页列表Json</returns>
public ActionResult getMyMission(Pagination pagination, SplitPage splitPage, string usage)
{
pagination.sidx = pagination.sort;
pagination.sord = pagination.order;
pagination.page = (pagination.page <= 0 ? 1 : pagination.page);
pagination.rows = (pagination.rows <= 0 ? 0 : pagination.rows);
List <Conditions> lisWhere = new List <Conditions>();
if (splitPage.Conditions == null)
{
lisWhere = new List <Conditions>();
}
else
{
lisWhere = splitPage.Conditions.ToList <Conditions>();
}
//桌面使用
if (!string.IsNullOrEmpty(usage) && usage.Equals("top"))
{
lisWhere.Add(new Conditions()
{
Key = "receiver", Value = OperatorProvider.Provider.Current().UserId
});
lisWhere.Add(new Conditions()
{
Key = "isDelete", Value = "0"
});
lisWhere.Add(new Conditions()
{
Key = "completeStatus", Value = "0"
});
splitPage.order = "asc";
splitPage.sort = "CreateDate";
splitPage.Conditions = lisWhere.ToArray();
var data = missionbll.GetMyList(pagination, splitPage, usage);
return(Content(data.ToJson()));
}
else
{
//列表使用
lisWhere.Add(new Conditions()
{
Key = "receiver", Value = OperatorProvider.Provider.Current().UserId
});
lisWhere.Add(new Conditions()
{
Key = "isDelete", Value = "0"
});
splitPage.Conditions = lisWhere.ToArray();
var data = missionbll.GetMyList(pagination, splitPage, usage);
var jsonData = new
{
rows = data,
total = pagination.records,
};
return(ToJsonResult(jsonData));
}
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="splitPage">查询对象</param>
/// <returns></returns>
public ActionResult GetDataGridJsonV2(Pagination pagination, SplitPage splitPage)
{
pagination.sidx = pagination.sort;
pagination.sord = pagination.order;
pagination.page = (pagination.page <= 0? 1:pagination.page);
pagination.rows = (pagination.rows <= 0? 0:pagination.rows);
var data = missionreceiveinfobll.GetPageList(pagination, splitPage);
var jsonData = new
{
rows = data,
total = pagination.records,
};
return(ToJsonResult(jsonData));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="splitPage">分页参数</param>
/// <returns></returns>
public ActionResult GetDataGridJson(SplitPage splitPage)
{
string sqlw = SxSqlHelperBLL.getSqlw(splitPage);
int total = 0;
System.Data.DataTable dt = new System.Data.DataTable();
SxSqlHelperBLL.getPageDataEasyUi(sqlw, "Base_Person", splitPage, ref total, ref dt);
if (!TB.CheckTB(dt))
{
dt = new System.Data.DataTable();
}
var jsonData = new { rows = dt, total = total };
return(ToJsonResult(jsonData));
}
public List <UserInfoEntity> GetSearch(string keyString, string type, string sort, string order, int offset, int pageSize, out int total)
{
int pageCount = 0;
string querySql = string.Format("select * from UserInfo(nolock) where valid = 'T' {1} and (code like '%{0}%' or name like '%{0}%') ",
keyString, string.IsNullOrWhiteSpace(type) ? "" : string.Format(" and Type = '{0}'", type));
DataTable dt = SplitPage.SqlSplitPage(querySql, string.Format("order by {0} {1}", sort, order), null, offset / pageSize + 1, pageSize, out pageCount, out total);
List <UserInfoEntity> list = new List <UserInfoEntity>();
foreach (DataRow dr in dt.Rows)
{
UserInfoEntity entity = new UserInfoEntity();
entity.ID = Ext.ToInt(dr["id"]);
entity.Code = Ext.ToString(dr["code"]);
entity.Name = Ext.ToString(dr["name"]);
entity.Password = Ext.ToString(dr["password"]);
entity.Type = Ext.ToString(dr["type"]);
entity.Group = Ext.ToString(dr["group"]);
entity.Company = Ext.ToString(dr["company"]);
entity.Department = Ext.ToString(dr["department"]);
entity.PositionID = Ext.ToString(dr["positionID"]);
entity.PositionName = Ext.ToString(dr["positionName"]);
entity.Sex = Ext.ToString(dr["sex"]);
entity.Birthday = Ext.ToDate(dr["birthday"]);
entity.Email = Ext.ToString(dr["email"]);
entity.Phone = Ext.ToString(dr["phone"]);
entity.Address = Ext.ToString(dr["address"]);
entity.Valid = Ext.ToString(dr["valid"]);
entity.CreateTime = Ext.ToDate(dr["createTime"]);
entity.CreateBy = Ext.ToString(dr["createBy"]);
entity.UpdateTime = Ext.ToDate(dr["updateTime"]);
entity.UpdateBy = Ext.ToString(dr["updateBy"]);
list.Add(entity);
}
return(list);
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
// Get a pointer to our main page.
rootPage = e.Parameter as SplitPage;
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
// Get a pointer to our main page
rootPage = e.Parameter as SplitPage;
// init printing
RegisterForPrinting();
}
/// <summary>
/// Wird aufgerufen, wenn die Anwendung durch den Endbenutzer normal gestartet wird. Weitere Einstiegspunkte
/// werden z. B. verwendet, wenn die Anwendung gestartet wird, um eine bestimmte Datei zu öffnen.
/// </summary>
/// <param name="e">Details über Startanforderung und -prozess.</param>
protected override async void OnLaunched(LaunchActivatedEventArgs e) {
try {
if (!string.IsNullOrEmpty(e.Arguments)) {
await new TileAction(e.Arguments).Execute();
Exit();
return;
}
} catch (Exception ex) {
try {
Debug.WriteLine(ex);
new MessageDialog(ex.ToString())
.ShowAsync();
} catch (Exception ex2) {
Debug.WriteLine(ex2);
}
}
SetupHelper();
SplitPage = Window.Current.Content as SplitPage;
Frame rootFrame = null;
if (SplitPage == null) {
SplitPage = new SplitPage();
if (rootFrame == null) {
rootFrame = new Frame();
rootFrame.Language = Windows.Globalization.ApplicationLanguages.Languages[0];
rootFrame.NavigationFailed += OnNavigationFailed;
if (e.PreviousExecutionState == ApplicationExecutionState.Terminated) {
}
}
SplitPage.DataContext = rootFrame;
Window.Current.Content = SplitPage;
}
//Frame rootFrame = Window.Current.Content as Frame;
//// App-Initialisierung nicht wiederholen, wenn das Fenster bereits Inhalte enthält.
//// Nur sicherstellen, dass das Fenster aktiv ist.
//if (rootFrame == null) {
// // Frame erstellen, der als Navigationskontext fungiert und zum Parameter der ersten Seite navigieren
// rootFrame = new Frame();
// rootFrame.NavigationFailed += OnNavigationFailed;
// if (e.PreviousExecutionState == ApplicationExecutionState.Terminated) {
// //TODO: Zustand von zuvor angehaltener Anwendung laden
// }
// // Den Frame im aktuellen Fenster platzieren
// Window.Current.Content = rootFrame;
//}
if (SplitPage.Content == null) {
// Wenn der Navigationsstapel nicht wiederhergestellt wird, zur ersten Seite navigieren
// und die neue Seite konfigurieren, indem die erforderlichen Informationen als Navigationsparameter
// übergeben werden
rootFrame.Navigate(typeof(SplitPage), e.Arguments);
}
// Sicherstellen, dass das aktuelle Fenster aktiv ist
Window.Current.Activate();
}
