public JsonResult GetTypeTreeTop()
{
var mainTypeTree = CommonHelper.GetMainTypeTopTree();
var easyuiTree = EasyUIHelper.GetTreeJson(mainTypeTree);
return(Json(easyuiTree, false));
}
public JsonResult Data(string deptNo, string keyword)
{
//获取 easyui-datagrid 的分页参数和排序参数
var pager = EasyUIHelper.GetDataPager();
var sorting = EasyUIHelper.GetSorting();
sorting.Replace(new Dictionary <string, string> {
{ "SexText", "Sex" }
});
using (var context = new DbContext())
{
//使用AssertWhere拼接linq
var list = context.Employees
.Segment(pager)
.AssertWhere(!string.IsNullOrEmpty(deptNo), s => s.Dept.No.StartsWith(deptNo))
.AssertWhere(!string.IsNullOrEmpty(keyword), s => s.Name.Contains(keyword) || s.No.Contains(keyword))
.OrderBy(sorting, u => u.OrderBy(s => s.Name)) //默认按名称排序
.Select(s => s.Extend(() => new
{
SexText = s.Sex.GetDescription()
}))
.ToList();
//如果使用Extend的话，UI不能使用SexText进行排序
//另一种办法就是把需要显示到UI的属性都打出来
// .Select(s => new { s.Id, s.Name, Sex = s.Sex.GetDescription() })
//使用Transfer把列表转换成 easyui-datagrid 的json格式： { total: 10, rows: [{},{}] }
//注意上面要用 ToList，不然 pager 的记录总数和页码数无法获取
return(Json(EasyUIHelper.Transfer(pager, list)));
}
}
public string GetListData(string name, int pageIndex, int pageSize, out int rowCount)
{
string errMsgStr = "";
rowCount = 0;
string querySql = "select * from xt_zzjg_dwbm ";
if (name.Length > 0)
{
querySql += "where dwmc like '%" + name + "%' ";
}
List <KeyValueItem> items = new List <KeyValueItem>();
items.Add(new KeyValueItem("p_srcsql", querySql));
items.Add(new KeyValueItem("p_pageindex", pageIndex));
items.Add(new KeyValueItem("p_pagesize", pageSize));
items.Add(new KeyValueItem("p_rowcount", rowCount));
items.Add(new KeyValueItem("p_errmsg", errMsgStr));
DataSet ds = dbases.ExecuteDataSet <KeyValueItem>("PKG_ZZJG_manage.proc_xt_zzjg_dwbm_list", items.ToArray());
int.TryParse(items[items.Count - 2].Value.ToString(), out rowCount);
var errMsg = items[items.Count - 1];
return(EasyUIHelper.BuildDataGridDataSource(rowCount, ds.Tables[0]));
}
public async Task <JsonResult> Data(string keyword, int?type, StateFlags?state)
{
var pager = EasyUIHelper.GetDataPager();
var sorting = EasyUIHelper.GetSorting();
var list = await adminService.GetRolesAsync(state, keyword, pager, sorting);
return(Json(EasyUIHelper.Transfer(pager, list)));
}
/// <summary>
/// 根据查询条件获取角色。
/// </summary>
/// <param name="state">启用状态</param>
/// <param name="keyword">关键字</param>
/// <returns></returns>
public async Task <JsonResult> Data(StateFlags?state, string keyword)
{
var pager = EasyUIHelper.GetDataPager(HttpContext);
var sorting = EasyUIHelper.GetSorting(HttpContext);
var list = await adminService.GetRolesAsync(state, keyword, pager, sorting);
return(Json(list));
}
public async Task <JsonResult> Data(string orgCode, string keyword, StateFlags?state)
{
var pager = EasyUIHelper.GetDataPager(HttpContext);
var sorting = EasyUIHelper.GetSorting(HttpContext);
var userId = HttpContext.GetSession().UserID;
sorting = sorting.Replace("SexName", "Sex", "DegreeName", "DegreeNo", "TitleName", "TitleNo");
var list = await _adminService.GetUsersAsync(userId, orgCode, state, keyword, pager, null);
return(Json(EasyUIHelper.Transfer(pager, list)));
}
/// <summary>
/// 根据查询条件获取用户。
/// </summary>
/// <param name="orgCode">机构编码</param>
/// <param name="keyword">关键字</param>
/// <param name="roleId">角色ID。</param>
/// <param name="state">启用状态</param>
/// <returns></returns>
public async Task <JsonResult> GetUsers(string orgCode, string keyword, int roleId)
{
var pager = EasyUIHelper.GetDataPager(HttpContext);
var sorting = EasyUIHelper.GetSorting(HttpContext);
var userId = HttpContext.GetSession().UserID;
sorting = sorting.Replace("SexName", "Sex", "DegreeName", "DegreeNo", "TitleName", "TitleNo");
var list = await _adminService.GetUsersByRoleExcludeAsync(userId, orgCode, roleId, keyword, pager, sorting);
return(Json(EasyUIHelper.Transfer(pager, list)));
}
/// <summary>
/// 根据角色获取相应的用户。
/// </summary>
/// <param name="roleId">角色ID。</param>
/// <returns></returns>
public async Task <JsonResult> GetUsersByRole(int?roleId)
{
if (roleId == null)
{
return(Json(new string[0]));
}
var pager = EasyUIHelper.GetDataPager(HttpContext);
var sorting = EasyUIHelper.GetSorting(HttpContext);
var list = await _adminService.GetUsersByRoleAsync((int)roleId, pager, sorting);
return(Json(EasyUIHelper.Transfer(pager, list)));
}
private void btnCreate_Click(object sender, EventArgs e)
{
EasyUIModel model = new EasyUIModel();
model.DbName = this.txtDBName.Text.Trim();
model.AddColumnsStr = this.txtAddColumnName.Text.Trim();
model.SearchColumnsStr = this.txtSearchColumnName.Text.Trim();
model.EditColumnsStr = this.txtEditColumnName.Text.Trim();
model.BatEditColumnsStr = this.txtBatEdit.Text.Trim();
model.TableStr = this.txtName.Text.Trim();
model.NameSpace = this.txtNameSpace.Text.Trim();
model.DbType = rbtnMSSQL.Checked ? 0 : 1;
model.IsDel = this.chkDel.Checked;
model.IsBatDel = this.chkBatDel.Checked;
model.IsBatEdit = this.chkBatEdit.Checked;
model.IsAdd = this.chkAdd.Checked;
model.IsEdit = this.chkEdit.Checked;
model.IsExport = this.chkExport.Checked;
// 初始化model对象的属性
UIHelper.InitEasyUI(model);
if (model.DbType == 0)
{
EasyUIHelper easyHelper = new EasyUIHelper();
this.txtClassCode.Text = easyHelper.CreateModel(model);
string aspxStr = easyHelper.CreateASPX(model);
this.txtAspxCode.Text = aspxStr;
this.txtAspxCsCode.Text = easyHelper.CreateASPXCS(model);
this.txtDALCode.Text = easyHelper.CreateDAL(model);
this.txtFactoryCode.Text = easyHelper.CreateFactory(model);
this.txtSqlHelper.Text = SourceHelper.GetResource("sqlhelper.txt").Replace("命名空间", model.NameSpace);
}
else if (model.DbType == 1)
{
//CreateClass(temp);
//MySqlCreateMySqlHelper sqlHelper = new MySqlCreateMySqlHelper(temp);
//SetContent(this.txtAddCode, sqlHelper.CreateInsertMethod);
//SetContent(this.txtDeleteCode, sqlHelper.CreateDeleteMethod);
//SetContent(this.txtBatDeleteCode, sqlHelper.CreateBatDeleteMethod);
//SetContent(this.txtUpdateCode, sqlHelper.CreateUpdateMethod);
//SetContent(this.txtFactoryCode, sqlHelper.CreateConnectionFactory);
}
}
public JsonResult GetTree()
{
var departList = UnitOfWork.Get <MF_Department>().ToDicList().ToList();
string topId = CommonStr.MainTypeTreeRootID;
string topName = ConfigurationManager.AppSettings["AppTitle"];
foreach (var depart in departList)
{
if (string.IsNullOrEmpty(depart.GetValue("ParentId")))
{
depart.SetValue("ParentId", topId);
}
depart.SetValue("Text", depart.GetValue("Name"));
}
var topDic = (new MF_Department()).ToDictionary();
topDic.SetValue("Id", topId);
topDic.SetValue("Text", topName);
topDic.SetValue("ParentId", "");
departList.Insert(0, topDic);
return(Json(EasyUIHelper.GetTreeJson(departList), false));
}
public JsonResult GetFuncTreeJson()
{
var res = UnitOfWork.Get <MF_Func>();
return(Json(EasyUIHelper.GetTreeJson(res)));
}
private void btnExportCode_Click(object sender, EventArgs e)
{
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "Zip文件|*.zip";
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string filePath = dialog.FileName;
EasyUIModel model = new EasyUIModel();
model.DbName = this.txtDBName.Text.Trim();
model.AddColumnsStr = this.txtAddColumnName.Text.Trim();
model.SearchColumnsStr = this.txtSearchColumnName.Text.Trim();
model.EditColumnsStr = this.txtEditColumnName.Text.Trim();
model.BatEditColumnsStr = this.txtBatEdit.Text.Trim();
model.TableStr = this.txtName.Text.Trim();
model.NameSpace = this.txtNameSpace.Text.Trim();
model.DbType = rbtnMSSQL.Checked ? 0 : 1;
model.IsDel = this.chkDel.Checked;
model.IsBatDel = this.chkBatDel.Checked;
model.IsBatEdit = this.chkBatEdit.Checked;
model.IsAdd = this.chkAdd.Checked;
model.IsEdit = this.chkEdit.Checked;
model.IsExport = this.chkExport.Checked;
// 初始化model对象的属性
UIHelper.InitEasyUI(model);
if (model.DbType == 0)
{
EasyUIHelper easyHelper = new EasyUIHelper();
this.txtClassCode.Text = easyHelper.CreateModel(model);
string aspxStr = easyHelper.CreateASPX(model);
this.txtAspxCode.Text = aspxStr;
this.txtAspxCsCode.Text = easyHelper.CreateASPXCS(model);
this.txtDALCode.Text = easyHelper.CreateDAL(model);
this.txtFactoryCode.Text = easyHelper.CreateFactory(model);
this.txtSqlHelper.Text = SourceHelper.GetResource("sqlhelper.txt").Replace("命名空间", model.NameSpace);
}
else if (model.DbType == 1)
{
}
// 构建数据，塞入zip包
string tempPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "temp");
if (!Directory.Exists(tempPath))
{
Directory.CreateDirectory(tempPath);
}
string dir = Path.Combine(tempPath, model.TableName);
if (Directory.Exists(dir))
{
Directory.Delete(dir);
}
Directory.CreateDirectory(dir);
string modelPath = Path.Combine(dir, model.TableName.ToFirstUpper() + ".cs");
string aspxPath = Path.Combine(dir, model.TableName.ToFirstUpper() + "Manager.aspx");
string aspxCsPath = Path.Combine(dir, model.TableName.ToFirstUpper() + "Manager.aspx.cs");
string dalPath = Path.Combine(dir, model.TableName.ToFirstUpper() + "DAL.cs");
string factoryPath = Path.Combine(dir, "ConnectionFactory.cs");
string sqlHelperPath = Path.Combine(dir, "SqlHelper.cs");
File.WriteAllText(modelPath, this.txtClassCode.Text);
File.WriteAllText(aspxPath, this.txtAspxCode.Text);
File.WriteAllText(aspxCsPath, this.txtAspxCsCode.Text);
File.WriteAllText(dalPath, this.txtDALCode.Text);
File.WriteAllText(factoryPath, this.txtFactoryCode.Text);
File.WriteAllText(sqlHelperPath, this.txtSqlHelper.Text);
string zipPath = Path.Combine(tempPath, Guid.NewGuid().ToString("N") + ".zip");
ZipHelper.ZipDirectory(dir, zipPath);
File.Copy(zipPath, filePath);
File.Delete(zipPath);
}
}
public ContentResult GetPage()
{
return(EasyUIHelper.GetDataGridPageData());
}
