void GetData()
{
int page = Convert.ToInt32(Request.Params["page"]);
int pageSize = Convert.ToInt32(Request.Params["pagesize"]);
string sData = "";
List <CBaseObject> lstObj = m_Company.RoleMgr.GetList();
int totalPage = lstObj.Count % pageSize == 0 ? lstObj.Count / pageSize : lstObj.Count / pageSize + 1; // 计算总页数
int index = (page - 1) * pageSize; // 开始记录数
for (int i = index; i < pageSize + index && i < lstObj.Count; i++)
{
CBaseObject obj = (CBaseObject)lstObj[i];
string sRow = "";
foreach (CBaseObject objC in m_Table.ColumnMgr.GetList())
{
CColumn col = (CColumn)objC;
if (col.ColType == ColumnType.object_type)
{
string sVal = "";
if (obj.GetColValue(col) != null)
{
sVal = "long byte";
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else if (col.ColType == ColumnType.ref_type)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
if (RefTable == null)
{
continue;
}
CBaseObjectMgr objRefMgr = new CBaseObjectMgr();
objRefMgr.TbCode = RefTable.Code;
objRefMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objRefMgr.GetList(sWhere, cmdParas);
string sVal = "";
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
object objVal = obj2.GetColValue(RefShowCol);
if (objVal != null)
{
sVal = objVal.ToString();
}
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else
{
string sVal = "";
object objVal = obj.GetColValue(col);
if (objVal != null)
{
sVal = objVal.ToString();
}
Util.ConvertJsonSymbol(ref sVal);
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
}
sRow = sRow.TrimEnd(",".ToCharArray());
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
public void LoadData()
{
if (Company == null)
{
return;
}
if (dataGridView == null)
{
return;
}
if (dataGridView.Columns.Count == 0)
{
return;
}
dataGridView.Rows.Clear();
CBaseObjectMgr BaseObjectMgr = Company.WorkflowDefMgr;
List <CBaseObject> lstObj = BaseObjectMgr.GetList();
foreach (CBaseObject obj in lstObj)
{
CWorkflowDef WorkflowDef = (CWorkflowDef)obj;
Guid WF_WorkflowCatalog_id = (catalog == null) ? Guid.Empty : catalog.Id;
if (WorkflowDef.WF_WorkflowCatalog_id != WF_WorkflowCatalog_id)
{
continue;
}
dataGridView.Rows.Add(1);
int nRowIdx = dataGridView.Rows.Count - 1;
DataGridViewRow row = dataGridView.Rows[nRowIdx];
row.Tag = obj;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
CColumn col = (CColumn)column.Tag;
if (col.ColType == ColumnType.object_type)
{
if (obj.GetColValue(col) != null)
{
row.Cells[column.Name].Value = "long byte";
}
}
else if (col.ColType == ColumnType.ref_type)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(col.RefTable);
if (table == null)
{
continue;
}
CColumn RefCol = (CColumn)table.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)table.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
row.Cells[column.Name].Value = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
}
else
{
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, Guid.Empty);
if (objMgr != null)
{
CBaseObject objCache = objMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
row.Cells[column.Name].Value = objCache.GetColValue(RefShowCol);
}
}
else
{
objMgr = new CBaseObjectMgr();
objMgr.TbCode = table.Code;
objMgr.Ctx = Program.Ctx;
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
row.Cells[column.Name].Value = obj2.GetColValue(RefShowCol);
}
}
}
}
else
{
row.Cells[column.Name].Value = obj.GetColValue(col);
}
}
}
}
void GetData()
{
int page = Convert.ToInt32(Request.Params["page"]);
int pageSize = Convert.ToInt32(Request.Params["pagesize"]);
string catalog_id = Request["catalog_id"];
string sData = "";
List <CBaseObject> lstObj = new List <CBaseObject>();
CBaseObjectMgr BaseObjectMgr = m_Company.WorkflowDefMgr;
List <CBaseObject> lstWF = BaseObjectMgr.GetList();
foreach (CBaseObject objWF in lstWF)
{
CWorkflowDef WorkflowDef = (CWorkflowDef)objWF;
if (!string.IsNullOrEmpty(catalog_id))
{
Guid guid = new Guid(catalog_id);
if (WorkflowDef.WF_WorkflowCatalog_id == guid)
{
lstObj.Add(WorkflowDef);
}
}
else
{
//所有目录不存在的都放置根目录
CBaseObject objCatalog = m_Company.WorkflowCatalogMgr.Find(WorkflowDef.WF_WorkflowCatalog_id);
if (objCatalog == null)
{
lstObj.Add(WorkflowDef);
}
}
}
int totalPage = lstObj.Count % pageSize == 0 ? lstObj.Count / pageSize : lstObj.Count / pageSize + 1; // 计算总页数
int index = (page - 1) * pageSize; // 开始记录数
for (int i = index; i < pageSize + index && i < lstObj.Count; i++)
{
CBaseObject obj = (CBaseObject)lstObj[i];
string sRow = "";
foreach (CBaseObject objC in m_Table.ColumnMgr.GetList())
{
CColumn col = (CColumn)objC;
if (col.ColType == ColumnType.object_type)
{
string sVal = "";
if (obj.GetColValue(col) != null)
{
sVal = "long byte";
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else if (col.ColType == ColumnType.ref_type)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
if (RefTable == null)
{
continue;
}
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
string sVal = "";
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
object objVal2 = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
else
{
CBaseObjectMgr objRefMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, guidParentId);
if (objRefMgr != null)
{
CBaseObject objCache = objRefMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
object objVal2 = objCache.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
else
{
objRefMgr = new CBaseObjectMgr();
objRefMgr.TbCode = RefTable.Code;
objRefMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objRefMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
object objVal2 = obj2.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else
{
string sVal = "";
object objVal = obj.GetColValue(col);
if (objVal != null)
{
sVal = objVal.ToString();
}
Util.ConvertJsonSymbol(ref sVal);
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
}
sRow = sRow.TrimEnd(",".ToCharArray());
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
void GetData()
{
string pid = Request["pid"];
if (string.IsNullOrEmpty(pid))
{
return;
}
CBaseObjectMgr BaseObjectMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(m_Table.Code, new Guid(pid));
if (BaseObjectMgr == null)
{
BaseObjectMgr = new CBaseObjectMgr();
BaseObjectMgr.TbCode = m_Table.Code;
BaseObjectMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
CColumn colF = (CColumn)m_Table.ColumnMgr.Find(m_ViewDetail.ForeignKey);
if (colF == null)
{
return;
}
string sWhere0 = string.Format(" {0}='{1}'", colF.Code, pid);
BaseObjectMgr.GetList(sWhere0);
}
List <CBaseObject> lstObj = BaseObjectMgr.GetList();
string sData = "";
foreach (CBaseObject obj in lstObj)
{
string sRow = "";
foreach (CBaseObject objC in m_Table.ColumnMgr.GetList())
{
CColumn col = (CColumn)objC;
//判断禁止权限字段
if (m_sortRestrictColumnAccessType.ContainsKey(col.Id))
{
AccessType accessType = m_sortRestrictColumnAccessType[col.Id];
if (accessType == AccessType.forbide)
{
string sVal = "";
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
continue;
}
}
//
if (col.ColType == ColumnType.object_type)
{
string sVal = "";
if (obj.GetColValue(col) != null)
{
sVal = "long byte";
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else if (col.ColType == ColumnType.ref_type)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
if (RefTable == null)
{
continue;
}
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
string sVal = "";
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
object objVal2 = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
else
{
CBaseObjectMgr objRefMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, guidParentId);
if (objRefMgr != null)
{
CBaseObject objCache = objRefMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
object objVal2 = objCache.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
else
{
objRefMgr = new CBaseObjectMgr();
objRefMgr.TbCode = RefTable.Code;
objRefMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objRefMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
object objVal2 = obj2.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else
{
string sVal = "";
object objVal = obj.GetColValue(col);
if (objVal != null)
{
sVal = objVal.ToString();
}
//转义特殊字符
Util.ConvertJsonSymbol(ref sVal);
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
}
sRow = sRow.TrimEnd(",".ToCharArray());
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
private void tbtEdit_Click(object sender, EventArgs e)
{
if (dataGridView.CurrentRow == null)
{
MessageBox.Show("请选择一项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
CWorkflowDef obj = (CWorkflowDef)dataGridView.CurrentRow.Tag;
WorkflowDefInfo frm = new WorkflowDefInfo();
Guid Catalog_id = (catalog == null) ? Guid.Empty : catalog.Id;
frm.m_Catalog_id = Catalog_id;
frm.m_Company = Company;
frm.m_WorkflowDef = obj;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
CBaseObjectMgr BaseObjectMgr = Company.WorkflowDefMgr;
DataGridViewRow row = dataGridView.CurrentRow;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
CColumn col = (CColumn)column.Tag;
if (col.ColType == ColumnType.object_type)
{
if (obj.GetColValue(col) != null)
{
row.Cells[column.Name].Value = "long byte";
}
}
else if (col.ColType == ColumnType.ref_type)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(col.RefTable);
if (table == null)
{
continue;
}
CColumn RefCol = (CColumn)table.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)table.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
row.Cells[column.Name].Value = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
}
else
{
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, Guid.Empty);
if (objMgr != null)
{
CBaseObject objCache = objMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
row.Cells[column.Name].Value = objCache.GetColValue(RefShowCol);
}
}
else
{
objMgr = new CBaseObjectMgr();
objMgr.TbCode = table.Code;
objMgr.Ctx = Program.Ctx;
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
row.Cells[column.Name].Value = obj2.GetColValue(RefShowCol);
}
}
}
}
else
{
row.Cells[column.Name].Value = obj.GetColValue(col);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.End();
}
m_User = (CUser)Session["User"];
string vid = Request["vid"];
if (string.IsNullOrEmpty(vid))
{
Response.End();
}
m_View = (CView)Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.Find(new Guid(vid));
if (m_View == null)
{
Response.End();
}
m_ViewDetail = (CViewDetail)m_View.ViewDetailMgr.GetFirstObj();
if (m_ViewDetail == null)
{
Response.End();
}
m_Table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(m_ViewDetail.FW_Table_id);
if (Session["EditMasterDetailViewRecord"] == null)
{
Response.End();
}
SortedList <Guid, CBaseObject> arrP = (SortedList <Guid, CBaseObject>)Session["EditMasterDetailViewRecord"];
CBaseObject objP = arrP.Values[0];
m_BaseObjectMgr = objP.GetSubObjectMgr(m_Table.Code, typeof(CBaseObjectMgr));
m_sortRestrictColumnAccessType = m_User.GetRestrictColumnAccessTypeList(m_Table);
if (!IsPostBack)
{
recordCtrl.m_ViewDetail = m_ViewDetail;
recordCtrl.m_Table = m_Table;
recordCtrl.m_sortRestrictColumnAccessType = m_sortRestrictColumnAccessType;
if (!string.IsNullOrEmpty(Request["UIColCount"]))
{
recordCtrl.m_iUIColCount = Convert.ToInt32(Request["UIColCount"]);
}
//外面传递的默认值
foreach (CColumn col in m_Table.ColumnMgr.GetList())
{
if (!string.IsNullOrEmpty(Request[col.Code]))
{
recordCtrl.m_sortDefVal.Add(col.Code, Request[col.Code]);
}
}
//隐藏字段
string sHideCols = Request["HideCols"];
if (!string.IsNullOrEmpty(sHideCols))
{
string[] arr = sHideCols.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
foreach (string code in arr)
{
recordCtrl.m_sortHideColumn.Add(code, code);
}
}
}
if (Request.Params["Action"] == "Cancel")
{
Response.End();
}
else if (Request.Params["Action"] == "PostData")
{
PostData();
Response.End();
}
}
void PostData()
{
if (!ValidateData())
{
return;
}
SortedList <Guid, CBaseObject> arrP = (SortedList <Guid, CBaseObject>)Session["EditMasterDetailViewRecord"];
CBaseObject objP = arrP.Values[0];
CBaseObject BaseObject = m_BaseObjectMgr.CreateBaseObject();
BaseObject.Ctx = m_BaseObjectMgr.Ctx;
BaseObject.TbCode = m_BaseObjectMgr.TbCode;
bool bHasVisible = false;
//foreach (CBaseObject objCIVD in m_ViewDetail.ColumnInViewDetailMgr.GetList())
foreach (CBaseObject objCol in m_Table.ColumnMgr.GetList())
{
//CColumnInViewDetail civd = (CColumnInViewDetail)objCIVD;
//CColumn col = (CColumn)m_Table.ColumnMgr.Find(civd.FW_Column_id);
CColumn col = (CColumn)objCol;
if (col == null)
{
continue;
}
//判断禁止和只读权限字段
if (m_sortRestrictColumnAccessType.ContainsKey(col.Id))
{
AccessType accessType = m_sortRestrictColumnAccessType[col.Id];
if (accessType == AccessType.forbide)
{
continue;
}
//只读只在界面控制,有些默认值需要只读也需要保存数据
//else if (accessType == AccessType.read)
// continue;
}
//
if (col.Code.Equals("id", StringComparison.OrdinalIgnoreCase))
{
continue;
}
else if (col.Code.Equals("Created", StringComparison.OrdinalIgnoreCase))
{
BaseObject.SetColValue(col, DateTime.Now);
continue;
}
else if (col.Code.Equals("Creator", StringComparison.OrdinalIgnoreCase))
{
CUser user = (CUser)Session["User"];
BaseObject.SetColValue(col, user.Id);
continue;
}
else if (col.Code.Equals("Updated", StringComparison.OrdinalIgnoreCase))
{
continue;
}
else if (col.Code.Equals("Updator", StringComparison.OrdinalIgnoreCase))
{
//BaseObject.SetColValue(col, Program.User.Id);
continue;
}
if (col.ColType == ColumnType.object_type)
{
HttpPostedFile postfile = Request.Files.Get("_" + col.Code);
if (postfile != null && postfile.ContentLength > 0)
{
string sFileName = postfile.FileName;
if (sFileName.LastIndexOf('\\') > -1)//有些浏览器不带路径
{
sFileName = sFileName.Substring(sFileName.LastIndexOf('\\'));
}
byte[] byteFileName = System.Text.Encoding.Default.GetBytes(sFileName);
byte[] byteValue = new byte[254 + postfile.ContentLength];
byte[] byteData = new byte[postfile.ContentLength];
postfile.InputStream.Read(byteData, 0, postfile.ContentLength);
Array.Copy(byteFileName, byteValue, byteFileName.Length);
Array.Copy(byteData, 0, byteValue, 254, byteData.Length);
BaseObject.SetColValue(col, byteValue);
}
}
else if (col.ColType == ColumnType.path_type)
{
string sUploadPath = col.UploadPath;
if (sUploadPath[sUploadPath.Length - 1] != '\\')
{
sUploadPath += "\\";
}
if (!Directory.Exists(sUploadPath))
{
Directory.CreateDirectory(sUploadPath);
}
HttpPostedFile postfile = Request.Files.Get("_" + col.Code);
if (postfile != null && postfile.ContentLength > 0)
{
string sFileName = postfile.FileName;
if (sFileName.LastIndexOf('\\') > -1)//有些浏览器不带路径
{
sFileName = sFileName.Substring(sFileName.LastIndexOf('\\'));
}
FileInfo fi = new FileInfo(sUploadPath + sFileName);
Guid guid = Guid.NewGuid();
string sDestFile = string.Format("{0}{1}", guid.ToString().Replace("-", ""), fi.Extension);
postfile.SaveAs(sUploadPath + sDestFile);
string sVal = string.Format("{0}|{1}", sDestFile, sFileName);
BaseObject.SetColValue(col, sVal);
}
}
else if (col.ColType == ColumnType.bool_type)
{
string val = Request.Params["_" + col.Code];
if (!string.IsNullOrEmpty(val) && val.ToLower() == "on")
{
BaseObject.SetColValue(col, true);
}
else
{
BaseObject.SetColValue(col, false);
}
}
else if (col.ColType == ColumnType.datetime_type)
{
string val = Request.Params["_" + col.Code];
if (!string.IsNullOrEmpty(val))
{
BaseObject.SetColValue(col, Convert.ToDateTime(val));
}
}
else
{
BaseObject.SetColValue(col, Request.Params["_" + col.Code]);
}
bHasVisible = true;
}
if (!bHasVisible)
{
//Response.Write("没有可修改字段！");
Response.Write("<script>alert('没有可修改字段！');</script>");
return;
}
//外键关联
CColumn colP = (CColumn)objP.Table.ColumnMgr.Find(m_ViewDetail.PrimaryKey);
CColumn colF = (CColumn)m_Table.ColumnMgr.Find(m_ViewDetail.ForeignKey);
BaseObject.SetColValue(colF, objP.GetColValue(colP));
m_BaseObjectMgr.AddNew(BaseObject);
if (!m_BaseObjectMgr.Save(true))
{
//Response.Write("添加失败！");
Response.Write("<script>alert('添加失败！');</script>");
return;
}
//在iframe里访问外面,需要parent.parent.
//Response.Write("<script>parent.parent.grid.loadData(true);parent.parent.$.ligerDialog.close();</script>");
Response.Write("<script>parent.parent.onOkAddDetailRecord2();</script>");
}
void GetData()
{
int page = Convert.ToInt32(Request.Params["page"]);
int pageSize = Convert.ToInt32(Request.Params["pagesize"]);
CBaseObjectMgr BaseObjectMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(m_Table.Code, m_guidParentId);
if (BaseObjectMgr == null)
{
BaseObjectMgr = new CBaseObjectMgr();
BaseObjectMgr.TbCode = m_Table.Code;
BaseObjectMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
}
string sData = "";
List <CBaseObject> lstObj;
if (Request["Filter"] == null || Session["ViewFilterMgr"] == null)
{
lstObj = BaseObjectMgr.FilterByView(m_View);
//清空过滤条件
Session["ViewFilterMgr"] = null;
}
else
{
//过滤查询
SortedList <Guid, CViewFilterMgr> sortObj = (SortedList <Guid, CViewFilterMgr>)Session["ViewFilterMgr"];
if (sortObj.ContainsKey(m_View.Id))
{
CViewFilterMgr ViewFilterMgr = sortObj[m_View.Id];
lstObj = BaseObjectMgr.FilterByView(m_View, ViewFilterMgr);
}
else
{
lstObj = BaseObjectMgr.FilterByView(m_View);
}
}
int totalPage = lstObj.Count % pageSize == 0 ? lstObj.Count / pageSize : lstObj.Count / pageSize + 1; // 计算总页数
int index = (page - 1) * pageSize; // 开始记录数
for (int i = index; i < pageSize + index && i < lstObj.Count; i++)
{
CBaseObject obj = (CBaseObject)lstObj[i];
string sRow = "";
foreach (CBaseObject objC in m_Table.ColumnMgr.GetList())
{
CColumn col = (CColumn)objC;
//判断禁止权限字段
if (m_sortRestrictColumnAccessType.ContainsKey(col.Id))
{
AccessType accessType = m_sortRestrictColumnAccessType[col.Id];
if (accessType == AccessType.forbide)
{
string sVal = "";
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
continue;
}
}
//
if (col.ColType == ColumnType.object_type)
{
string sVal = "";
if (obj.GetColValue(col) != null)
{
sVal = "long byte";
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else if (col.ColType == ColumnType.ref_type)
{
CTable RefTable = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(col.RefTable);
if (RefTable == null)
{
continue;
}
CColumn RefCol = (CColumn)RefTable.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)RefTable.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
string sVal = "";
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
object objVal2 = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
else
{
CBaseObjectMgr objRefMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(RefTable.Code, guidParentId);
if (objRefMgr != null)
{
CBaseObject objCache = objRefMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
object objVal2 = objCache.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
else
{
objRefMgr = new CBaseObjectMgr();
objRefMgr.TbCode = RefTable.Code;
objRefMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objRefMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
object objVal2 = obj2.GetColValue(RefShowCol);
if (objVal2 != null)
{
sVal = objVal2.ToString();
}
}
}
}
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
else
{
string sVal = "";
object objVal = obj.GetColValue(col);
if (objVal != null)
{
sVal = objVal.ToString();
}
//转义特殊字符
Util.ConvertJsonSymbol(ref sVal);
sRow += string.Format("\"{0}\":\"{1}\",", col.Code, sVal);
}
}
sRow = sRow.TrimEnd(",".ToCharArray());
sRow = "{" + sRow + "},";
sData += sRow;
}
sData = sData.TrimEnd(",".ToCharArray());
sData = "[" + sData + "]";
string sJson = string.Format("{{\"Rows\":{0},\"Total\":\"{1}\"}}"
, sData, lstObj.Count);
Response.Write(sJson);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["User"] == null)
{
Response.End();
}
m_User = (CUser)Session["User"];
string vid = Request["vid"];
if (string.IsNullOrEmpty(vid))
{
Response.End();
}
m_View = (CView)Global.GetCtx(Session["TopCompany"].ToString()).ViewMgr.Find(new Guid(vid));
if (m_View == null)
{
Response.End();
}
m_Table = (CTable)Global.GetCtx(Session["TopCompany"].ToString()).TableMgr.Find(m_View.FW_Table_id);
//检查权限
if (!CheckAccess())
{
Response.End();
}
string ParentId = Request["ParentId"];
if (!string.IsNullOrEmpty(ParentId))
{
m_guidParentId = new Guid(ParentId);
}
string id = Request["id"];
if (string.IsNullOrEmpty(id))
{
Response.Write("请选择记录！");
Response.End();
}
m_BaseObjectMgr = Global.GetCtx(Session["TopCompany"].ToString()).FindBaseObjectMgrCache(m_Table.Code, m_guidParentId);
if (m_BaseObjectMgr == null)
{
m_BaseObjectMgr = new CBaseObjectMgr();
m_BaseObjectMgr.TbCode = m_Table.Code;
m_BaseObjectMgr.Ctx = Global.GetCtx(Session["TopCompany"].ToString());
string sWhere = string.Format(" id='{0}'", id);
m_BaseObjectMgr.GetList(sWhere);
}
m_BaseObject = m_BaseObjectMgr.Find(new Guid(id));
if (m_BaseObject == null)
{
Response.Write("请选择记录！");
Response.End();
}
//保存到编辑对象
EditObject.Add(Session.SessionID, m_BaseObject);
if (!IsPostBack)
{
recordCtrl.m_View = m_View;
recordCtrl.m_Table = m_Table;
recordCtrl.m_sortRestrictColumnAccessType = m_sortRestrictColumnAccessType;
recordCtrl.m_BaseObject = m_BaseObject;
if (!string.IsNullOrEmpty(Request["UIColCount"]))
{
recordCtrl.m_iUIColCount = Convert.ToInt32(Request["UIColCount"]);
}
}
if (Request.Params["Action"] == "Cancel")
{
m_BaseObject.Cancel();
Response.End();
}
else if (Request.Params["Action"] == "PostData")
{
PostData();
//从编辑对象移除
EditObject.Remove(Session.SessionID, m_BaseObject);
Response.End();
}
}
private void tbtNew_Click(object sender, EventArgs e)
{
RecordWindow frm = new RecordWindow(Program.Ctx.FormMgr, null);
//frm.recordCtrl.m_sortNotShowCol.Add("fw_table_id", Program.Ctx.FormMgr.Table.Id);
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
CBaseObjectMgr BaseObjectMgr = Program.Ctx.FormMgr;
CForm obj = (CForm)frm.BaseObject;
dataGridView.Rows.Add(1);
DataGridViewRow row = dataGridView.Rows[dataGridView.Rows.Count - 1];
row.Tag = obj;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
CColumn col = (CColumn)column.Tag;
if (col.ColType == ColumnType.object_type)
{
if (obj.GetColValue(col) != null)
{
row.Cells[column.Name].Value = "long byte";
}
}
else if (col.ColType == ColumnType.ref_type)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(col.RefTable);
if (table == null)
{
continue;
}
CColumn RefCol = (CColumn)table.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)table.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
row.Cells[column.Name].Value = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
}
else
{
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, Guid.Empty);
if (objMgr != null)
{
CBaseObject objCache = objMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
row.Cells[column.Name].Value = objCache.GetColValue(RefShowCol);
}
}
else
{
objMgr = new CBaseObjectMgr();
objMgr.TbCode = table.Code;
objMgr.Ctx = Program.Ctx;
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
row.Cells[column.Name].Value = obj2.GetColValue(RefShowCol);
}
}
}
}
else
{
row.Cells[column.Name].Value = obj.GetColValue(col);
}
}
dataGridView.ClearSelection();
row.Selected = true;
row.Cells[1].Selected = true;
DesignForm(obj);
}
private void tbtEdit_Click(object sender, EventArgs e)
{
if (dataGridView.CurrentRow == null)
{
MessageBox.Show("请选择一项！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
CBaseObject obj = (CBaseObject)dataGridView.CurrentRow.Tag;
if (View.VType == enumViewType.Single)
{
SingleViewRecord frm = new SingleViewRecord(BaseObjectMgr, obj);
frm.View = View;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
obj = frm.BaseObject;
}
else if (View.VType == enumViewType.MasterDetail)
{
MasterDetailViewRecord frm = new MasterDetailViewRecord(BaseObjectMgr, obj);
frm.View = View;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
obj = frm.BaseObject;
}
else
{
MultMasterDetailViewRecord frm = new MultMasterDetailViewRecord(BaseObjectMgr, obj);
frm.View = View;
if (frm.ShowDialog() != DialogResult.OK)
{
return;
}
obj = frm.BaseObject;
}
DataGridViewRow row = dataGridView.CurrentRow;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
//工作流
if (column.Name.Equals("workflow"))
{
continue;
}
//
CColumn col = (CColumn)column.Tag;
if (col.ColType == ColumnType.object_type)
{
if (obj.GetColValue(col) != null)
{
row.Cells[column.Name].Value = "long byte";
}
}
else if (col.ColType == ColumnType.ref_type)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(col.RefTable);
if (table == null)
{
continue;
}
CColumn RefCol = (CColumn)table.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)table.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
row.Cells[column.Name].Value = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
}
else
{
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, Guid.Empty);
if (objMgr != null)
{
CBaseObject objCache = objMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
row.Cells[column.Name].Value = objCache.GetColValue(RefShowCol);
}
}
else
{
objMgr = new CBaseObjectMgr();
objMgr.TbCode = table.Code;
objMgr.Ctx = Program.Ctx;
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
row.Cells[column.Name].Value = obj2.GetColValue(RefShowCol);
}
}
}
}
else
{
row.Cells[column.Name].Value = obj.GetColValue(col);
}
}
}
public void LoadData()
{
if (BaseObjectMgr == null)
{
return;
}
if (dataGridView.Columns.Count == 0)
{
return;
}
dataGridView.Rows.Clear();
//检查权限
if (!CheckAccess())
{
return;
}
m_TempViewFilterMgr.IsLoad = true;//避免临时数据从数据库装载
List <CBaseObject> lstObj = BaseObjectMgr.FilterByView(View, m_TempViewFilterMgr);
if (lstObj.Count == 0)
{
return;
}
dataGridView.Rows.Add(lstObj.Count);
int nRowIdx = 0;
foreach (CBaseObject obj in lstObj)
{
DataGridViewRow row = dataGridView.Rows[nRowIdx];
row.Tag = obj;
foreach (DataGridViewColumn column in dataGridView.Columns)
{
//工作流
if (column.Name.Equals("workflow"))
{
continue;
}
//
CColumn col = (CColumn)column.Tag;
//判断禁止权限字段
if (m_sortRestrictColumnAccessType.ContainsKey(col.Id))
{
AccessType accessType = m_sortRestrictColumnAccessType[col.Id];
if (accessType == AccessType.forbide)
{
continue;
}
}
//
if (col.ColType == ColumnType.object_type)
{
if (obj.GetColValue(col) != null)
{
row.Cells[column.Name].Value = "long byte";
}
}
else if (col.ColType == ColumnType.ref_type)
{
CTable table = (CTable)Program.Ctx.TableMgr.Find(col.RefTable);
if (table == null)
{
continue;
}
CColumn RefCol = (CColumn)table.ColumnMgr.Find(col.RefCol);
CColumn RefShowCol = (CColumn)table.ColumnMgr.Find(col.RefShowCol);
object objVal = obj.GetColValue(col);
Guid guidParentId = Guid.Empty;
if (BaseObjectMgr.m_Parent != null && BaseObjectMgr.m_Parent.Id == (Guid)objVal)
{
row.Cells[column.Name].Value = BaseObjectMgr.m_Parent.GetColValue(RefShowCol);
}
else
{
CBaseObjectMgr objMgr = Program.Ctx.FindBaseObjectMgrCache(table.Code, Guid.Empty);
if (objMgr != null)
{
CBaseObject objCache = objMgr.FindByValue(RefCol, objVal);
if (objCache != null)
{
row.Cells[column.Name].Value = objCache.GetColValue(RefShowCol);
}
}
else
{
objMgr = new CBaseObjectMgr();
objMgr.TbCode = table.Code;
objMgr.Ctx = Program.Ctx;
string sWhere = string.Format(" {0}=?", RefCol.Code);
List <DbParameter> cmdParas = new List <DbParameter>();
cmdParas.Add(new DbParameter(RefCol.Code, obj.GetColValue(col)));
List <CBaseObject> lstObj2 = objMgr.GetList(sWhere, cmdParas);
if (lstObj2.Count > 0)
{
CBaseObject obj2 = lstObj2[0];
row.Cells[column.Name].Value = obj2.GetColValue(RefShowCol);
}
}
}
}
else
{
row.Cells[column.Name].Value = obj.GetColValue(col);
}
}
UpdateRowWorkflow(row);
nRowIdx++;
}
}
