public bool DeleteRecord(Model.IModel.IModelObject KeyObject)
{
bool isSuccess = false;
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
info = KeyObject as CodeMaster_cmt_Info;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
CodeMaster_cmt delTab = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == info.cmt_iRecordID);
if (delTab != null)
{
db.CodeMaster_cmts.DeleteOnSubmit(delTab);
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public bool UpdateRecord(CodeMaster_cmt_Info infoObject)
{
bool isSuccess = false;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
CodeMaster_cmt query = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == infoObject.cmt_iRecordID);
if (query != null)
{
query.cmt_cKey1 = infoObject.cmt_cKey1;
query.cmt_cKey2 = infoObject.cmt_cKey2;
query.cmt_cValue = infoObject.cmt_cValue;
query.cmt_fNumber = infoObject.cmt_fNumber;
query.cmt_cRemark = infoObject.cmt_cRemark;
query.cmt_cRemark2 = infoObject.cmt_cRemark2;
query.cmt_cLast = infoObject.cmt_cLast;
query.cmt_dLastDate = infoObject.cmt_dLastDate;
db.SubmitChanges();
isSuccess = true;
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public List <CodeMaster_cmt_Info> FindRecord(CodeMaster_cmt_Info info)
{
//throw new NotImplementedException();
List <CodeMaster_cmt_Info> list = new List <CodeMaster_cmt_Info>();
//CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
//info = searchCondition as CodeMaster_cmt_Info;
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = "SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString() + Environment.NewLine;
sqlString += "*" + Environment.NewLine;
sqlString += "FROM dbo.CodeMaster_cmt" + Environment.NewLine;
whereString = "WHERE 1=1" + Environment.NewLine;
if (info.cmt_cKey1 != "")
{
whereString += "AND cmt_cKey1='" + info.cmt_cKey1 + "' " + Environment.NewLine;
}
if (info.cmt_cKey2 != "")
{
whereString += "AND cmt_cKey2='" + info.cmt_cKey2 + "' " + Environment.NewLine;
}
if (info.cmt_cValue != "")
{
if (info.cmt_cValue.ToString().Contains("*") || info.cmt_cValue.ToString().Contains("?"))
{
whereString += "AND cmt_cValue LIKE N'" + info.cmt_cValue.ToString().Replace("*", "%").Replace("?", "_") + "' " + Environment.NewLine;
}
else
{
whereString += "AND cmt_cValue LIKE N'%" + info.cmt_cValue + "%' " + Environment.NewLine;
}
}
if (info.cmt_fNumber != 0)
{
whereString += "AND cmt_fNumber=Convert(decimal," + info.cmt_fNumber.ToString() + ")" + Environment.NewLine;
}
IEnumerable <CodeMaster_cmt_Info> infos = null;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
infos = db.ExecuteQuery <CodeMaster_cmt_Info>(sqlString + whereString, new object[] { });
if (infos != null)
{
list = infos.ToList <CodeMaster_cmt_Info>();
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(list);
}
public Model.General.ReturnValueInfo Save(Model.IModel.IModelObject itemEntity, Common.DefineConstantValue.EditStateEnum EditMode)
{
Model.General.ReturnValueInfo returnValue = new Model.General.ReturnValueInfo();
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
returnValue.messageText = "";
info = itemEntity as CodeMaster_cmt_Info;
try
{
switch (EditMode)
{
case Common.DefineConstantValue.EditStateEnum.OE_Insert:
bool isExist = false;
isExist = _codeMasterDA.IsExistRecord(info);
if (!isExist)
{
returnValue.boolValue = _codeMasterDA.InsertRecord(info);
}
else
{
returnValue.boolValue = false;
returnValue.messageText = "数据重复！";
}
break;
case Common.DefineConstantValue.EditStateEnum.OE_Update:
returnValue.boolValue = _codeMasterDA.UpdateRecord(info);
break;
case Common.DefineConstantValue.EditStateEnum.OE_Delete:
returnValue.boolValue = _codeMasterDA.DeleteRecord(info);
break;
default:
break;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnValue);
}
public CodeMaster_cmt_Info DisplayRecord(Model.IModel.IModelObject KeyObject)
{
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
CodeMaster_cmt disTab = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_iRecordID == ((KeyObject) as CodeMaster_cmt_Info).cmt_iRecordID);
if (disTab != null)
{
info = Common.General.CopyObjectValue <CodeMaster_cmt, CodeMaster_cmt_Info>(disTab);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public bool IsExistRecord(object KeyObject)
{
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
info = KeyObject as CodeMaster_cmt_Info;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
CodeMaster_cmt query = db.CodeMaster_cmts.SingleOrDefault(t => t.cmt_cKey1 == info.cmt_cKey1 && t.cmt_cKey2 == info.cmt_cKey2);
if (query != null)
{
return(true);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
return(false);
}
public bool InsertRecord(CodeMaster_cmt_Info infoObject)
{
bool isSuccess = false;
CodeMaster_cmt_Info info = new CodeMaster_cmt_Info();
info = infoObject;
try
{
using (VPMSDBDataContext db = new VPMSDBDataContext())
{
CodeMaster_cmt newTab = Common.General.CopyObjectValue <CodeMaster_cmt_Info, CodeMaster_cmt>(info);
db.CodeMaster_cmts.InsertOnSubmit(newTab);
db.SubmitChanges();
isSuccess = true;
}
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
public List <CodeMaster_cmt_Info> FindRecord(CodeMaster_cmt_Info info)
{
//throw new NotImplementedException();
//List<Model.IModel.IModelObject> list = new List<Model.IModel.IModelObject>();
List <CodeMaster_cmt_Info> returnList = new List <CodeMaster_cmt_Info>();
try
{
returnList = _codeMasterDA.FindRecord(info);
//if (returnList != null)
//{
// foreach (CodeMaster_cmt_Info t in returnList)
// {
// list.Add(t);
// }
//}
}
catch (Exception Ex)
{
throw Ex;
}
return(returnList);
}
public ProjectBaseData GetProjectBaseData()
{
Model.ProfileData profileData;
if (m_ProfileDataSQLite == null && m_ProfileData == null)
{
throw new Exception("請先從服務器或本地SQLite獲取數據！");
}
if (m_ProfileData == null)
{
profileData = m_ProfileDataSQLite;
}
else
{
profileData = m_ProfileData;
}
ProjectBaseData data = new ProjectBaseData();
CodeMaster_cmt_Info code = new CodeMaster_cmt_Info();
List<CodeMaster_cmt_Info> codes = new List<CodeMaster_cmt_Info>();
//品檢間隔時長（分鐘）
code = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_DEFAULT, DefineConstantValue.CodeMasterDefine.KEY3_QCINTERVAL);
if (code != null)
{
data.ProjectQCInervalTime = Convert.ToInt32(code.cmt_fNumber);
}
//工程停機邏輯時間
code = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_DEFAULT, DefineConstantValue.CodeMasterDefine.KEY3_PROD_STOP_COND);
if (code != null)
{
data.ProjectMachineHaltLogicTime = Convert.ToInt32(code.cmt_fNumber);
}
//目標速度（張/小時）
data.TargetSpeed = profileData.MachineSpeed;
//準備工作超時警告提前警告時間量(分鐘)
code = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_PREPARE, DefineConstantValue.CodeMasterDefine.KEY3_PREPARE_WOTTIME);
if (code != null)
{
data.OvertimeAlertTimeInAdvance = Convert.ToInt32(code.cmt_fNumber);
}
//工程等級列表
List<BaseModel> projectGrades = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_PROJECTLEVEL);
foreach (CodeMaster_cmt_Info item in codes)
{
projectGrades.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.ProjectGrades = projectGrades;
//工程轉版等級列表
List<BaseModel> projectPrepareGrades = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_PROJECTPREPARELEVEL);
foreach (CodeMaster_cmt_Info item in codes)
{
projectPrepareGrades.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark + "：" + Convert.ToInt32(item.cmt_fNumber).ToString().Trim()
});
}
data.ProjectPerpareGrades = projectPrepareGrades;
//消數原因列表
List<BaseModel> clearUpProductionQuantityReasons = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_MODIFYQTY, DefineConstantValue.CodeMasterDefine.KEY2_CLEARQTY);
foreach (CodeMaster_cmt_Info item in codes)
{
clearUpProductionQuantityReasons.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.ClearUpProductionQuantityReasons = clearUpProductionQuantityReasons;
//糾數原因列表
List<BaseModel> correctProductionQuantityReasons = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_MODIFYQTY, DefineConstantValue.CodeMasterDefine.KEY2_CORRECTQTY);
foreach (CodeMaster_cmt_Info item in codes)
{
correctProductionQuantityReasons.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.CorrectProductionQuantityReasons = correctProductionQuantityReasons;
//工程抽起原因列表
List<BaseModel> projectExtractionReasons = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_PROJECT, DefineConstantValue.CodeMasterDefine.KEY2_STOPREASON);
foreach (CodeMaster_cmt_Info item in codes)
{
projectExtractionReasons.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.ProjectExtractionReasons = projectExtractionReasons;
//溫度單位列表
List<BaseModel> temperatureUnits = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_TEMPERATUREUNIT);
foreach (CodeMaster_cmt_Info item in codes)
{
temperatureUnits.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.TemperatureUnits = temperatureUnits;
// 壓力單位列表
List<BaseModel> perssureUnits = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_PRESSUREUNIT);
foreach (CodeMaster_cmt_Info item in codes)
{
perssureUnits.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.PerssureUnits = perssureUnits;
//油墨列表
List<BaseModel> printinInks = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_INKTYPE);
foreach (CodeMaster_cmt_Info item in codes)
{
printinInks.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.PrintinInks = printinInks;
//準備工作項列表
List<ProjectBaseItemModel> prepareItems = new List<ProjectBaseItemModel>();
foreach (Model.HBPMS.Master.PrepareProjectMaster_ppm_Info item in profileData.PrepareProjectMaster)
{
prepareItems.Add(new ProjectBaseItemModel()
{
Code = item.ppm_RecordID.ToString(),
Description = item.ppm_cItemName,
IsParallelable = item.ppm_lIsParallelable,
PredictedTime = item.ppm_iPredictedTime
});
}
data.PrepareItems = prepareItems;
//工程物料列表
List<MaterialMaster> materialItems = new List<MaterialMaster>();
if (profileData.MaterialMaster != null)
{
foreach (Model.HBPMS.Management.RunningManagement.MaterialProfile_mlpf_Info item in profileData.MaterialMaster)
{
if (item != null)
{
MaterialMaster material = new MaterialMaster();
material.pmr_MLPFID = item.mlpf_MLPFID;
material.pmr_MaterialNo = item.mlpf_cMaterialCode;
material.pmr_MaterialTypeName = item.mlpf_cMaterialType;
material.pmr_MaterialName = item.mlpf_cMaterialName;
material.pmr_cMARK = item.mlpf_cDescription;
material.pmr_MaterialNameAbbreviation = item.mlpf_cMaterialAbbreviation;
material.pmr_MaterialBrandName = item.mlpf_cMaterialBrand;
material.pmr_UnitName = item.mlpf_cMaterialUnit;
material.pmr_cUnit = item.mlpf_cMaterialUnit;
material.pmr_fWidth = item.mlpf_fMaterialWidth;
material.pmr_fLength = item.mlpf_fMaterialLength;
materialItems.Add(material);
}
}
}
data.MaterialMasters = materialItems;
//工程物料類型列表
List<BaseModel> materialTypes = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_MATERIALTYPE);
foreach (CodeMaster_cmt_Info item in codes)
{
materialTypes.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.MaterialTypes = materialTypes;
//工程物料單位列表
List<BaseModel> materialUnits = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_MATERIALUNIT);
foreach (CodeMaster_cmt_Info item in codes)
{
materialUnits.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.MaterialUnits = materialUnits;
//工程物料所屬科組編號
code = GetCodeMaster(profileData, DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE, DefineConstantValue.CodeMasterDefine.KEY2_MATERIALDEPARTMENTCODE);
if (code != null)
{
data.MaterialDepartmentCode = code.cmt_cValue.Trim();
}
//停機原因項列表
List<ProjectBaseItemModel> machineHaltReasons = new List<ProjectBaseItemModel>();
foreach (StopReasonMaster_srm_Info item in profileData.StopReasonMaster)
{
machineHaltReasons.Add(new ProjectBaseItemModel()
{
Code = item.srm_iRecordID.ToString(),
Description = item.srm_cReasonName,
IsParallelable = item.srm_lIsParallelable,
PredictedTime = item.srm_iPredictedTime
});
}
data.MachineHaltReasons = machineHaltReasons;
//工程品檢品質問題列表
List<ProjectQCQualityIssues> QCQualityIssues = new List<ProjectQCQualityIssues>();
foreach (QualityProblemMaster_qpm_Info item in profileData.QualityProblemMaster)
{
QCQualityIssues.Add(new ProjectQCQualityIssues()
{
Code = item.qpm_iRecordID.ToString(),
Description = item.qpm_cProblemName,
Solution = item.qpm_cSuggestedTechnique
});
}
data.QCQualityIssues = QCQualityIssues;
//工程狀態列表
List<BaseModel> projectStatus = new List<BaseModel>();
codes = GetCodeMasters(profileData, DefineConstantValue.CodeMasterDefine.KEY1_STATUS, DefineConstantValue.CodeMasterDefine.KEY2_PROJECT);
foreach (CodeMaster_cmt_Info item in codes)
{
projectStatus.Add(new BaseModel()
{
Code = item.cmt_cValue,
Description = item.cmt_cRemark
});
}
data.ProjectStatus = projectStatus;
return data;
}
/// <summary>
/// 字碼主檔
/// </summary>
/// <returns></returns>
public List<CodeMaster_cmt_Info> GetCodeMaster()
{
try
{
List<CodeMaster_cmt_Info> list = new List<CodeMaster_cmt_Info>();
StringBuilder strSql = new StringBuilder();
strSql.AppendLine("select ");
strSql.AppendLine("cmt_iRecordID,cmt_cKey1,cmt_cKey2,cmt_cValue,cmt_fNumber,cmt_cRemark,cmt_cRemark2,cmt_cAdd,cmt_dAddDate,cmt_cLast,cmt_dLastDate,cmt_lIsActive ");
strSql.AppendLine("from CodeMaster_cmt ");
strSql.AppendLine("where cmt_lIsActive=1");
using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (sdr.Read())
{
CodeMaster_cmt_Info model = new CodeMaster_cmt_Info();
if (sdr["cmt_iRecordID"] != null && sdr["cmt_iRecordID"].ToString() != "")
{
model.cmt_iRecordID = int.Parse(sdr["cmt_iRecordID"].ToString());
}
if (sdr["cmt_cKey1"] != null && sdr["cmt_cKey1"].ToString() != "")
{
model.cmt_cKey1 = sdr["cmt_cKey1"].ToString();
}
if (sdr["cmt_cKey2"] != null && sdr["cmt_cKey2"].ToString() != "")
{
model.cmt_cKey2 = sdr["cmt_cKey2"].ToString();
}
if (sdr["cmt_cValue"] != null && sdr["cmt_cValue"].ToString() != "")
{
model.cmt_cValue = sdr["cmt_cValue"].ToString();
}
if (sdr["cmt_fNumber"] != null && sdr["cmt_fNumber"].ToString() != "")
{
model.cmt_fNumber = decimal.Parse(sdr["cmt_fNumber"].ToString());
}
if (sdr["cmt_cRemark"] != null && sdr["cmt_cRemark"].ToString() != "")
{
model.cmt_cRemark = sdr["cmt_cRemark"].ToString();
}
if (sdr["cmt_cRemark2"] != null && sdr["cmt_cRemark2"].ToString() != "")
{
model.cmt_cRemark2 = sdr["cmt_cRemark2"].ToString();
}
if (sdr["cmt_cAdd"] != null && sdr["cmt_cAdd"].ToString() != "")
{
model.cmt_cAdd = sdr["cmt_cAdd"].ToString();
}
if (sdr["cmt_dAddDate"] != null && sdr["cmt_dAddDate"].ToString() != "")
{
model.cmt_dAddDate = DateTime.Parse(sdr["cmt_dAddDate"].ToString());
}
if (sdr["cmt_cLast"] != null && sdr["cmt_cLast"].ToString() != "")
{
model.cmt_cLast = sdr["cmt_cLast"].ToString();
}
if (sdr["cmt_dLastDate"] != null && sdr["cmt_dLastDate"].ToString() != "")
{
model.cmt_dLastDate = DateTime.Parse(sdr["cmt_dLastDate"].ToString());
}
if (sdr["cmt_lIsActive"] != null && sdr["cmt_lIsActive"].ToString() != "")
{
if ((sdr["cmt_lIsActive"].ToString() == "1") || (sdr["cmt_lIsActive"].ToString().ToLower() == "true"))
{
model.cmt_lIsActive = true;
}
else
{
model.cmt_lIsActive = false;
}
}
list.Add(model);
}
}
return list;
}
catch
{
throw;
}
}
private string GetCodeMasterSQL(CodeMaster_cmt_Info model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.cmt_iRecordID != null)
{
strSql1.Append("cmt_iRecordID,");
strSql2.Append("" + model.cmt_iRecordID + ",");
}
if (model.cmt_cKey1 != null)
{
strSql1.Append("cmt_cKey1,");
strSql2.Append("'" + model.cmt_cKey1 + "',");
}
if (model.cmt_cKey2 != null)
{
strSql1.Append("cmt_cKey2,");
strSql2.Append("'" + model.cmt_cKey2 + "',");
}
if (model.cmt_cValue != null)
{
strSql1.Append("cmt_cValue,");
strSql2.Append("'" + model.cmt_cValue + "',");
}
if (model.cmt_fNumber != null)
{
strSql1.Append("cmt_fNumber,");
strSql2.Append("" + model.cmt_fNumber + ",");
}
if (model.cmt_cRemark != null)
{
strSql1.Append("cmt_cRemark,");
strSql2.Append("'" + model.cmt_cRemark + "',");
}
if (model.cmt_cRemark2 != null)
{
strSql1.Append("cmt_cRemark2,");
strSql2.Append("'" + model.cmt_cRemark2 + "',");
}
if (model.cmt_cAdd != null)
{
strSql1.Append("cmt_cAdd,");
strSql2.Append("'" + model.cmt_cAdd + "',");
}
if (model.cmt_dAddDate != null)
{
strSql1.Append("cmt_dAddDate,");
strSql2.Append("'" + model.cmt_dAddDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
if (model.cmt_cLast != null)
{
strSql1.Append("cmt_cLast,");
strSql2.Append("'" + model.cmt_cLast + "',");
}
if (model.cmt_dLastDate != null)
{
strSql1.Append("cmt_dLastDate,");
strSql2.Append("'" + model.cmt_dLastDate.Value.ToString(this._sqlLiteDatetimeFormat) + "',");
}
if (model.cmt_lIsActive != null)
{
strSql1.Append("cmt_lIsActive,");
strSql2.Append("" + (model.cmt_lIsActive ? 1 : 0) + ",");
}
strSql.Append("insert into CodeMaster_cmt(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
return strSql.ToString();
}
