private void AddButton_Click(object sender, RoutedEventArgs e)
{
this.ErrorMessagePromptName.Text = "";
this.ErrorMessagePromptFilePath.Text = "";
bool verifyFlag = true;
ProjectConfig projectConfig = new ProjectConfig();
Dictionary <string, RuleAndErrorMessage> dictRule = projectConfig.GetProjectInfoRegularExpression();
RuleAndErrorMessage rule = dictRule["Name"];
Regex exminator = new Regex(rule.Rule);
if (!exminator.IsMatch(this.ProjectNameInputTextBox.Text))
{
this.ErrorMessagePromptName.Text = rule.ErrorMessage;
verifyFlag = false;
}
if (string.IsNullOrEmpty(this.FilePathInputTextBox.Text))
{
this.ErrorMessagePromptFilePath.Text += "请选择有效路径";
verifyFlag = false;
}
if (verifyFlag)
{
SCA.Model.ProjectModel project = new Model.ProjectModel();
project.Name = this.ProjectNameInputTextBox.Text;
project.SavePath = this.FilePathInputTextBox.Text + "\\" + project.Name + ".nt";
project.FileVersion = BusinessLogic.DBFileVersionManager.CurrentDBFileVersion;
SCA.BusinessLib.ProjectManager.GetInstance.CreateProject(project);
RaiseEvent(new RoutedEventArgs(AddButtonClickEvent));
}
}
public List <Model.ControllerModel> GetControllersByProject(Model.ProjectModel project)
{
//List<ControllerModel> lstControllers=new List<ControllerModel>();
//StringBuilder sbQuerySQL = new StringBuilder("select id,primaryflag,typeid,deviceaddresslength,name,portname,baudrate,machinenumber,version from controller where projectid=" + project.ID);
//System.Data.DataTable dt = _databaseService.GetDataTableBySQL(sbQuerySQL);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// Model.ControllerModel model = new Model.ControllerModel();
// model.ID = Convert.ToInt16(dt.Rows[i]["id"]);
// model.PrimaryFlag = (bool)dt.Rows[i]["PRIMARYFLAG"];
// model.Type = (ControllerType)Enum.ToObject(typeof(ControllerType), Convert.ToInt32(dt.Rows[i]["TYPEID"]));
// model.DeviceAddressLength = dt.Rows[i]["DEVICEADDRESSLENGTH"] is System.DBNull ? 0 : Convert.ToInt16(dt.Rows[i]["DEVICEADDRESSLENGTH"]);
// model.Name = dt.Rows[i]["Name"].ToString();
// model.PortName = dt.Rows[i]["PORTNAME"].ToString();
// model.BaudRate = Convert.ToInt32(dt.Rows[i]["BAUDRATE"]);
// model.MachineNumber = dt.Rows[i]["MACHINENUMBER"].ToString();
// model.Version = Convert.ToInt16(dt.Rows[i]["VERSION"]);
// model.ProjectID = project.ID;
// model.Project = project;
// model.LoopAddressLength = 2;
// lstControllers.Add(model);
//}
//return lstControllers;
return(_dbFileVersionService.GetControllersByProject(project));
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
SCA.Model.ProjectModel project = new Model.ProjectModel();
project.Name = this.ProjectNameInputTextBox.Text;
project.SavePath = this.FilePathInputTextBox.Text;
SCA.BusinessLib.ProjectManager.GetInstance.CreateProject(project);
RaiseEvent(new RoutedEventArgs(AddButtonClickEvent));
}
public Model.ProjectModel GetProject(Model.ProjectModel project)
{
StringBuilder sbQueryProjectSQL = new StringBuilder("select id,name,saveinterval,savepath from project where id=" + project.ID);
System.Data.DataTable dt = _databaseService.GetDataTableBySQL(sbQueryProjectSQL);
Model.ProjectModel model = new Model.ProjectModel();
model.ID = Convert.ToInt16(dt.Rows[0]["id"]);
model.Name = dt.Rows[0]["name"].ToString();
model.SavePath = dt.Rows[0]["savepath"] is System.DBNull ? null : dt.Rows[0]["savepath"].ToString();
model.SaveInterval = dt.Rows[0]["saveinterval"] is System.DBNull ? 0 : Convert.ToInt16(dt.Rows[0]["saveinterval"]);
return(model);
}
private void ConfirmButton_Click(object sender, RoutedEventArgs e)
{
SCA.Model.ProjectModel project = new Model.ProjectModel();
project.Name = this.ProjectNameInputTextBox.Text;
project.SavePath = SaveFilePathInputTextBox.Text;
string strImportedFilePath = ImportFilePathInputTextBox.Text;
//string strProjectFileSavePath = SaveFilePathInputTextBox.Text;
//string strProjectName = ProjectNameInputTextBox.Text;
// project.SavePath = this.FilePathInputTextBox.Text;
//~~~~~~~~
IFileService _fileService = new FileService();
IDatabaseService _databaseService;
ILogRecorder _logRecorder;
_databaseService = new MSAccessDatabaseAccess(strImportedFilePath, null, _fileService);
IOldVersionSoftwareDBService oldVersionService = new OldVersionSoftware8036DBService(_databaseService);
IControllerOperation controllerOperation = null;
string[] strFileInfo = oldVersionService.GetFileVersionAndControllerType();
ControllerModel controllerInfo = null;
if (strFileInfo.Length > 0)
{
switch (strFileInfo[0])
{
case "8036":
controllerOperation = new ControllerOperation8036(_databaseService);
break;
}
if (controllerOperation != null)
{
controllerInfo = controllerOperation.OrganizeControllerInfoFromOldVersionSoftwareDataFile(oldVersionService);
}
//strFileInfo[1];
}
//~~~~~~~~~
project.Controllers.Add(controllerInfo);
SCA.BusinessLib.ProjectManager.GetInstance.CreateProject(project);
RaiseEvent(new RoutedEventArgs(ConfirmButtonClickEvent));
}
public int AddProject(Model.ProjectModel project)
{
StringBuilder sbProjectSQL;
if (project.ID == 0) //在目前软件中，一次仅可管理一个项目信息，后续如有扩展，可将此逻辑拆分至UpdateProject中
{
sbProjectSQL = new StringBuilder("Insert into Project(Name,savepath,saveinterval) values(\"");
sbProjectSQL.Append(project.Name + "\",\"");
sbProjectSQL.Append(project.SavePath + "\",");
sbProjectSQL.Append(project.SaveInterval + ");");
}
else
{
sbProjectSQL = new StringBuilder("Replace into Project(ID,Name,savepath,saveinterval) values(\"");
sbProjectSQL.Append(project.ID + "\",\"");
sbProjectSQL.Append(project.Name + "\",\"");
sbProjectSQL.Append(project.SavePath + "\",");
sbProjectSQL.Append(project.SaveInterval + ");");
}
return(_databaseService.ExecuteBySql(sbProjectSQL));
}
public bool UpdateProject(Model.ProjectModel project)
{
throw new NotImplementedException();
}
