public bool IsUniqueRate(Common.Rate rate)
{
var ratesUsedInRate = from c in dataBase.Rate where c.rrate_name == rate.Name select c;
if (ratesUsedInRate == null || ratesUsedInRate.Count() == 0)
return false;
return true;
}
bool IsUsedRate(Common.Rate rate)
{
var ratesUsedInTicketRows = from c in dataBase.Ticket where c.Rate.rrate_name == rate.Name select c;
if (ratesUsedInTicketRows == null || ratesUsedInTicketRows.Count() > 0)
return false;
return true;
}
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode)
{
ReturnValueInfo rvInfo = new ReturnValueInfo();
try
{
BlacklistChangeRecord_blc_Info recordInfo = itemEntity as BlacklistChangeRecord_blc_Info;
if (recordInfo == null)
{
rvInfo.isError = true;
rvInfo.messageText = Common.DefineConstantValue.SystemMessageText.strMessageText_E_ObjectNull;
return rvInfo;
}
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
return this._IBlacklistChangeRecordDA.InsertRecord(recordInfo);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
return this._IBlacklistChangeRecordDA.UpdateRecord(recordInfo);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
return this._IBlacklistChangeRecordDA.DeleteRecord(recordInfo);
break;
default:
break;
}
}
catch (Exception ex)
{
rvInfo.messageText = ex.Message;
rvInfo.isError = true;
}
return rvInfo;
}
public Project(
int projectId,
string name,
ProjectType[] projectType,
string info,
ProjectStatus projectStatus,
Common.Image landingImage,
Uri versionControlSystemUri,
Uri projectManagementSystemUri,
HashSet<Issue> issues,
HashSet<ProjectMembership> projectMemberships,
HashSet<Common.Image> screenshots)
{
Require.Positive(projectId, nameof(projectId));
Require.NotEmpty(name, nameof(name));
Require.NotNull(info, nameof(info));
Require.NotNull(versionControlSystemUri, nameof(versionControlSystemUri));
Require.NotNull(projectManagementSystemUri, nameof(projectManagementSystemUri));
ProjectId = projectId;
Name = name;
ProjectType = projectType;
Info = info;
ProjectStatus = projectStatus;
LandingImage = landingImage;
VersionControlSystemUri = versionControlSystemUri;
ProjectManagementSystemUri = projectManagementSystemUri;
Issues = issues;
ProjectMemberships = projectMemberships;
Screenshots = screenshots;
}
internal static void Log(string message, Common.CommandLine.Log.SeverityLevel level)
{
if (Message != null)
{
Message(message, level);
}
}
public List<Order> GetSearchedOrders(Common.Order searchedOrder, DateTime edDate)
{
string stringSearchedOrders = searchedOrder.Date.ToString();
var listOfSearchedOrders = from c in dataBase.Main where
(
((searchedOrder.PersonName == "") || (c.Person.name == searchedOrder.PersonName)) &&
((searchedOrder.TicketName == "") || (c.Ticket.ticket_name == searchedOrder.TicketName)) &&
((stringSearchedOrders == "01.01.0001 0:00:00") || (c.month == searchedOrder.Date))
) select c;
if (listOfSearchedOrders == null)
return null;
List<Common.Order> orders = new List<Common.Order>();
foreach (Main tmpSearchedOrder in listOfSearchedOrders)
{
if (edDate.ToString() != "01.01.0001 0:00:00")
{
if (edDate < tmpSearchedOrder.Person.date_end_ed &&
edDate > tmpSearchedOrder.Person.date_begin_ed)
orders.Add(new Common.Order(tmpSearchedOrder.m_id, tmpSearchedOrder.Person.name,
tmpSearchedOrder.Ticket.ticket_name, tmpSearchedOrder.month, tmpSearchedOrder.amount,
(int)tmpSearchedOrder.pledge));
}
else
orders.Add(new Common.Order(tmpSearchedOrder.m_id, tmpSearchedOrder.Person.name, tmpSearchedOrder.Ticket.ticket_name,
tmpSearchedOrder.month, tmpSearchedOrder.amount, (int)tmpSearchedOrder.pledge));
}
return orders;
}
private void btn_export_Click(object sender, EventArgs e)
{
string path = "";
bool overWrite = true;
if (dataGridView1.Rows.Count == 0)
{
return;
}
comn = new Common.Common();
saveFileDialog1.Filter = "Excel File|*.xls";
saveFileDialog1.Title = "数据导出";
//this.saveFileDialog1.FileName = txtKhmc.Text.Trim() + "印刷清单";
if (saveFileDialog1.ShowDialog() != DialogResult.Cancel)
{
path = saveFileDialog1.FileName;
DataGridViewExport.ExportToExcel(dataGridView1, path, "s", overWrite);
}
DialogResult result = MessageBox.Show("是否打开Excel文件？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.No)
{
return;
}
if (DataGridViewExport.IsExistsExcel())
{
DataGridViewExport.OpenExcel(path);
}
}
//Фильтруем красиво
public List<Common.Ticket> GetSearchedTickets(Common.Ticket searchedTicket)
{
var searchedTickets = from c in dataBase.Ticket where
(
((searchedTicket.Price == 0) || (c.Price.price_name == searchedTicket.Price)) &&
((searchedTicket.Type == String.Empty) || (c.Type.ttype_name == searchedTicket.Type)) &&
((searchedTicket.Rate == String.Empty) || (c.Rate.rrate_name == searchedTicket.Rate))
)
select c;
if (searchedTickets == null)
return null;
List<Common.Ticket> tickets = new List<Common.Ticket>();
foreach (Ticket tmpSearchedTicket in searchedTickets)
{
tickets.Add(
new Common.Ticket(tmpSearchedTicket.tticket_id, tmpSearchedTicket.ticket_name, tmpSearchedTicket.Price.price_name,
tmpSearchedTicket.Rate.rrate_name, tmpSearchedTicket.Type.ttype_name)
);
}
return tickets;
}
public AdminProject(
int projectId,
string name,
ProjectType[] projectType,
string info,
ProjectStatus projectStatus,
Common.Image landingImage,
AccessLevel accessLevel,
Uri versionControlSystemUri,
Uri projectManagementSystemUri,
HashSet<Issue> issues,
HashSet<ProjectMembership> projectDevelopers,
HashSet<Common.Image> screenshots)
{
Require.Positive(projectId, nameof(projectId));
Require.NotEmpty(name, nameof(name));
Require.NotNull(info, nameof(info));
Require.NotNull(versionControlSystemUri, nameof(versionControlSystemUri));
Require.NotNull(projectManagementSystemUri, nameof(projectManagementSystemUri));
ProjectId = projectId;
Name = name;
ProjectType = projectType ?? new[] {Common.ProjectType.Other};
AccessLevel = accessLevel;
Info = info;
ProjectStatus = projectStatus;
LandingImage = landingImage;
VersionControlSystemUri = versionControlSystemUri;
ProjectManagementSystemUri = projectManagementSystemUri;
Issues = issues ?? new HashSet<Issue>();
ProjectMemberships = projectDevelopers ?? new HashSet<ProjectMembership>();
Screenshots = screenshots ?? new HashSet<Common.Image>();
}
public DisplacedMeshRenderer(Common.Mesh mesh)
{
this.mesh = mesh;
this.DisplacementScale = 1.0f;
this.DisplaceMidLevel = 0.5f;
this.EnableNormalMap = true;
}
bool IsUsedPrice(Common.Price price)
{
var priceUsedIntickets = from c in dataBase.Ticket where c.Price.price_name == price.Value select c;
if (priceUsedIntickets.Count() > 0)
return false;
return true;
}
bool IsUniquePrice(Common.Price price)
{
var priceUsedInPrice = from c in dataBase.Price where c.price_name == price.Value select c;
if (priceUsedInPrice.Count() > 0)
return false;
return true;
}
bool IsUsedPerson(Common.Person person)
{
var personUsedInMain = from c in dataBase.Main where c.Person.ppers_id == person.ID select c;
if (personUsedInMain == null || personUsedInMain.Count() > 0)
return false;
return true;
}
public override AState AnalyzeMessage(Common.Protocol.Message message)
{
if (message.Header.ServiceType == Common.ServiceTypes.NACK)
{
ErrorHandler.HandleError("Incorect Username or Password!", "Authentication Error", (IWin32Window)_mainView);
_signInAlreadySent = false;
ClearCurrentEventHandlers();
try
{
if(_peerConnectionManagerThread != null)
this._peerConnectionManagerThread.Abort();
}
catch (ThreadAbortException ex)
{
}
return GetNextState(message.Header.ServiceType);
}
if (_signInAlreadySent && message.Header.ServiceType == Common.ServiceTypes.ACK)
{
_mainView.AfterSignIn(_userName);
ClearCurrentEventHandlers();
return GetNextState(message.Header.ServiceType);
}
return this;
}
public void ShowForm(GradeMaster_gdm_Info editInfo, Common.DefineConstantValue.EditStateEnum editStatc)
{
this._editInfo = editInfo;
this.EditState = editStatc;
this.ShowDialog();
}
public void ShowForm(DepartmentMaster_dpm_Info editInfo, Common.DefineConstantValue.EditStateEnum editStatc)
{
this._CurrentDptInfo = editInfo;
this.EditState = editStatc;
this.ShowDialog();
}
public void ShowForm(CardUserMaster_cus_Info editInfo, Common.DefineConstantValue.EditStateEnum editStatc)
{
this._editInfo = editInfo;
this.EditState = editStatc;
this.ShowDialog();
}
public List<Model.General.ComboboxDataInfo> GetMasterDataInformations(Common.DefineConstantValue.MasterType masterType)
{
List<Model.General.ComboboxDataInfo> listCboInfos = null;
try
{
switch (masterType)
{
case DefineConstantValue.MasterType.WinFormSkin:
listCboInfos = GetWinFormSkin();
break;
case DefineConstantValue.MasterType.CodeMaster_Key1:
listCboInfos = GetCodeMaster_Key1();
break;
//case DefineConstantValue.MasterType.PinterMachineType:
// listCboInfos = GetPinterMachineType();
// break;
case DefineConstantValue.MasterType.ShiftInfo_NoStopReason:
listCboInfos = GetShiftTypeMaster_NoStopReason();
break;
case DefineConstantValue.MasterType.ShiftMaster:
listCboInfos = GetShiftMaster();
break;
case DefineConstantValue.MasterType.AreaMaster:
listCboInfos = GetAreaMaster();
break;
case DefineConstantValue.MasterType.ShiftTypeMaster:
listCboInfos = GetShiftTypeMaster();
break;
case DefineConstantValue.MasterType.MachineType:
listCboInfos = GetMachineType();
break;
case DefineConstantValue.MasterType.PrepareJobType:
listCboInfos = GetPrepareJobType();
break;
case DefineConstantValue.MasterType.StopReasonType:
listCboInfos = GetStopReasonType();
break;
case DefineConstantValue.MasterType.MaintenanceType:
listCboInfos = GetMaintenanceType();
break;
case DefineConstantValue.MasterType.QualityProblemType:
listCboInfos = GetQualityProblemType();
break;
default:
break;
}
}
catch (Exception ex)
{
throw ex;
}
return listCboInfos;
}
public void PublishToSubscriber(Common.Model.Message pMessage)
{
if (pMessage is PriceChangeMessage)
{
PriceChangeMessage lMessage = pMessage as PriceChangeMessage;
PriceChangeMessageToTradeItem lVisitor = new PriceChangeMessageToTradeItem();
pMessage.Accept(lVisitor);
MainWindow.sViewModel.AcceptTradeItemUpdate(lVisitor.Result);
}
}
public Observer(string path)
{
watcher = new FileSystemWatcher();
watcher.Path = path;
watcher.Deleted += DeletedFile;
watcher.Changed += SavedFile;
watcher.EnableRaisingEvents = true;
var common = new Common.Common();
D = new Data.CapaData();
}
public bool DeleteTicket(Common.Ticket ticket)
{
bool canDeleteTicket = IsUsedTicket(ticket);
if (canDeleteTicket)
{
var ticketToDelete = (from c in dataBase.Ticket where c.ticket_name == ticket.Name select c).FirstOrDefault();
dataBase.Ticket.Remove(ticketToDelete);
dataBase.SaveChanges();
return true;
}
return false;
}
/// <summary>
/// 插入需要上传消费机的卡号
/// </summary>
/// <param name="iCardNo">卡号</param>
/// <param name="enmOpt">上传操作</param>
/// <param name="enmReason">上传原因</param>
public ReturnValueInfo InsertUploadCardNo(int iCardNo, Common.DefineConstantValue.EnumCardUploadListOpt enmOpt, Common.DefineConstantValue.EnumCardUploadListReason enmReason, string strUserID)
{
BlacklistChangeRecord_blc_Info blistInsert = new BlacklistChangeRecord_blc_Info();
blistInsert.blc_cRecordID = Guid.NewGuid();
blistInsert.blc_cOperation = enmOpt.ToString();
blistInsert.blc_cOptReason = enmReason.ToString();
blistInsert.blc_iCardNo = iCardNo;
blistInsert.blc_cAdd = strUserID;
blistInsert.blc_dAddDate = DateTime.Now;
ReturnValueInfo rvInfo = Save(blistInsert, DefineConstantValue.EditStateEnum.OE_Insert);
return rvInfo;
}
public bool AddRate(Common.Rate rate)
{
bool canAdd = IsUniqueRate(rate);
if (canAdd)
{
Rate rateDB = new Rate();
rateDB.rrate_name = rate.Name;
dataBase.Rate.Add(rateDB);
return true;
}
return false;
}
public bool DeleteRate(Common.Rate rate)
{
bool canDeleteRate = IsUsedRate(rate);
if (canDeleteRate)
{
var ratesToDelete = (from c in dataBase.Rate where c.rrate_name == rate.Name select c).FirstOrDefault();
dataBase.Rate.Remove(ratesToDelete);
dataBase.SaveChanges();
return true;
}
return false;
}
public bool DeletePrice(Common.Price price)
{
bool canDeletePrice = IsUsedPrice(price);
if (canDeletePrice)
{
var priceToDelete = (from c in dataBase.Price where c.price_name == price.Value select c).FirstOrDefault();
dataBase.Price.Remove(priceToDelete);
dataBase.SaveChanges();
return true;
}
return false;
}
public int IsUniquePerson(Common.Person person)
{
var personInPerson = from c in dataBase.Person where c.name == person.Name && c.date_begin_ed == person.date_begin_ed &&
c.date_end_ed == person.date_end_ed select c;
var personNamesInPerson = from c in dataBase.Person where c.name == person.Name select c;
if (personInPerson.Count() > 0)
return 1;
else if (personNamesInPerson.Count() > 0)
return 2;
return 0;
}
public bool DeletePerson(Common.Person person)
{
bool canDeletePerson = IsUsedPerson(person);
if (canDeletePerson)
{
var PersonToDelete = (from c in dataBase.Person where c.ppers_id == person.ID select c).FirstOrDefault();
dataBase.Person.Remove(PersonToDelete);
dataBase.SaveChanges();
return true;
}
return false;
}
public bool AddPrice(Common.Price price)
{
bool canAddPrice = IsUniquePrice(price);
if (canAddPrice)
{
Price priceToAdd = new Price();
priceToAdd.price_name = price.Value;
dataBase.Price.Add(priceToAdd);
dataBase.SaveChanges();
return true;
}
return false;
}
/// <summary>
/// 指定した配置にするためにマージンを設定する
/// </summary>
/// <param name="element"></param>
/// <param name="point"></param>
public static void SetGroudPictureMargin(this FrameworkElement element, Common.MPoint point)
{
Thickness margin = UIUtility.GetMargin(point, element);
// マージンを設定
try
{
element.Margin = margin;
}
catch (Exception ex)
{
throw new Exception(string.Format("enement.Name={0}", element.Name), ex);
}
}
ReturnValueInfo AddOldCardList(int iCardNo, Common.DefineConstantValue.EnumCardUploadListOpt blistOpt)
{
localLog.WriteLog("清除名单成功。", string.Empty, SystemLog.SystemLog.LogType.Trace);
IBlacklistChangeRecordBL blistBL = MasterBLLFactory.GetBLL<IBlacklistChangeRecordBL>(MasterBLLFactory.BlacklistChangeRecord);
BlacklistChangeRecord_blc_Info blistInsert = new BlacklistChangeRecord_blc_Info();
blistInsert.blc_cAdd = "TQS";
blistInsert.blc_cOperation = blistOpt.ToString();
blistInsert.blc_cOptReason = Common.DefineConstantValue.EnumCardUploadListReason.WhitelistOpt.ToString();
blistInsert.blc_cRecordID = Guid.NewGuid();
blistInsert.blc_dAddDate = DateTime.Now;
blistInsert.blc_iCardNo = iCardNo;
ReturnValueInfo rvInfo = blistBL.Save(blistInsert, DefineConstantValue.EditStateEnum.OE_Insert);
return rvInfo;
}
public int AddPerson(Common.Person person)
{
int canAddPerson = IsUniquePerson(person);
if (canAddPerson == 0)
{
Person dbPerson = new Person();
dbPerson.name = person.Name;
dataBase.Person.Add(dbPerson);
return 0;
}
else if (canAddPerson == 1)
return 1;
else
return 2;
}
public MaintenancePlanAppSetting(MaintainPlanView plan, Common.DefineConstantValue.EditStateEnum editState)
{
InitializeComponent();
init();
if (editState == Common.DefineConstantValue.EditStateEnum.OE_Update)
{
showModify();
}
else if (editState == Common.DefineConstantValue.EditStateEnum.OE_ReaOnly)
{
showView();
}
this._planView = plan;
SetValue();
}
