public static DAL.DO_ColumnDescription.UOList_ColumnDescription GetColumnDescription(ProjectParameter projParam, string tableName) { DAL.DO_ColumnDescription da = new GetTogether.Studio.Database.DAL.DO_ColumnDescription(); ConnectionInformation conInfo = new ConnectionInformation(); conInfo.ConnectionString = projParam.ConnectionString; conInfo.DbType = projParam.DatabaseTypeForCodeEngineer; da.SetConnectionInformation(conInfo); string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Format("SELECT C.Column_name as Name,case when C.extra='auto_increment' then 1 else 0 end as AutoIncrement FROM information_schema.`COLUMNS` C where C.table_schema='{0}' and table_name='{1}' and column_key='PRI'", BLL.BO_Common.GetDatabase(projParam), tableName); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = string.Format("select c.name column_name,p.value remark from sysproperties p join sysobjects o on p.id=o.id join syscolumns c on o.id=c.id and c.colid=p.smallid where p.name='MS_Description' and o.name='{0}'", tableName); try { return da.GetList(sql); } catch { string sqlRetry = string.Format("select c.name AS [Name],p.value Remark from sys.extended_properties p join sysobjects o on p.major_id=o.id join syscolumns c on o.id=c.id and c.colid=p.minor_id where p.name='MS_Description' and o.name='{0}'", tableName); return da.GetList(sqlRetry); } default: break; } return da.GetList(sql); }
public ActionResult ChargeSearch( string name = null, string town = null, int?year = null, string cityName = null, int?fid = null, ProjectOrder order = ProjectOrder.ID, int page = 1, int rows = 20) { var parameter = new ProjectParameter { Name = name, Town = town, Year = year, CityName = cityName, FID = fid, Order = order, ChargeID = Identity.UserID, IsRecord = true, // Page = new PageParameter(page, rows) }; var stringkey = Identity.UserID + ParameterManager.ParameterKey; SessionHelper.SetSession(stringkey, parameter); parameter.Page = new PageParameter(page, rows); SearchBase(parameter); return(View()); }
public void TestGetYorN() { var customProject = new ProjectParameter { SignificantDigits = 2, SpecificationOneConcRange = 7, SpecificationOne = 0.1, SpecificationTwoConcRange = 7, SpecificationTwo = 25 }; List <string> sampleNameList = new List <string> { "1", "2", "3", "4" }; List <double> targetSampleList = new List <double> { 1, 5, 10, 15 }; List <double> matchSampleList = new List <double> { 1.2, 4.91, 12.5, 13.5 }; var comparison = new Comparison(customProject, sampleNameList, targetName, targetSampleList, matchName, matchSampleList, scriptPath); comparison.GetYorN(); Assert.AreEqual("N,Y,N,Y", comparison.GetYorN()); }
/// <summary> /// 作用:高级查询 当前公司所有项目(登记编号已登记) /// </summary> /// <param name="name"></param> /// <param name="town"></param> /// <param name="year"></param> /// <param name="cityName"></param> /// <param name="fid"></param> /// <param name="groupName"></param> /// <param name="order"></param> /// <param name="chargeId"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> // GET: Project/Home public ActionResult Index( string name = null, string town = null, int?year = null, string cityName = null, string number = null, int?fid = null, int?seid = null, string groupName = null, ProjectOrder order = ProjectOrder.SerialDescending, int?chargeId = null, int page = 1, int rows = 20 ) { var parameter = new ProjectParameter { Name = name, Town = town, Year = year, CityName = cityName, GroupName = groupName, FID = fid, SEID = seid, Order = order, ChargeID = chargeId, IsRecord = true, Number = number, NumberIsNull = false //Page = new PageParameter(page, rows) }; var stringkey = Identity.UserID + ParameterManager.ParameterKey; SessionHelper.SetSession(stringkey, parameter); parameter.Page = new PageParameter(page, rows); SearchBase(parameter); ViewBag.Group = Core.UserGroupManager.Get(); ViewBag.Charges = Core.ProjectUserManager.GetChargeList(groupName); //var manager = Core.UserGroupManager.GetManager(Identity.UserID); //ViewBag.Manager = manager; return(View()); }
public void Pass_SetValue(bool originalNull, bool setToNull, ParameterSource source) { // Setup var name = Fakes.RandomString(); var value = Fakes.RandomString(); var scope = Fakes.RandomString(); var xmldoc = new XmlDocument(); // var parameterXml = CreateProjectParameterXml(name, false, originalNull, value, DataType.String); var parameterXml = XmlGenerators.ProjectFileParameter(name, value, false, DataType.String, originalNull); xmldoc.LoadXml(parameterXml); // Execute var parameter = new ProjectParameter(scope, xmldoc.DocumentElement); var newValue = setToNull ? null : Fakes.RandomString(); parameter.SetValue(newValue, source); var testValueFromXml = xmldoc.SelectSingleNode("//*[@SSIS:Name=\"Value\"]", xmldoc.GetNameSpaceManager())?.InnerText; // Assert Assert.Equal(newValue, parameter.Value); Assert.Equal(source, parameter.Source); Assert.Equal(newValue, testValueFromXml); }
public static string GetDatabase(ProjectParameter projParam) { using (IDbConnection conn = GetTogether.Data.ConnectionHelper.CreateConnection(projParam.ConnectionString, projParam.DatabaseTypeForCodeEngineer)) { return conn.Database; } }
public void Pass_New_ProjectParameter_InvalidDataType() { // Setup var name = Fakes.RandomString(); var value = Fakes.RandomString(); var scope = Fakes.RandomString(); var xmldoc = new XmlDocument(); var parameterXml = XmlGenerators.ProjectFileParameter(name, value, false, Fakes.RandomEnum <DataType>()); xmldoc.LoadXml(parameterXml); var dataTypeNode = xmldoc.SelectSingleNode("//*[@SSIS:Name=\"DataType\"]", xmldoc.GetNameSpaceManager()); if (dataTypeNode != null) { dataTypeNode.InnerText = "xyz"; } // Execute var parameter = new ProjectParameter(scope, xmldoc.DocumentElement); // Assert Assert.NotNull(parameter); Assert.Equal(null, parameter.ParameterDataType?.Name); }
private void CreateProjects() { if (IsGetNewProject) { Response.Write(GetProjectContent(new ProjectParameter().ToXml(), "Create", "ProjectExec('txtProject',1);")); Response.End(); } else { try { ProjectParameter st = new ProjectParameter(); st = st.FormXml(Content); string filePath = string.Concat(ProjectParameter.GetSettingsPath(CurrentSession.UserCode), st.ProjectName); if (System.IO.File.Exists(filePath)) { Response.Write(string.Concat("The project \"", st.ProjectName, "\" already existed.")); } else { System.IO.File.WriteAllText(ProjectParameter.GetSettingsPath(CurrentSession.UserCode) + st.ProjectName, st.ToXml()); Response.Write("OK"); } } catch (Exception ex) { Response.Write(ex.Message); } } }
/// <summary> /// 作用:主要针对袁洋 查询公司未登记编号的项目 (公司未登记项目查询) /// </summary> /// <param name="name"></param> /// <param name="town"></param> /// <param name="year"></param> /// <param name="cityName"></param> /// <param name="fid"></param> /// <param name="order"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public ActionResult Manager( string name = null, string town = null, string number = null, int?year = null, string cityName = null, string groupName = null, int?fid = null, ProjectOrder order = ProjectOrder.SerialDescending, int?chargeId = null, int page = 1, int rows = 20) { var parameter = new ProjectParameter { Name = name, Town = town, Year = year, CityName = cityName, GroupName = groupName, FID = fid, Order = order, ChargeID = chargeId, IsRecord = false, Number = number, NumberIsNull = true, FlowDataState = FlowwDataState.Done, Page = new PageParameter(page, rows) }; SearchBase(parameter); ViewBag.Group = Core.UserGroupManager.Get(); ViewBag.Charges = Core.UserManager.GetAllUsers(); return(View()); }
protected void Page_Load(object sender, EventArgs e) { try { Parameter = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName); Generator = new CodeGenerator(Parameter); ColumnInfos = Generator.GetColumnsInfo(TableName, PrimaryKeyOverwrite); ReferFolder = Path.Combine(Server.MapPath(".."), "Manage\\Refer"); OutputFolder = Path.Combine(Server.MapPath(".."), string.Concat("Manage\\", CurrentSession.UserCode, "\\", TableName)); if (!System.IO.Directory.Exists(OutputFolder)) System.IO.Directory.CreateDirectory(OutputFolder); switch (type) { case 1: Search(); Callback(); Result(); Edit(); GetTogether.Mapping.MappingInfoCache.Caches.Clear(); if (!string.IsNullOrEmpty(Request["download"])) Compress(OutputFolder, string.Concat(OutputFolder, "-Management.zip")); break; default: break; } JsonSuccess(); } catch (Exception ex) { JsonError(ex.Message); } }
public static DataSet GetDataSet(ProjectParameter projParam, string sql) { DO_Common da = new DO_Common(); ConnectionInformation connInfo = da.GetCurrentConnectionInformation(); SetConnectionInformation(connInfo, projParam); da.SetConnectionInformation(connInfo); return da.GetDataSet(sql); }
/// <summary> /// /// </summary> /// <returns></returns> public ActionResult Groups(int page = 1, int rows = 20) { var parameter = new ProjectParameter { GroupId = Group.ID, Page = new PageParameter(page, rows) }; SearchBase(parameter); return(View()); }
public override async void Close() { base.Close(); AREditorResources.Instance.LeftMenuProject.UpdateVisibility(); dropdown.Dropdown.dropdownItems.Clear(); projectParameter = null; if (!cancelCallbackInvoked) { onCloseCallback?.Invoke((string)nameInput.GetValue()); } }
public static System.Data.IDataReader GetDataReader(ProjectParameter projParam, string sql) { DO_Common da = new DO_Common(); ConnectionInformation connInfo = da.GetCurrentConnectionInformation(); SetConnectionInformation(connInfo, projParam); connInfo.TableName = sql; connInfo.IsSqlSentence = true; da.SetConnectionInformation(connInfo); System.Data.IDbConnection conn = da.GetCurrentConnectionInformation().Connection; return da.GetIDbCommand(conn, null, 1, true).ExecuteReader(); }
public static void GetObjectByPrimaryKeyString(StringBuilder sbCodes, ProjectParameter projParam, string tableName) { sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get object by primary key string."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetObjectByPrimaryKeyString(string primaryKeyString)", projParam.DOPrefix, tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine(string.Format("\t\t\t{0}{1}.{2}{1} l = da.GetList(GetConditionsByPrimaryKeyString(primaryKeyString));", projParam.DOPrefix, tableName, projParam.UOListPrefix)); sbCodes.AppendLine("\t\t\treturn l.Count > 0 ? l[0] : null;"); sbCodes.AppendLine("\t\t}"); }
public ActionResult Check() { var parameter = new ProjectParameter { GroupId = Identity.GroupId, FlowDataState = FlowwDataState.Checking, NumberIsNull = true }; var list = Core.ProjectManager.Search(parameter); ViewBag.List = list; return(View()); }
/// <summary> /// /*{Result:Result1,Result2,Result3}*/ /// </summary> /// <param name="projParam"></param> /// <param name="spName"></param> /// <returns></returns> public static string[] GetStoreProcedureObjectMapping(ProjectParameter projParam, string spName) { string text = GetStoreProcedureText(projParam, spName); if (string.IsNullOrEmpty(text)) return null; System.Text.RegularExpressions.Regex regx = new System.Text.RegularExpressions.Regex("{Result:.*?}", System.Text.RegularExpressions.RegexOptions.IgnoreCase); System.Text.RegularExpressions.Match m = regx.Match(text); if (m.Success && !string.IsNullOrEmpty(m.Value)) { string mv = m.Value.Substring(m.Value.IndexOf(':') + 1); mv = mv.Substring(0, mv.Length - 1); return mv.Split(','); } return null; }
public static string GetString(ProjectParameter projParam, string sql, string fieldName) { using (IDataReader dReader = GetDataReader(projParam, sql)) { StringBuilder sbResult = new StringBuilder(); while (dReader.Read()) { if (string.IsNullOrEmpty(fieldName)) sbResult.Append(dReader[0]); else sbResult.Append(dReader[fieldName]); } return sbResult.ToString(); } }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } ProjectParameter = await _context.ProjectParameter.FirstOrDefaultAsync(m => m.ID == id); if (ProjectParameter == null) { return(NotFound()); } return(Page()); }
public static GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter.UOList_StoreProcedureParameter GetStoreProcedureParameters(ProjectParameter projParam, string spName) { string sql = StoreProcedure.GetStoreProcedureText(projParam, spName); bool isFoundStoreProcName = false; GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter.UOList_StoreProcedureParameter spParameters = new GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter.UOList_StoreProcedureParameter(); foreach (string s in sql.Split(new string[] { "\r\n" }, StringSplitOptions.None)) { if (string.IsNullOrEmpty(s) || s.Trim() == "") continue; string sUpper = s.Trim().ToUpper(); if (sUpper.IndexOf(spName.ToUpper()) > 0) { isFoundStoreProcName = true; continue; } if (sUpper.IndexOf("BEGIN") >= 0) { break; } if (isFoundStoreProcName) { foreach (string sParameter in s.Split(',')) { if (sParameter.Trim() == "") continue; GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter.UO_StoreProcedureParameter p = new GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter.UO_StoreProcedureParameter(); string[] parameterInfo = sParameter.Trim().Replace(" ", " ").Replace(" ", " ").Split(' '); if (parameterInfo.Length >= 3) { p.IsOutParam = parameterInfo[0].Trim().ToUpper() == "OUT" ? 1 : 0; p.Name = parameterInfo[1]; string[] dataTypeInfo = parameterInfo[2].Split('('); if (dataTypeInfo.Length > 1) { p.DataType = dataTypeInfo[0]; p.Length = (short)GetTogether.Utility.NumberHelper.ToInt(dataTypeInfo[1].Replace(")", ""), 0); } else { p.DataType = parameterInfo[2]; } spParameters.Add(p); } } } } return spParameters; }
private void SearchBase(ProjectParameter parameter) { ViewBag.Year = Core.ProjectManager.GetYears(); ViewBag.Provinces = Core.CityManager.Search(new Model.CityParameter { Rank = Model.Rank.Province }); ViewBag.Types = Core.Project_TypeManager.GetByPPID(0); var list = Core.ProjectManager.Search(parameter); ViewBag.List = list; ViewBag.Parameter = parameter; if (parameter.FID.HasValue) { ViewBag.STypes = Core.Project_TypeManager.GetByPPID(parameter.FID.Value); } }
public static string GetStoreProcedureSimple(ProjectParameter st, string spName) { Database.DAL.DO_StoreProcedureParameter.UOList_StoreProcedureParameter spParameters = BLL.StoreProcedure.GetStoreProcedureParameters(st, spName); StringBuilder sbInput = new StringBuilder(); switch (st.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: foreach (Database.DAL.DO_StoreProcedureParameter.UO_StoreProcedureParameter p in spParameters) { string v = "0"; if (ColumnMapping.FromDatabaseType(p.DataType).Equals("string")) { v = string.Format("'{0}'", p.Name); } sbInput.Append(v).Append(","); } if (sbInput.Length > 0) sbInput.Remove(sbInput.Length - 1, 1); sbInput.Insert(0, string.Format("Call {0}(", spName)); sbInput.Append(")"); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: for (int i = 0; i < spParameters.Count; i++) { Database.DAL.DO_StoreProcedureParameter.UO_StoreProcedureParameter p = spParameters[i]; string v = "0"; if (ColumnMapping.FromDatabaseType(p.DataType).Equals("string")) { v = "N''"; } sbInput.Append("\t").Append(p.Name).Append(" = ").Append(v); if (i < spParameters.Count - 1) sbInput.Append(","); sbInput.Append("\t\t--Database type:").Append(p.DataType); sbInput.Append(", Length:").Append(p.Length); sbInput.Append(", Is nullable:").AppendLine(p.IsNullAble > 0 ? "True" : "False"); } if (sbInput.Length > 0) sbInput.Remove(sbInput.Length - 1, 1); sbInput.Insert(0, string.Format("EXEC\t[{0}]\r\n", spName)); break; default: break; } return sbInput.ToString(); }
/// <summary> /// 页面切换事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void xtraTabControl1_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e) { if (xtraTabControl1.SelectedTabPageIndex == 0) { xtraTabPage2.Controls.Clear(); //xtraTabPage3.Controls.Clear(); if (projectParameter == null) { projectParameter = new ProjectParameter(); projectParameter.AssayProInfoEvent += AssayProInfo_Event; } projectParameter.ProjectParameter_Load(null, null); xtraTabPage1.Controls.Add(projectParameter); } else if (xtraTabControl1.SelectedTabPageIndex == 1) { xtraTabPage1.Controls.Clear(); //xtraTabPage3.Controls.Clear(); if (calibrationParameter == null) { calibrationParameter = new CalibrationParameter(); calibrationParameter.AssayProInfoForCalibParamEvent += AssayProInfo_Event; } if (lstAssayProInfos.Count != 0) { calibrationParameter.ListAssayprojectInfos = lstAssayProInfos; } calibrationParameter.CalibrationParameter_Load(null, null); xtraTabPage2.Controls.Add(calibrationParameter); } //else if (xtraTabControl1.SelectedTabPageIndex == 2) //{ // xtraTabPage1.Controls.Clear(); // xtraTabPage2.Controls.Clear(); // if (rangeParameter == null) // { // rangeParameter = new RangeParameter(); // rangeParameter.AssayProInfoForRangeParamEvent += AssayProInfo_Event; // } // if (lstAssayProInfos.Count != 0) // { // rangeParameter.ListAssayprojectInfos = lstAssayProInfos; // } // xtraTabPage3.Controls.Add(rangeParameter); //} }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } ProjectParameter = await _context.ProjectParameter.FindAsync(id); if (ProjectParameter != null) { _context.ProjectParameter.Remove(ProjectParameter); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
private ProjectParameterButton GenerateParameterButton(ProjectParameter projectParameter) { ProjectParameterButton btn = Instantiate(ConstantButtonPrefab, ContentConstants.transform).GetComponent <ProjectParameterButton>(); btn.Id = projectParameter.Id; btn.SetName(projectParameter.Name); btn.SetValue(Base.Parameter.GetValue <string>(projectParameter.Value)); btn.Button.onClick.AddListener(async() => { if (!await EditConstantDialog.Init((_) => Show(), Show, projectParameter)) { return; } Hide(); EditConstantDialog.Open(); }); return(btn); }
public void Pass_New_ProjectParameter_CoverDataTypes(DataType type) { // Setup var name = Fakes.RandomString(); var value = Fakes.RandomString(); var scope = Fakes.RandomString(); var xmldoc = new XmlDocument(); var parameterXml = XmlGenerators.ProjectFileParameter(name, value, false, type); xmldoc.LoadXml(parameterXml); // Execute var parameter = new ProjectParameter(scope, xmldoc.DocumentElement); // Assert Assert.NotNull(parameter); Assert.Equal((int)type == 1000 ? null : type.ToString("G"), parameter.ParameterDataType?.Name, StringComparer.InvariantCultureIgnoreCase); }
public void Pass_New_ProjectParameter_DataTypeValidation() { // Setup var name = Fakes.RandomString(); var value = "False"; var scope = Fakes.RandomString(); var xmldoc = new XmlDocument(); var parameterXml = XmlGenerators.ProjectFileParameter(name, value, false, DataType.Boolean); xmldoc.LoadXml(parameterXml); // Execute var parameter = new ProjectParameter(scope, xmldoc.DocumentElement); // Assert Assert.NotNull(parameter); Assert.Equal("false", parameter.Value); }
public static DataSet GetStoreProcedures(ProjectParameter projParam) { string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Format("SELECT specific_name as Name,created as CreateOn,last_altered as UpdateOn FROM information_schema.ROUTINES where ROUTINE_SCHEMA='{0}' ORDER BY specific_name", BLL.BO_Common.GetDatabase(projParam)); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = "select [Name],crdate as CreateOn from sysobjects where xtype='p' and category=0 order by name"; break; default: break; } return BLL.BO_Common.GetDataSet(projParam, sql); }
public static System.Data.IDataReader GetDataReaderByTable(ProjectParameter projParam, string table) { string sql = ""; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Concat("select * from ", table, " limit 1,1"); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = string.Concat("select top 1 * from ", table); break; default: break; } return GetDataReader(projParam, sql); }
public static DAL.DO_StoreProcedureParameter.UOList_StoreProcedureParameter GetStoreProcedureParameters(ProjectParameter projParam, string spName) { string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: return Database.BLL.MySQL.GetStoreProcedureParameters(projParam, spName); case DatabaseType.Oracle: break; case DatabaseType.SQLServer: DAL.DO_StoreProcedureParameter da = new GetTogether.Studio.Database.DAL.DO_StoreProcedureParameter(); da.GetCurrentConnectionInformation().DbType = projParam.DatabaseTypeForCodeEngineer; da.GetCurrentConnectionInformation().ConnectionString = projParam.ConnectionString; sql = string.Format("select sc.name as [Name],st.name DataType,st.length Length,sc.isnullable as IsNullAble,isoutparam as IsOutParam from systypes st right join syscolumns sc on st.xtype=sc.xtype right join sysobjects so on sc.id=so.id where so.xtype='p' and category=0 and so.name='{0}' and st.name<>'sysname'", spName); return da.GetList(sql); default: break; } return null; }
/// <summary> /// 创建代码 /// </summary> /// <param name="parameter"></param> /// <param name="type"></param> /// <param name="methodIndexs"></param> public void Create(ProjectParameter parameter, ExtensionType type, AjaxMethod[] methodIndexs) { AutoParameter = parameter; Type = type; Methods = methodIndexs; Namespace = type.Type.Namespace; if (Namespace == AutoParameter.DefaultNamespace) { Namespace = AutoCSerAPI; } else { Namespace = Namespace.StartsWith(AutoParameter.DefaultNamespace, StringComparison.Ordinal) && Namespace[AutoParameter.DefaultNamespace.Length] == '.' ? AutoCSerAPI + Namespace.Substring(AutoParameter.DefaultNamespace.Length) : Namespace; } _code_.Length = 0; create(false); code.Add(_code_); }
public static List<string> GetAutoIncrement(ProjectParameter projParam, string tableName) { string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Format("select C.Column_name as Name FROM INFORMATION_SCHEMA.`COLUMNS` C where C.table_schema='{0}' and table_name='{1}' and extra='auto_increment'", BLL.BO_Common.GetDatabase(projParam), tableName); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = string.Format("select sc.name AS [Name] from sysobjects so Inner Join syscolumns sc on so.id = sc.id where columnproperty(sc.id, sc.name, 'IsIdentity') = 1 and upper(so.name) = upper('{0}')", tableName); break; default: break; } using (System.Data.IDbConnection conn = GetTogether.Data.ConnectionHelper.CreateConnection(projParam.ConnectionString, projParam.DatabaseTypeForCodeEngineer)) { return GetTogether.Data.DbUtil.GetExecuteList<string>(conn, sql, projParam.DatabaseTypeForCodeEngineer); } }
public ActionResult PartSearch(string name = null, string town = null, int?year = null, string cityName = null, int?fid = null, ProjectOrder order = ProjectOrder.ID, int page = 1, int rows = 20) { var parameter = new ProjectParameter { Name = name, Town = town, Year = year, CityName = cityName, FID = fid, Order = order, Participation = Identity.Name, IsRecord = true, Page = new PageParameter(page, rows) }; SearchBase(parameter); return(View()); }
/// <summary> /// 界面初始化加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void ChemicalParameter_Load(object sender, EventArgs e) { if (projectParameter == null) { projectParameter = new ProjectParameter(); projectParameter.AssayProInfoEvent += AssayProInfo_Event; } else { projectParameter.ClearProjectParamMemberPropertier(); } if (xtraTabControl1.SelectedTabPageIndex != 0) { xtraTabControl1.SelectedTabPageIndex = 0; } else { projectParameter.ProjectParameter_Load(null, null); xtraTabPage1.Controls.Add(projectParameter); } }
protected void Page_Load(object sender, EventArgs e) { this.Title = ProjectName; Parameter = ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName, CurrentSession.ShareUserCode); if (Parameter == null) { Response.Redirect("Index.aspx"); } if (!string.IsNullOrEmpty(CurrentSession.ShareUserCode)) { GetTogether.Utility.DirectoryHelper.CopyParameter cp = new GetTogether.Utility.DirectoryHelper.CopyParameter(); cp.Source = GetPath(CurrentSession.ShareUserCode); if (System.IO.Directory.Exists(cp.Source)) { cp.Destination = GetPath(CurrentSession.UserCode); if (!System.IO.Directory.Exists(cp.Destination)) System.IO.Directory.CreateDirectory(cp.Destination); cp.IsOverwrite = true; GetTogether.Utility.DirectoryHelper.Copy(cp); } } if (!string.IsNullOrEmpty(Request["gc"])) { Codes = WsdlHelper.GetCodes(Parameter.Address); Response.ContentType = "text/plain"; Response.Write(Codes); Response.End(); } else { ProjectHistory ph = Projects.GetProjectHistory(ProjectParameter.GetSettingsPath(CurrentSession.UserCode), ProjectName); if (ph == null) { ph = new ProjectHistory(); } ph.RecentUsed = DateTime.Now; string path = GetTogether.Studio.WebService.Projects.GetProjectHistoryFile(ProjectParameter.GetSettingsPath(CurrentSession.UserCode), ProjectName, true); GetTogether.Utility.FileHelper.SerializeToFile(ph, path); } }
/// <summary> /// 作用:个人录入未登记编号的项目 (未登记项目查询) /// </summary> /// <returns></returns> public ActionResult Search( string name = null, string town = null, int?year = null, string cityName = null, int?fid = null, ProjectOrder order = ProjectOrder.SerialDescending, int page = 1, int rows = 20) { var parameter = new ProjectParameter { Name = name, Town = town, Year = year, CityName = cityName, FID = fid, Order = order, ChargeID = Identity.UserID, IsRecord = false, Page = new PageParameter(page, rows) }; SearchBase(parameter); return(View()); }
public ComparisonTest() { targetName = "target"; matchName = "match"; scriptPath = @"C:\Users\lihua\source\repos\ReportGeneratorV2\ReportGenerator\wwwroot"; project = new ProjectParameter { ID = 1, Name = "Test", ALE = 25, LOQ = 0.08, SignificantDigits = 1, SpecificationOneConcRange = 0, SpecificationOne = 0.01, SpecificationTwoConcRange = 0, SpecificationTwo = 10, Unit = "nmol/L", Xc1 = 1, Xc2 = 10 }; }
public Comparison(ProjectParameter project, List <string> sampleNameList, string targetInstrumentName, List <double> targetSampleList, string matchInstrumentName, List <double> matchSampleList, string scriptPath) { _project = project; _sampleNameList = sampleNameList; _targetResultList = targetSampleList; _matchResultList = matchSampleList; _biasList = new List <string>(); _yORnList = new List <string>(); pb = new PassingBablokRegression(scriptPath, targetInstrumentName, _targetResultList, matchInstrumentName, _matchResultList); }
public void Pass_New_ProjectParameter(bool sensitive, bool withValue, DataType type) { // Setup var name = Fakes.RandomString(); var value = Fakes.RandomString(); var scope = Fakes.RandomString(); var xmldoc = new XmlDocument(); var parameterXml = XmlGenerators.ProjectFileParameter(name, value, sensitive, type, withValue); xmldoc.LoadXml(parameterXml); // Execute var parameter = new ProjectParameter(scope, xmldoc.DocumentElement); // Assert Assert.NotNull(parameter); Assert.Equal(withValue ? value : null, parameter.Value); Assert.Equal(type.ToString("G"), parameter.ParameterDataType.Name, StringComparer.InvariantCultureIgnoreCase); Assert.Equal(sensitive, parameter.Sensitive); Assert.Equal($"{scope}::{name}", parameter.Name); Assert.Equal(ParameterSource.Original, parameter.Source); }
public static DAL.DO_ColumnDetail.UOList_ColumnDetail GetColumnDetail(ProjectParameter projParam, string tableName) { DAL.DO_ColumnDetail da = new GetTogether.Studio.Database.DAL.DO_ColumnDetail(); ConnectionInformation conInfo = new ConnectionInformation(); conInfo.ConnectionString = projParam.ConnectionString; conInfo.DbType = projParam.DatabaseTypeForCodeEngineer; da.SetConnectionInformation(conInfo); string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Format("select column_name AS ColumnName,column_default AS DefaultValue,case when is_nullable='YES' THEN 1 ELSE 0 end AS IsNullable,data_type AS DataType,character_maximum_length as MaxLength from INFORMATION_SCHEMA.COLUMNS where table_name='{0}'", tableName); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = string.Format("select column_name AS ColumnName,column_default AS DefaultValue,case when is_nullable='YES' THEN 1 ELSE 0 end AS IsNullable,data_type AS DataType,character_maximum_length as MaxLength from INFORMATION_SCHEMA.COLUMNS where table_name='{0}'", tableName); break; default: break; } return da.GetList(sql); }
public static string GetDAL( ProjectParameter projParam, string tableName, ColumnMapping.ColumnInfos colInfos, Database.DAL.DO_ColumnDescription.UOList_ColumnDescription columnDescriptions, bool appendUsing) { StringBuilder sbCodes = new StringBuilder(); if (appendUsing) { sbCodes.AppendLine(string.Format(@" //------------------------------------------------------------------------------ // <auto-generated> // Date time = {1} // This code was generated by tool,Version={0}. // Changes to this code may cause incorrect behavior and will be lost if the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------", Config.Version, DateTime.Now)); sbCodes.AppendLine("using System;"); sbCodes.AppendLine("using System.Collections.Generic;"); sbCodes.AppendLine("using System.Text;"); sbCodes.AppendLine("using GetTogether.Data;"); sbCodes.AppendLine("using GetTogether.Mapping;"); sbCodes.AppendLine(""); sbCodes.Append("namespace ").AppendLine(projParam.DataObjectNameSpace); sbCodes.AppendLine("{"); } sbCodes.AppendLine(string.Format("\tpublic partial class {1}{0} : DOBase<{1}{0}.{2}{0}, {1}{0}.{3}{0}>", tableName, projParam.DOPrefix, projParam.UOPrefix, projParam.UOListPrefix)); sbCodes.AppendLine("\t{"); StringBuilder sbPks = new StringBuilder(); foreach (ColumnMapping.ColumnInfo p in colInfos) { if (p.IsPrimaryKey) { if (p.ColumnName.Trim().IndexOf(" ") > 0) p.ColumnName = p.ColumnName.Trim().Replace(" ", "_space_"); if (sbPks.Length > 0) sbPks.Append(", "); sbPks.Append("\"").Append(p.ColumnName).Append("\""); } } sbPks.Insert(0, "new string[] {"); sbPks.Append("}"); sbCodes.Append(@" public static ConnectionInformation GetConnectionInformation() { return new ConnectionInformation( ""{Table}"", {ConnectionKey}, {PrimaryKey}, {DatabaseType}); }".Replace("{Table}", tableName).Replace("{ConnectionKey}", projParam.ConnectionKey).Replace("{PrimaryKey}", sbPks.ToString()).Replace("{DatabaseType}", projParam.DatabaseTypeVariables)); sbCodes.AppendLine(@" public override ConnectionInformation GetDefaultConnectionInformation() { return GetConnectionInformation(); }"); sbCodes.AppendLine("\t\tpublic enum Columns"); sbCodes.AppendLine("\t\t{"); StringBuilder sb_columns = new StringBuilder(); sb_columns.AppendLine("\t\t\t#region Columns"); foreach (ColumnMapping.ColumnInfo c in colInfos) { if (c.ColumnName.Trim().IndexOf(" ") > 0) c.ColumnName = c.ColumnName.Trim().Replace(" ", "_space_"); StringBuilder sbColumnInfo = new StringBuilder(); if (c.IsPrimaryKey) { sbColumnInfo.Append("Primary Key"); } //sbColumnInfo.Append("Database Type:").Append(c.ColumnType); if (c.IsAutoIncrement) { sbColumnInfo.Append(",Auto Increment"); } foreach (Database.DAL.DO_ColumnDescription.UO_ColumnDescription r in columnDescriptions) { if (r.Name.Equals(c.ColumnName) && !string.IsNullOrEmpty(r.Remark)) { sbColumnInfo.Append(",Remark:").Append(r.Remark); break; } } if (sbColumnInfo.Length > 0) { sbCodes.AppendLine("\t\t\t/// <summary>"); sbCodes.Append("\t\t\t///").AppendLine(sbColumnInfo.ToString()); sbCodes.AppendLine("\t\t\t/// </summary>"); } sbCodes.Append("\t\t\t").Append(c.ColumnName).AppendLine(","); string vtype = c.ColumnType;// ColumnMapping.GetColumnType(c.Column); sb_columns.AppendLine(string.Format("\t\t\tprivate {0} _{1};", vtype, c.ColumnName)); if (sbColumnInfo.Length > 0) { sb_columns.AppendLine("\t\t\t/// <summary>"); sb_columns.Append("\t\t\t///").AppendLine(sbColumnInfo.ToString()); sb_columns.AppendLine("\t\t\t/// </summary>"); } sb_columns.Append(string.Format("\t\t\t[Mapping(\"{0}", c.ColumnName)); if (c.IsAutoIncrement) { sb_columns.Append(",un-insert,un-update"); } else if (c.IsPrimaryKey) { sb_columns.Append(",un-update"); } else if (projParam.UnInsertAndUnUpdate.ToLower().IndexOf(c.ColumnName.ToLower()) >= 0) { sb_columns.Append(",un-insert,un-update"); } else if (projParam.UnInsert.ToLower().IndexOf(c.ColumnName.ToLower()) >= 0) { sb_columns.Append(",un-insert"); } else if (projParam.UnUpdate.ToLower().IndexOf(c.ColumnName.ToLower()) >= 0) { sb_columns.Append(",un-update"); } sb_columns.AppendLine("\")]"); sb_columns.AppendLine(string.Format("\t\t\tpublic {0} {1}", vtype, c.ColumnName)); sb_columns.AppendLine("\t\t\t{"); sb_columns.AppendLine("\t\t\t\tget"); sb_columns.AppendLine("\t\t\t\t{"); sb_columns.AppendLine(string.Format("\t\t\t\t\treturn _{0};", c.ColumnName)); sb_columns.AppendLine("\t\t\t\t}"); sb_columns.AppendLine("\t\t\t\tset"); sb_columns.AppendLine("\t\t\t\t{"); sb_columns.AppendLine(string.Format("\t\t\t\t\t_{0} = value;", c.ColumnName)); sb_columns.AppendLine("\t\t\t\t}"); sb_columns.AppendLine("\t\t\t}"); } sb_columns.Append("\t\t\t#endregion"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(string.Format("\t\tpublic {1}{0}()", tableName, projParam.DOPrefix)); sbCodes.AppendLine("\t\t{"); //if (listPK.Count > 0) //{ // sbCodes.AppendLine(string.Format("\t\t\tConnInfo = new ConnectionInformation(\"{0}\", {1},{2});", tableName, cf.ConnectionKey, sbPks.ToString())); //} //else //{ // sbCodes.AppendLine(string.Format("\t\t\tConnInfo = new ConnectionInformation(\"{0}\", {1});", tableName, cf.ConnectionKey)); //} sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(string.Format("\t\tpublic partial class {1}{0} : UOBase<{1}{0},{2}{0}>", tableName, projParam.UOPrefix, projParam.UOListPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(@"public override ConnectionInformation GetDefaultConnectionInformation() { return GetConnectionInformation(); }"); sbCodes.AppendLine(sb_columns.ToString()); sbCodes.AppendLine(string.Format("\t\t\tpublic {1}{0}()", tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t\t{"); //sbCodes.AppendLine(string.Format("\t\t\t\tConnInfo = new {0}{1}().ConnInfo;", cf.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\t}"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(string.Format("\t\tpublic partial class {1}{0} : GetTogether.ObjectBase.ListBase<{2}{0}>", tableName, projParam.UOListPrefix, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\tpublic {1}{0}()", tableName, projParam.UOListPrefix)); sbCodes.AppendLine("\t\t\t{"); sbCodes.AppendLine("\t\t\t}"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t}"); if (appendUsing) { sbCodes.AppendLine("}"); } return sbCodes.ToString(); }
public CodeGenerator(ProjectParameter st) { this._Parameter = st; }
/// <summary> /// 获取 TcpCall 调用类型名称 /// </summary> /// <param name="namespaceString"></param> /// <param name="type"></param> /// <returns></returns> public static string GetTcpCallTypeName(ProjectParameter parameter, ExtensionType type) { return(parameter.DefaultNamespace + ".TcpCall." + type.TypeName); }
private void EditProjects() { if (IsGetNewProject) { try { Response.Write(GetProjectContent(ProjectParameter.GetSettingsByProjectName(CurrentSession.UserCode, ProjectName, CurrentSession.ShareUserCode).ToXml(), "Save", "ProjectExec('txtProject',2);")); } catch (Exception ex) { Response.Write(ex.Message); } Response.End(); } else { try { ProjectParameter pj = new ProjectParameter(); pj = pj.FormXml(Content); string filePath = string.Concat(ProjectParameter.GetSettingsPath(CurrentSession.UserCode), pj.ProjectName); System.IO.File.WriteAllText(ProjectParameter.GetSettingsPath(CurrentSession.UserCode) + pj.ProjectName, pj.ToXml()); Response.Write("OK"); } catch (Exception ex) { Response.Write(ex.Message); } } }
public static string GetBLL(ProjectParameter projParam, string objName, string storeProcName) { StringBuilder sbArgs = new StringBuilder(); StringBuilder sbArgsValues = new StringBuilder(); StringBuilder sbParameters = new StringBuilder(); sbParameters.AppendLine("\t\t\tList<IDataParameter> parameters = new List<IDataParameter>();"); sbParameters.AppendLine(""); foreach (Database.DAL.DO_StoreProcedureParameter.UO_StoreProcedureParameter p in Database.BLL.StoreProcedure.GetStoreProcedureParameters(projParam, storeProcName)) { if (p.IsOutParam > 0) continue; string paramName = p.Name.Replace("@", ""); if (sbArgs.Length > 0) sbArgs.Append(", "); if (sbArgsValues.Length > 0) sbArgsValues.Append(", "); sbArgsValues.Append(paramName); sbArgs.Append(GetTogether.Studio.Database.ColumnMapping.FromDatabaseType(p.DataType)).Append(" ").Append(paramName); if (GetTogether.Studio.Database.ColumnMapping.FromDatabaseType(p.DataType).Equals("DateTime")) { sbParameters.AppendLine(string.Format("\t\t\tparameters.Add(new System.Data.SqlClient.SqlParameter(\"{0}\", {1}.ToString(\"yyyyMMdd\", System.Globalization.DateTimeFormatInfo.InvariantInfo)));", p.Name, paramName)); } else { sbParameters.AppendLine(string.Format("\t\t\tparameters.Add(new System.Data.SqlClient.SqlParameter(\"{0}\", {1}));", p.Name, paramName)); } } StringBuilder sbCodes = new StringBuilder(); sbCodes.AppendLine(string.Format(@"//------------------------------------------------------------------------------ // <auto-generated> // Date time = {1} // This code was generated by tool,Version={0}. // Changes to this code may cause incorrect behavior and will be lost if the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------", Config.Version, DateTime.Now)); sbCodes.AppendLine("using System;"); sbCodes.AppendLine("using System.Collections.Generic;"); sbCodes.AppendLine("using System.Text;"); sbCodes.AppendLine("using System.Data;"); sbCodes.AppendLine("using GetTogether.Data;"); sbCodes.Append("using ").Append(projParam.DataObjectNameSpace).AppendLine(";"); sbCodes.AppendLine(""); sbCodes.Append("namespace ").AppendLine(projParam.BusinessObjectNameSpace); sbCodes.AppendLine("{"); sbCodes.AppendLine(string.Format("\tpublic partial class {0}{1}", projParam.BOPrefix, objName)); sbCodes.AppendLine("\t{"); sbCodes.Append("\t\t#region This source code was auto-generated by tool,Version=").AppendLine(Config.Version); sbCodes.AppendLine("\t\t/// <summary>"); sbCodes.AppendLine("\t\t/// Get parameters"); sbCodes.AppendLine("\t\t/// </summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static IDataParameter[] GetParameters({0})", sbArgs.ToString())); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(sbParameters.ToString()); sbCodes.AppendLine("\t\t\treturn parameters.ToArray();"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t/// <summary>"); sbCodes.AppendLine("\t\t/// Get object result"); sbCodes.AppendLine("\t\t/// </summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.Results GetResults({3}{2})", projParam.DOPrefix, objName, sbArgs.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, objName)); sbCodes.AppendLine(string.Format("\t\t\treturn da.GetResults(GetParameters({0}));", sbArgsValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t/// <summary>"); sbCodes.AppendLine("\t\t/// Get DataSet result"); sbCodes.AppendLine("\t\t/// </summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static DataSet GetDataSet({1}{0})", sbArgs.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, objName)); sbCodes.AppendLine(string.Format("\t\t\treturn da.GetDataSet(GetParameters({0}));", sbArgsValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine("\t\t#region User extensions"); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine("\t}"); sbCodes.AppendLine("}"); return sbCodes.ToString(); }
public static DAL.DO_PrimaryKey.UOList_PrimaryKey GetPrimaryKey(ProjectParameter projParam, string tableName) { string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = string.Format("SELECT C.Column_name as Name,case when C.extra='auto_increment' then 1 else 0 end as AutoIncrement FROM information_schema.`COLUMNS` C where C.table_schema='{0}' and table_name='{1}' and column_key='PRI' ORDER BY C.Column_name", BLL.BO_Common.GetDatabase(projParam), tableName); break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = string.Format("select syscolumns.name AS [Name],columnproperty(syscolumns.id, syscolumns.name, 'IsIdentity') AS AutoIncrement from syscolumns,sysobjects,sysindexes,sysindexkeys where syscolumns.id = object_id('{0}') and sysobjects.xtype = 'pk' and sysobjects.parent_obj = syscolumns.id and sysindexes.id = syscolumns.id and sysobjects.name = sysindexes.name and sysindexkeys.id = syscolumns.id and sysindexkeys.indid = sysindexes.indid and syscolumns.colid = sysindexkeys.colid ORDER BY [Name]", tableName); break; default: break; } DAL.DO_PrimaryKey da = new GetTogether.Studio.Database.DAL.DO_PrimaryKey(); ConnectionInformation conInfo = new ConnectionInformation(); conInfo.ConnectionString = projParam.ConnectionString; conInfo.DbType = projParam.DatabaseTypeForCodeEngineer; da.SetConnectionInformation(conInfo); GetTogether.Studio.Database.DAL.DO_PrimaryKey.UOList_PrimaryKey primaryKeys = da.GetList(sql); if (primaryKeys == null || primaryKeys.Count == 0) { List<string> autoIncrementColumns = BLL.Table.GetAutoIncrement(projParam, tableName); primaryKeys = new GetTogether.Studio.Database.DAL.DO_PrimaryKey.UOList_PrimaryKey(); foreach (string pk in autoIncrementColumns) { Database.DAL.DO_PrimaryKey.UO_PrimaryKey upk = new GetTogether.Studio.Database.DAL.DO_PrimaryKey.UO_PrimaryKey(); upk.Name = pk; primaryKeys.Add(upk); } } return primaryKeys; }
public static DataSet GetTables(ProjectParameter projParam) { string sql = string.Empty; switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: sql = "select table_name as Name,table_type as TableType from INFORMATION_SCHEMA.tables where table_type<>'system view' and table_schema='{Database}' ORDER BY table_name"; break; case DatabaseType.Oracle: break; case DatabaseType.SQLServer: sql = "select Table_Name as Name,Table_Type as TableType from INFORMATION_SCHEMA.tables where table_catalog='{Database}' ORDER BY [Name]"; break; default: break; } sql = sql.Replace("{Database}", BLL.BO_Common.GetDatabase(projParam)); return BLL.BO_Common.GetDataSet(projParam, sql); }
public static string GetDAL(ProjectParameter projParam, IDataReader dr, string objName, string storeProcName, string returnObjMapping) { string[] objMapping = null; if (string.IsNullOrEmpty(returnObjMapping)) objMapping = Database.BLL.StoreProcedure.GetStoreProcedureObjectMapping(projParam, storeProcName); else objMapping = returnObjMapping.Split(','); int index = 1; StringBuilder sbCodes = new StringBuilder(); Dictionary<int, ColumnMapping.ColumnInfos> tableColumnInfos = new Dictionary<int, ColumnMapping.ColumnInfos>(); tableColumnInfos[index] = ColumnMapping.GetColumnInfo(dr, projParam, string.Empty, string.Empty); while (dr.NextResult()) { index++; tableColumnInfos[index] = ColumnMapping.GetColumnInfo(dr, projParam, string.Empty, string.Empty); } sbCodes.AppendLine(string.Format(@" //------------------------------------------------------------------------------ // <auto-generated> // Date time = {1} // This code was generated by tool,Version={0}. // Changes to this code may cause incorrect behavior and will be lost if the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------", Config.Version, DateTime.Now)); sbCodes.AppendLine("using System;"); sbCodes.AppendLine("using System.Collections.Generic;"); sbCodes.AppendLine("using System.Text;"); sbCodes.AppendLine("using System.Data;"); sbCodes.AppendLine("using GetTogether.Data;"); sbCodes.AppendLine("using GetTogether.Mapping;"); sbCodes.AppendLine(""); sbCodes.Append("namespace ").AppendLine(projParam.DataObjectNameSpace); sbCodes.AppendLine("{"); StringBuilder sbObjects = new StringBuilder(); StringBuilder sbAttributes = new StringBuilder(); for (int i = 1; i <= tableColumnInfos.Count; i++) { sbObjects.AppendLine(GetSubDAL(projParam, i, tableColumnInfos[i], objMapping)); sbObjects.Append("\t\t").AppendLine(string.Format("public class {0}{1}: List<{2}{1}>", projParam.UOListPrefix, GetObjectName(i, objMapping), projParam.UOPrefix)); sbObjects.AppendLine("\t\t{"); sbObjects.AppendLine(string.Format("\t\t\tpublic {0}{1}()", projParam.UOListPrefix, GetObjectName(i, objMapping))); sbObjects.AppendLine("\t\t\t{"); sbObjects.AppendLine("\t\t\t}"); sbObjects.AppendLine("\t\t}"); sbAttributes.AppendLine(string.Format("\t\tprivate {0}{1} _{1};", projParam.UOListPrefix, GetObjectName(i, objMapping))); sbAttributes.AppendLine(string.Format("\t\tpublic {0}{1} {1}", projParam.UOListPrefix, GetObjectName(i, objMapping))); sbAttributes.AppendLine("\t\t{"); sbAttributes.AppendLine("\t\t\tget"); sbAttributes.AppendLine("\t\t\t{"); sbAttributes.AppendLine(string.Format("\t\t\t\treturn this._{0};", GetObjectName(i, objMapping))); sbAttributes.AppendLine("\t\t\t}"); sbAttributes.AppendLine("\t\t\tset"); sbAttributes.AppendLine("\t\t\t{"); sbAttributes.AppendLine(string.Format("\t\t\t\tthis._{0} = value;", GetObjectName(i, objMapping))); sbAttributes.AppendLine("\t\t\t}"); sbAttributes.AppendLine("\t\t}"); } sbCodes.AppendLine(string.Format("\tpublic class {0}{1} : StoreProcBase<{0}{1}, {0}{1}.Results>", projParam.DOPrefix, objName)); sbCodes.AppendLine("\t{"); sbCodes.AppendLine(@"public static StoreProcInformation GetConnectionInformation() { return new StoreProcInformation( {ConnectionKey}, ""{StoreProcedureName}"", {DatabaseType}); } public override StoreProcInformation GetDefaultConnectionInformation() { return GetConnectionInformation(); }".Replace("{ConnectionKey}", projParam.ConnectionKey).Replace("{StoreProcedureName}", storeProcName).Replace("{DatabaseType}", projParam.DatabaseTypeVariables)); sbCodes.AppendLine(string.Format("\t\tpublic {0}{1}()", projParam.DOPrefix, objName)); sbCodes.AppendLine("\t\t{"); //sbCodes.AppendLine(string.Format("\t\t\tStoreProcInfo = new StoreProcInformation({0}, \"{1}\",{2});", cf.ConnectionKey, storeProcName,cf.DatabaseTypeVariables)); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\tpublic override Results GetResults(IDataParameter[] parameters)"); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine("\t\t\tusing(this.GetCurrentConnectionInformation().Connection)"); sbCodes.AppendLine("\t\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t\tResults results{0} = new Results();", objName)); sbCodes.AppendLine("\t\t\t\tIDataReader dr = GetDataReader(parameters);"); sbCodes.AppendLine(string.Format("\t\t\t\tresults{0}.{3} = ObjectHelper.FillCollection<{1}{3}, {2}{3}>(dr);", objName, projParam.UOPrefix, projParam.UOListPrefix, GetObjectName(1, objMapping))); for (int i = 2; i <= tableColumnInfos.Count; i++) { sbCodes.AppendLine("\t\t\t\tif (dr.NextResult())"); sbCodes.AppendLine("\t\t\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t\t\t\tresults{0}.{1} = ObjectHelper.FillCollection<{2}{1}, {3}{1}>(dr);", objName, GetObjectName(i, objMapping), projParam.UOPrefix, projParam.UOListPrefix)); sbCodes.AppendLine("\t\t\t\t}"); } sbCodes.AppendLine(string.Format("\t\t\t\treturn results{0};", objName)); sbCodes.AppendLine("\t\t\t}"); sbCodes.AppendLine("\t\t}"); //sbCodes.AppendLine("\t\tpublic override IDataReader GetDataReader(IDataParameter[] parameters)"); //sbCodes.AppendLine("\t\t{"); //sbCodes.AppendLine("\t\t\treturn GetTogether.Data.SQL.SqlUtil.ExecuteProcedureReader(StoreProcInfo.Connection, StoreProcInfo.StoreProcName, parameters);"); //sbCodes.AppendLine("\t\t}"); //sbCodes.AppendLine("\t\tpublic override DataSet GetDataSet(IDataParameter[] parameters)"); //sbCodes.AppendLine("\t\t{"); //sbCodes.AppendLine("\t\t\tusing(this.StoreProcInfo.Connection)"); //sbCodes.AppendLine("\t\t\t{"); //sbCodes.AppendLine("\t\t\t\treturn GetTogether.Data.SQL.SqlUtil.ExecuteProcedureDataSet(StoreProcInfo.Connection, StoreProcInfo.StoreProcName, parameters);"); //sbCodes.AppendLine("\t\t\t}"); //sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\tpublic class Results"); sbCodes.AppendLine("\t\t\t{"); sbCodes.AppendLine("\t\t\t\t#region Attributes"); sbCodes.AppendLine(sbAttributes.ToString()); sbCodes.AppendLine("\t\t\t\t#endregion"); sbCodes.AppendLine("\t\t\t\tpublic Results()"); sbCodes.AppendLine("\t\t\t\t{"); sbCodes.AppendLine("\t\t\t\t}"); sbCodes.AppendLine("\t\t\t}"); sbCodes.AppendLine("\t\t#region Return objects"); sbCodes.Append(sbObjects.ToString()); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine("\t}"); sbCodes.AppendLine("}"); return sbCodes.ToString(); }
public static string GetBLL(ProjectParameter projParam, string tableName, ColumnMapping.ColumnInfos colInfos, bool isSentence, bool appendUsing) { StringBuilder sbCodes = new StringBuilder(), sbPrimaryKeyConditions = new StringBuilder(), sbPrimaryKeyParameters = new StringBuilder(), sbPrimaryKeyValues = new StringBuilder(), sbAutoIncrementParameters = new StringBuilder(), sbAutoIncrementConditions = new StringBuilder(), sbAutoIncrementValues = new StringBuilder(); #region Paging Conditions StringBuilder sbPagingCondition = new StringBuilder(); sbPagingCondition.AppendLine("\t\t\tParameterCollection objectConditions = new ParameterCollection();"); sbPagingCondition.AppendLine("\t\t\tTokenTypes tt = tokenTypes;"); sbPagingCondition.AppendLine("\t\t\tParameterType pt = isAnd ? ParameterType.And : ParameterType.Or;"); foreach (ColumnMapping.ColumnInfo c in colInfos) { if (c.ColumnName.Trim().IndexOf(" ") > 0) c.ColumnName = c.ColumnName.Replace(" ", "_space_"); if (c.ColumnType.IndexOf("String") >= 0) { sbPagingCondition.AppendLine(string.Format("\t\t\tif (!string.IsNullOrEmpty(parameterObj.{0}))", c.ColumnName)); sbPagingCondition.AppendLine("\t\t\t{"); sbPagingCondition.AppendLine(string.Format("\t\t\t\tobjectConditions.AddCondition(pt, GetColumnTokenType(tt,{0}{1}.Columns.{2},extTokens), {0}{1}.Columns.{2},parameterObj.{2});", projParam.DOPrefix, tableName, c.ColumnName)); sbPagingCondition.AppendLine("\t\t\t}"); } else if (c.ColumnType.IndexOf("Int") >= 0 || c.ColumnType.IndexOf("Decimal") >= 0 || c.ColumnType.IndexOf("Float") >= 0) { sbPagingCondition.AppendLine(string.Format("\t\t\tif (parameterObj.{0} != 0 || (extTokens != null && extTokens.ContainsKey({1}{2}.Columns.{0})))", c.ColumnName, projParam.DOPrefix, tableName)); sbPagingCondition.AppendLine("\t\t\t{"); sbPagingCondition.AppendLine(string.Format("\t\t\t\tobjectConditions.AddCondition(pt, GetColumnTokenType(tt,{0}{1}.Columns.{2},extTokens), {0}{1}.Columns.{2},parameterObj.{2});", projParam.DOPrefix, tableName, c.ColumnName)); sbPagingCondition.AppendLine("\t\t\t}"); } else if (c.ColumnType.Equals("DateTime")) { sbPagingCondition.AppendLine(string.Format("\t\t\tif (parameterObj.{0} != DateTime.MinValue)", c.ColumnName)); sbPagingCondition.AppendLine("\t\t\t{"); sbPagingCondition.AppendLine(string.Format("\t\t\t\tobjectConditions.AddCondition(pt, GetColumnTokenType(tt,{0}{1}.Columns.{2},extTokens), {0}{1}.Columns.{2},parameterObj.{2});", projParam.DOPrefix, tableName, c.ColumnName)); sbPagingCondition.AppendLine("\t\t\t}"); } } #endregion #region Primary Key sbPrimaryKeyConditions.AppendLine("\t\t\tParameterCollection primaryConditions = new ParameterCollection();"); int index = 0; foreach (ColumnMapping.ColumnInfo ci in colInfos) { if (ci.IsPrimaryKey) { if (ci.ColumnName.Trim().IndexOf(" ") > 0) ci.ColumnName = ci.ColumnName.Trim().Replace(" ", "_space_"); if (sbPrimaryKeyParameters.Length > 0) sbPrimaryKeyParameters.Append(","); sbPrimaryKeyParameters.Append(ColumnMapping.GetColumnType(colInfos, ci.ColumnName)).Append(" ").Append(ci.ColumnName); if (sbPrimaryKeyValues.Length > 0) sbPrimaryKeyValues.Append(","); sbPrimaryKeyValues.Append(ci.ColumnName); if (index == 0) { sbPrimaryKeyConditions.AppendLine(string.Format("\t\t\tprimaryConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, {0}{1}.Columns.{2}, {2});", projParam.DOPrefix, tableName, ci.ColumnName, ci.ColumnName)); } else { sbPrimaryKeyConditions.AppendLine(string.Format("\t\t\tprimaryConditions.AddCondition(ParameterType.And, TokenTypes.Equal, {0}{1}.Columns.{2}, {2});", projParam.DOPrefix, tableName, ci.ColumnName, ci.ColumnName)); } index++; } } #endregion #region Auto Increment if (colInfos.AutoIncrements.Count > 0) { sbAutoIncrementConditions.AppendLine("\t\t\tParameterCollection autoIncrementConditions = new ParameterCollection();"); int autoIncrementIndex = 0; foreach (ColumnMapping.ColumnInfo ci in colInfos) { if (ci.IsAutoIncrement) { string name = ci.ColumnName; if (name.Trim().IndexOf(" ") > 0) name = name.Trim().Replace(" ", "_space_"); if (sbAutoIncrementParameters.Length > 0) sbAutoIncrementParameters.Append(","); sbAutoIncrementParameters.Append(ColumnMapping.GetColumnType(colInfos, name)).Append(" ").Append(name); if (sbAutoIncrementValues.Length > 0) sbAutoIncrementValues.Append(","); sbAutoIncrementValues.Append(name); if (autoIncrementIndex == 0) { sbAutoIncrementConditions.AppendLine(string.Format("\t\t\tautoIncrementConditions.AddCondition(ParameterType.Initial, TokenTypes.Equal, {0}{1}.Columns.{2}, {2});", projParam.DOPrefix, tableName, name, name)); } else { sbAutoIncrementConditions.AppendLine(string.Format("\t\t\tautoIncrementConditions.AddCondition(ParameterType.And, TokenTypes.Equal, {0}{1}.Columns.{2}, {2});", projParam.DOPrefix, tableName, name, name)); } autoIncrementIndex++; } } } #endregion #region Using if (appendUsing) { sbCodes.AppendLine(string.Format(@"//------------------------------------------------------------------------------ // <auto-generated> // Date time = {1} // This code was generated by tool,Version={0}. // Changes to this code may cause incorrect behavior and will be lost if the code is regenerated. // </auto-generated> //------------------------------------------------------------------------------", Config.Version, DateTime.Now)); sbCodes.AppendLine("using System;"); sbCodes.AppendLine("using System.Collections.Generic;"); sbCodes.AppendLine("using System.Text;"); sbCodes.AppendLine("using System.Data;"); sbCodes.AppendLine("using GetTogether.Data;"); sbCodes.Append("using ").Append(projParam.DataObjectNameSpace).AppendLine(";"); sbCodes.AppendLine(""); sbCodes.Append("namespace ").AppendLine(projParam.BusinessObjectNameSpace); sbCodes.AppendLine("{"); } #endregion sbCodes.AppendLine(string.Format("\tpublic partial class {0}{1}", projParam.BOPrefix, tableName)); sbCodes.AppendLine("\t{"); #region Conditions sbCodes.AppendLine("\t\t#region Condition functions"); if (colInfos.PrimaryKeys.Count > 0) { TableScriptHelper.GetConditionsByPrimaryKeyString(sbCodes, colInfos, sbPrimaryKeyValues); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get conditions by primary key."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static ParameterCollection GetConditionsByPrimaryKey({0})", sbPrimaryKeyParameters.ToString())); sbCodes.AppendLine("\t\t{"); sbCodes.Append(sbPrimaryKeyConditions.ToString()); sbCodes.AppendLine("\t\t\treturn primaryConditions;"); sbCodes.AppendLine("\t\t}"); } if (colInfos.AutoIncrements.Count > 0) { sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get conditions by primary key."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static ParameterCollection GetConditionsById({0})", sbAutoIncrementParameters.ToString())); sbCodes.AppendLine("\t\t{"); sbCodes.Append(sbAutoIncrementConditions.ToString()); sbCodes.AppendLine("\t\t\treturn autoIncrementConditions;"); sbCodes.AppendLine("\t\t}"); } sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get the tokenType of the column of condition query."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tprivate static TokenTypes GetColumnTokenType(TokenTypes defaultTokenType,{0}{1}.Columns column,Dictionary<{0}{1}.Columns,TokenTypes> extTokens)", projParam.DOPrefix, tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine("\t\t\tif (extTokens != null && extTokens.ContainsKey(column))"); sbCodes.AppendLine("\t\t\t\treturn extTokens[column];"); sbCodes.AppendLine("\t\t\telse"); sbCodes.AppendLine("\t\t\t\treturn defaultTokenType;"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get conditions by object with Multi-TokenType."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static ParameterCollection GetConditionsByObject({0}{1}.{2}{1} parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<{0}{1}.Columns, TokenTypes> extTokens)", projParam.DOPrefix, tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.Append(sbPagingCondition.ToString()); sbCodes.AppendLine("\t\t\treturn objectConditions;"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine(""); #endregion #region Query sbCodes.AppendLine("\t\t#region Query functions"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get all records."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetAllList({3})", projParam.DOPrefix, tableName, projParam.UOListPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\treturn da.GetAllList();"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get all records count."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static int GetAllRecordsCount({0})", "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\treturn da.GetRecordsCount();"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get records count."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static int GetRecordsCount({3}{0}{1}.{2}{1} parameterObj)", projParam.DOPrefix, tableName, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn GetRecordsCount({0}parameterObj, true, TokenTypes.Equal,null);", "")); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get records count."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static int GetRecordsCount({3}{0}{1}.{2}{1} parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<{0}{1}.Columns, TokenTypes> extTokens)", projParam.DOPrefix, tableName, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\treturn da.GetRecordsCount(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get list by object."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetList({4}{0}{1}.{3}{1} parameterObj, bool isAnd, TokenTypes tokenTypes, Dictionary<{0}{1}.Columns, TokenTypes> extTokens)", projParam.DOPrefix, tableName, projParam.UOListPrefix, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine("\t\t\treturn parameterObj.GetList(GetConditionsByObject(parameterObj, isAnd, tokenTypes, extTokens));"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get list by object."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetList({4}{0}{1}.{3}{1} parameterObj)", projParam.DOPrefix, tableName, projParam.UOListPrefix, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn GetList({0}parameterObj, true, TokenTypes.Equal, null);", "")); sbCodes.AppendLine("\t\t}"); if (colInfos.PrimaryKeys.Count > 0) { sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get object by primary key."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetObject({4}{3})", projParam.DOPrefix, tableName, projParam.UOPrefix, sbPrimaryKeyParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine(string.Format("\t\t\t{0}{1}.{2}{1} l = da.GetList(GetConditionsByPrimaryKey({3}));", projParam.DOPrefix, tableName, projParam.UOListPrefix, sbPrimaryKeyValues.ToString())); sbCodes.AppendLine("\t\t\treturn l.Count > 0 ? l[0] : null;"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); TableScriptHelper.GetObjectByPrimaryKeyString(sbCodes, projParam, tableName); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get paging list."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static PagingResult<{0}{1}.{3}{1}, {0}{1}.{2}{1}> GetPagingList({4}{0}{1}.{3}{1} parameterObj,int pageNumber, int pageSize,string sortBy,bool isAsc, bool isAnd, TokenTypes tokenTypes, Dictionary<{0}{1}.Columns, TokenTypes> extTokens)", projParam.DOPrefix, tableName, projParam.UOListPrefix, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn parameterObj.GetPagingList(GetConditionsByObject(parameterObj, isAnd, tokenTypes,extTokens), pageNumber, pageSize, sortBy, isAsc);", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get paging list."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static PagingResult<{0}{1}.{3}{1}, {0}{1}.{2}{1}> GetPagingList({4}{0}{1}.{3}{1} parameterObj,int pageNumber, int pageSize,string sortBy,bool isAsc)", projParam.DOPrefix, tableName, projParam.UOListPrefix, projParam.UOPrefix, "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn parameterObj.GetPagingList(GetConditionsByObject(parameterObj, true, TokenTypes.Like,null), pageNumber, pageSize, sortBy, isAsc);", "")); sbCodes.AppendLine("\t\t}"); } if (colInfos.AutoIncrements.Count > 0) { sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Get object by Id."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static {0}{1}.{2}{1} GetObjectById({4}{3})", projParam.DOPrefix, tableName, projParam.UOPrefix, sbAutoIncrementParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine(string.Format("\t\t\t{0}{1}.{2}{1} l = da.GetList(GetConditionsById({3}));", projParam.DOPrefix, tableName, projParam.UOListPrefix, sbAutoIncrementValues.ToString())); sbCodes.AppendLine("\t\t\treturn l.Count > 0 ? l[0] : null;"); sbCodes.AppendLine("\t\t}"); } sbCodes.AppendLine("\t\t#endregion"); #endregion if (colInfos.PrimaryKeys.Count > 0 && !isSentence) { #region Update sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t#region Update functions"); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Update object by primary key."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static bool UpdateObject({4}{0}{1}.{2}{1} obj, {3})", projParam.DOPrefix, tableName, projParam.UOPrefix, sbPrimaryKeyParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn obj.Update(GetConditionsByPrimaryKey({0})) > 0;", sbPrimaryKeyValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Update object by primary key(with transation)."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static bool UpdateObject({4}{0}{1}.{2}{1} obj, {3}, IDbConnection connection, IDbTransaction transaction)", projParam.DOPrefix, tableName, projParam.UOPrefix, sbPrimaryKeyParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\treturn obj.Update(connection, transaction, GetConditionsByPrimaryKey({0})) > 0;", sbPrimaryKeyValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Update object by primary key string."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static bool UpdateObjectByPrimaryKeyString({0}{1}.{2}{1} obj, string primaryKeyString)", projParam.DOPrefix, tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine("\t\t\treturn obj.Update(GetConditionsByPrimaryKeyString(primaryKeyString)) > 0;"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Update object by primary key string(with transation)."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static bool UpdateObjectByPrimaryKeyString({0}{1}.{2}{1} obj, string primaryKeyString, IDbConnection connection, IDbTransaction transaction)", projParam.DOPrefix, tableName, projParam.UOPrefix)); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine("\t\t\treturn obj.Update(connection, transaction, GetConditionsByPrimaryKeyString(primaryKeyString)) > 0;"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine(""); #endregion #region Delete sbCodes.AppendLine("\t\t#region Delete functions"); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Delete object by primary key."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static int Delete({1}{0})", sbPrimaryKeyParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine(string.Format("\t\t\treturn da.Delete(GetConditionsByPrimaryKey({0}));", sbPrimaryKeyValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Delete object by primary key(with transation)."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine(string.Format("\t\tpublic static int Delete({1}{0}, IDbConnection connection, IDbTransaction transaction)", sbPrimaryKeyParameters.ToString(), "")); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine(string.Format("\t\t\treturn da.Delete(connection, transaction, GetConditionsByPrimaryKey({0}));", sbPrimaryKeyValues.ToString())); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Delete object by primary key string."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine("\t\tpublic static int DeleteByPrimaryKeyString(string primaryKeyString)"); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\treturn da.Delete(GetConditionsByPrimaryKeyString(primaryKeyString));"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine(""); sbCodes.AppendLine("\t\t///<summary>"); sbCodes.AppendLine("\t\t///Delete object by primary key string(with transation)."); sbCodes.AppendLine("\t\t///</summary>"); sbCodes.AppendLine("\t\tpublic static int DeleteByPrimaryKeyString(string primaryKeyString, IDbConnection connection, IDbTransaction transaction)"); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\t{0}{1} da = new {0}{1}();", projParam.DOPrefix, tableName)); sbCodes.AppendLine("\t\t\treturn da.Delete(connection, transaction, GetConditionsByPrimaryKeyString(primaryKeyString));"); sbCodes.AppendLine("\t\t}"); sbCodes.AppendLine("\t\t#endregion"); sbCodes.AppendLine(""); #endregion } sbCodes.AppendLine("\t}"); if (appendUsing) { sbCodes.AppendLine("}"); } return sbCodes.ToString(); }
public static string GetDAL(ProjectParameter projParam, string objName, string spName, string simpleSql, string returnObjMapping) { using (IDataReader dr = Database.BLL.BO_Common.GetDataReader(projParam, simpleSql)) { return GetDAL(projParam, dr, objName, spName, returnObjMapping); } }
public static void SetConnectionInformation(ConnectionInformation connInfo, ProjectParameter projParam) { connInfo.ConnectionString = projParam.ConnectionString; connInfo.DbType = projParam.DatabaseTypeForCodeEngineer; }
public static string GetSubDAL(ProjectParameter projParam, int index, ColumnMapping.ColumnInfos colInfos, string[] objMapping) { StringBuilder sbCodes = new StringBuilder(); sbCodes.AppendLine(string.Format("\t\tpublic class {0}{1}", projParam.UOPrefix, GetObjectName(index, objMapping))); sbCodes.AppendLine("\t\t{"); sbCodes.AppendLine(string.Format("\t\t\tpublic {0}{1}()", projParam.UOPrefix, GetObjectName(index, objMapping))); sbCodes.AppendLine("\t\t\t{"); sbCodes.AppendLine("\t\t\t}"); StringBuilder sb_columns = new StringBuilder(); sb_columns.AppendLine("\t\t\t#region Columns"); foreach (ColumnMapping.ColumnInfo c in colInfos) { sb_columns.AppendLine(string.Format("\t\t\tprivate {0} _{1};", c.ColumnType, c.ColumnName)); sb_columns.Append(string.Format("\t\t\t[Mapping(\"{0}", c.ColumnName)); sb_columns.AppendLine("\")]"); sb_columns.AppendLine(string.Format("\t\t\tpublic {0} {1}", c.ColumnType, c.ColumnName)); sb_columns.AppendLine("\t\t\t{"); sb_columns.AppendLine("\t\t\t\tget"); sb_columns.AppendLine("\t\t\t\t{"); sb_columns.AppendLine(string.Format("\t\t\t\t\treturn _{0};", c.ColumnName)); sb_columns.AppendLine("\t\t\t\t}"); sb_columns.AppendLine("\t\t\t\tset"); sb_columns.AppendLine("\t\t\t\t{"); sb_columns.AppendLine(string.Format("\t\t\t\t\t_{0} = value;", c.ColumnName)); sb_columns.AppendLine("\t\t\t\t}"); sb_columns.AppendLine("\t\t\t}"); } sb_columns.AppendLine("\t\t\t#endregion"); sbCodes.AppendLine(sb_columns.ToString()); sbCodes.Append("\t\t}"); return sbCodes.ToString(); }
private bool cancelCallbackInvoked; //flag: only cancel callback should be invoked if canceled /// <summary> /// /// </summary> /// <param name="projectParameter"></param> public async Task <bool> Init(System.Action <string> onCloseCallback, System.Action onCancelCallback, ProjectParameter projectParameter = null, string ofType = null) { this.projectParameter = projectParameter; isNewConstant = projectParameter == null; this.onCloseCallback = onCloseCallback; this.onCancelCallback = onCancelCallback; cancelCallbackInvoked = false; dropdown.Dropdown.dropdownItems.Clear(); foreach (string type in Enum.GetNames(typeof(ProjectParameterTypes))) { CustomDropdown.Item item = new CustomDropdown.Item { itemName = type, OnItemSelection = new UnityEvent() }; item.OnItemSelection.AddListener(() => OnTypeSelected(type)); dropdown.Dropdown.dropdownItems.Add(item); } if (isNewConstant) { Title.text = "New project parameter"; removeButton.SetActive(false); nameInput.SetValue(""); valueInput.SetValue(""); OnTypeSelected(ofType == null ? ProjectParameterTypes.integer : ProjectParametersHelper.ConvertStringParameterTypeToEnum(ofType)); dropdown.Dropdown.selectedItemIndex = (int)selectedType; dropdown.Dropdown.SetupDropdown(); dropdown.Dropdown.GetComponent <Button>().interactable = ofType == null; } else //editing constant { try { await WebsocketManager.Instance.WriteLock(projectParameter.Id, false); Title.text = "Edit project parameter"; removeButton.SetActive(true); nameInput.SetValue(projectParameter.Name); OnTypeSelected(projectParameter.Type); dropdown.Dropdown.selectedItemIndex = (int)selectedType; dropdown.Dropdown.SetupDropdown(); dropdown.Dropdown.GetComponent <Button>().interactable = false; object value = ProjectParametersHelper.GetValue(projectParameter.Value, selectedType); if (selectedType == ProjectParameterTypes.boolean) { trueToggle.isOn = (bool)value; } else { valueInput.SetValue(value); } } catch (RequestFailedException e) { Notifications.Instance.ShowNotification("Failed to lock " + projectParameter.Name, e.Message); this.projectParameter = null; return(false); } } return(true); }
public ProjectParameterEventArgs(ProjectParameter projectParameter) { ProjectParameter = projectParameter; }
public List <ProjectView> Search(ProjectParameter parameter) { var query = DB.Project_Views.Where(e => e.Deleted == false).AsQueryable(); if (parameter.FlowDataState.HasValue) { query = query.Where(e => e.FlowwDataState == parameter.FlowDataState.Value); } if (!string.IsNullOrEmpty(parameter.Name)) { query = query.Where(e => e.Name.Contains(parameter.Name)); } if (parameter.NumberIsNull.HasValue) { query = query.Where(e => parameter.NumberIsNull.Value ^ !string.IsNullOrEmpty(e.Number)); } if (!string.IsNullOrEmpty(parameter.Town)) { query = query.Where(e => e.Town.Contains(parameter.Town)); } if (!string.IsNullOrEmpty(parameter.Number)) { query = query.Where(e => e.Number.Contains(parameter.Number.Trim())); } if (parameter.Year.HasValue) { query = query.Where(e => e.Year == parameter.Year.Value); } if (parameter.CityId.HasValue) { query = query.Where(e => e.CityId == parameter.CityId.Value); } if (!string.IsNullOrEmpty(parameter.CityName)) { query = query.Where(e => e.CityName.Contains(parameter.CityName)); } if (parameter.GroupId.HasValue) { query = query.Where(e => e.GroupId == parameter.GroupId.Value); } if (!string.IsNullOrEmpty(parameter.GroupName)) { query = query.Where(e => e.GroupName == parameter.GroupName); } if (parameter.FID.HasValue) { query = query.Where(e => e.FID == parameter.FID.Value); } if (parameter.SEID.HasValue) { query = query.Where(e => e.ProjectTypeId == parameter.SEID.Value); } if (parameter.ChargeID.HasValue) { query = query.Where(e => e.UserId == parameter.ChargeID.Value); } if (parameter.IsRecord.HasValue) { query = query.Where(e => (string.IsNullOrEmpty(e.Number) ^ parameter.IsRecord.Value)); } if (!string.IsNullOrEmpty(parameter.Participation)) { query = query.Where(e => !string.IsNullOrEmpty(e.Participation)); query = query.Where(e => e.Participation.ToLower().Contains(parameter.Participation.ToLower())); } switch (parameter.Order) { case ProjectOrder.ID: query = query.OrderBy(e => e.ID); break; case ProjectOrder.IDDescending: query = query.OrderByDescending(e => e.ID); break; case ProjectOrder.Number: query = query.OrderBy(e => e.Number); break; case ProjectOrder.NumberDescending: query = query.OrderByDescending(e => e.Number); break; case ProjectOrder.Serial: query = query.OrderBy(e => e.Year).ThenBy(e => e.SerialNumber); break; case ProjectOrder.SerialDescending: query = query.OrderByDescending(e => e.Year).ThenByDescending(e => e.SerialNumber); break; } query = query.SetPage(parameter.Page); return(query.ToList()); }
public static string GetStoreProcedureText(ProjectParameter projParam, string spName) { switch (projParam.DatabaseTypeForCodeEngineer) { case DatabaseType.MySQL: return BLL.BO_Common.GetString(projParam, string.Concat("show create procedure ", spName), "Create Procedure"); case DatabaseType.Oracle: break; case DatabaseType.SQLServer: return BLL.BO_Common.GetString(projParam, string.Concat("sp_helptext ", spName), string.Empty); default: break; } return string.Empty; }