protected Result[] PreGenerateCode(JObject data) { CSParameter entry = new CSParameter(); DataSet ds = RunProcedureDataSet(data, "vdp_get_page_for_gen_client", "sys"); if (ds.Tables.Count >= 2) { entry.page = new Page(); entry.page.Author = CurrentUser.RealName; entry.page.id = (int)ds.Tables[0].Rows[0]["id"]; entry.page.template_id = (int)ds.Tables[0].Rows[0]["template_id"]; entry.page.page_name = (string)ds.Tables[0].Rows[0]["page_name"]; entry.page.description = (string)ds.Tables[0].Rows[0]["description"]; entry.page.parent_menu_code = (string)ds.Tables[0].Rows[0]["parent_menu_code"]; entry.page.page_name_text = (string)ds.Tables[0].Rows[0]["page_name_text"]; entry.page.controller_area = (string)ds.Tables[0].Rows[0]["controller_area"]; entry.page.controller = (string)ds.Tables[0].Rows[0]["controller"]; entry.page_detail = new List <PageDetail>(); foreach (DataRow r in ds.Tables[1].Rows) { PageDetail tmpPageDetail = new PageDetail(); tmpPageDetail.id = (int)r["id"]; tmpPageDetail.area = (string)r["area"]; tmpPageDetail.table_name = (string)r["table_name"]; tmpPageDetail.module_id = (int)r["module_id"]; tmpPageDetail.comments = (string)r["comments"]; tmpPageDetail.name_text = (string)r["name_text"]; tmpPageDetail.class_name = (string)r["class_name"];; tmpPageDetail.RelatedChildenTable = (string)r["related_childen_table"]; tmpPageDetail.table_description = ""; entry.page_detail.Add(tmpPageDetail); data["page_detail_id"] = tmpPageDetail.id; DataSet ds2 = RunProcedureDataSet(data, "vdp_get_page_detail_for_gen_client", "sys"); int w = 0; ColumnSet cs; tmpPageDetail.columns = new List <ColumnSet>(); foreach (DataRow r2 in ds2.Tables[0].Rows) { cs = new ColumnSet(); cs.isInsert = r2["is_insert"].ToString() == "0" ? false : true; cs.isShow = r2["is_show"].ToString() == "0" ? false : true; cs.isUpdate = r2["is_update"].ToString() == "0" ? false : true; cs.isRequired = r2["is_required"].ToString() == "0" ? false : true; cs.isWhere = r2["is_where"].ToString() == "0" ? false : true; tmpPageDetail.table_description = (string)r2["table_description"]; if (r2["size"].ToString() == "") { w = 0; } else { w = int.Parse(r2["length"].ToString()) * 10; } if (w > 500) { w = 500; } cs.width = w; cs.data = (string)r2["data"]; cs.valid = (string)r2["valid"]; cs.staticValue = (string)r2["static_value"]; cs.FlagIdentity = int.Parse(r2["flag_identity"].ToString()); cs.FlagPrimary = int.Parse(r2["flag_primary"].ToString());// (int)r2["flag_primary"]; cs.ColumnName = (string)r2["column_name"]; cs.Type = (string)r2["type"]; if (r2["size"].ToString() == "") { cs.Size = 0; } else { string tmpstr = r2["size"].ToString(); if (tmpstr.Length >= 5) { tmpstr = "50000"; } if (int.Parse(tmpstr) > 6000) { cs.Size = 6000; } else { cs.Size = Int16.Parse(tmpstr);//(Int16)r2["size"]; } } if (r2["length"].ToString() == "") { cs.Length = 0; } else { cs.Length = int.Parse(r2["length"].ToString());// (int)r2["length"]; } cs.htmlType = (string)r2["html_type"]; cs.ColumnCaption = (string)r2["column_caption"]; cs.ColumnDescription = (string)r2["column_description"]; cs.RelatedParentTable = (string)r2["related_table"]; cs.staticValue = (string)r2["static_value"]; cs.PrimaryField = (string)r2["primary_field"]; if (r2["is_identity"].ToString() == "1") { cs.IsIdentity = true; } else { cs.IsIdentity = false; } tmpPageDetail.columns.Add(cs); } } } Result[] r3 = mycs.CreateCode(JSToken, entry); return(r3); }
protected Result[] PreGenerateCode(JObject data) { CSParameter entry = new CSParameter(); DataSet ds = RunProcedureDataSet(data, "vdp_get_page_for_gen_client", "sys"); if (ds.Tables.Count >= 2) { entry.page = new Page(); entry.page.Author = CurrentUser.RealName; entry.page.id = (int)ds.Tables[0].Rows[0]["id"]; entry.page.template_id = (int)ds.Tables[0].Rows[0]["template_id"]; entry.page.page_name = (string)ds.Tables[0].Rows[0]["page_name"]; entry.page.description = (string)ds.Tables[0].Rows[0]["description"]; entry.page.parent_menu_code = (string)ds.Tables[0].Rows[0]["parent_menu_code"]; entry.page.page_name_text = (string)ds.Tables[0].Rows[0]["page_name_text"]; entry.page.controller_area = (string)ds.Tables[0].Rows[0]["controller_area"]; entry.page.controller = (string)ds.Tables[0].Rows[0]["controller"]; entry.page_detail = new List <PageDetail>(); // ds.Tables[1]; // entry.columns = new List<ColumnSet>(); foreach (DataRow r in ds.Tables[1].Rows) { PageDetail tmpPageDetail = new PageDetail(); // tmpPageDetail.columns = new List<ColumnSet>(); tmpPageDetail.id = (int)r["id"]; tmpPageDetail.area = (string)r["area"]; tmpPageDetail.table_name = (string)r["table_name"]; tmpPageDetail.module_id = (int)r["module_id"]; tmpPageDetail.comments = (string)r["comments"]; tmpPageDetail.name_text = (string)r["name_text"]; tmpPageDetail.class_name = (string)r["class_name"]; tmpPageDetail.table_description = ""; // tmpPageDetail.edit_flag = (int)r["edit_flag"]; entry.page_detail.Add(tmpPageDetail); data["page_detail_id"] = tmpPageDetail.id; DataSet ds2 = RunProcedureDataSet(data, "vdp_get_page_detail_for_gen_client", "sys"); int w = 0; ColumnSet cs; tmpPageDetail.columns = new List <ColumnSet>(); foreach (DataRow r2 in ds2.Tables[0].Rows) { cs = new ColumnSet(); cs.isInsert = (int)r2["isInsert"] == 0 ? false : true; cs.isShow = (int)r2["isShow"] == 0 ? false : true; cs.isUpdate = (int)r2["isUpdate"] == 0 ? false : true; cs.isRequired = (int)r2["isRequired"] == 0 ? false : true; cs.isWhere = (int)r2["isWhere"] == 0 ? false : true; tmpPageDetail.table_description = (string)r2["TableDescription"]; w = (int)r2["Length"] * 10; if (w > 500) { w = 500; } cs.width = w; cs.data = (string)r2["data"]; cs.valid = (string)r2["valid"]; cs.staticValue = (string)r2["staticValue"]; cs.FlagIdentity = (int)r2["FlagIdentity"]; cs.FlagPrimary = (int)r2["FlagPrimary"]; cs.ColumnName = (string)r2["ColumnName"]; cs.Type = (string)r2["type"]; cs.Size = (Int16)r2["size"]; cs.Length = (int)r2["length"]; cs.htmlType = (string)r2["htmlType"]; cs.ColumnCaption = (string)r2["ColumnCaption"]; cs.ColumnDescription = (string)r2["ColumnDescription"]; cs.staticValue = (string)r2["staticValue"]; cs.PrimaryField = (string)r2["PrimaryField"]; if ((int)r2["isIdentity"] == 1) { cs.IsIdentity = true; } else { cs.IsIdentity = false; } tmpPageDetail.columns.Add(cs); } } } //string p2 = Server.MapPath("\\") + "\\templates\\test2.data"; //FileStream fs3 = new FileStream(p2, FileMode.Create); //BinaryFormatter bf = new BinaryFormatter(); //bf.Serialize(fs3, entry); //fs3.Close(); Result[] r3 = mycs.CreateCode(JSToken, entry); return(r3); }