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;
}
