public List<MaintainOperationMaster_mom_Info> FindRecord_ppc(MaintainOperationMaster_mom_Info info) { try { List<MaintainOperationMaster_mom_Info> listRes = new List<MaintainOperationMaster_mom_Info>(); StringBuilder htrSql = new StringBuilder(); htrSql.Append("from MaintainOperationMaster_mom_Info where 1=1 "); Dictionary<string, object> dicCondition = new Dictionary<string, object>(); if (info != null) { htrSql.AppendLine(" and mom_lIsAtive = :mom_lIsAtive "); dicCondition.Add("mom_lIsAtive", info.mom_lIsAtive); } listRes = (List<MaintainOperationMaster_mom_Info>)FindEntities<MaintainOperationMaster_mom_Info>(htrSql.ToString(), dicCondition); return listRes; } catch { throw; } }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; MaintainOperationMaster_mom_Info info = new MaintainOperationMaster_mom_Info(); info = KeyObject as MaintainOperationMaster_mom_Info; #region 舊代碼 //using (MainDBDataContext db = new MainDBDataContext()) //{ // MaintainOperationMaster_mom delTab = db.MaintainOperationMaster_mom.SingleOrDefault(t => t.mom_iRecordID == info.mom_iRecordID); // if (delTab != null) // { // db.MaintainOperationMaster_mom.DeleteOnSubmit(delTab); // db.SubmitChanges(); // isSuccess = true; // } //} #endregion //Add By Ximonliang 2015-03-09------------------------>> string strSql = string.Empty; if (info != null) { strSql += "delete from MaintainOperationMaster_mom" + Environment.NewLine; strSql += "where mom_iRecordID=" + info.mom_iRecordID + Environment.NewLine; using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { SqlTransaction transaction = null; conn.Open(); //開啟連接 transaction = conn.BeginTransaction(); //開啟事務 try { isSuccess = ExecuteSQL(strSql, transaction); } catch (Exception Ex) { transaction.Rollback(); throw Ex; } finally { if (isSuccess) { transaction.Commit(); } } } } //Add By Ximonliang 2015-03-09------------------------<< return isSuccess; }
/// <summary> /// 初始化當前項目 /// </summary> private void InitModelInfo() { if (BaseParam != null) { _currentItem = BaseParam as MaintainOperationMaster_mom_Info; } else { _currentItem = new MaintainOperationMaster_mom_Info(); } DisplayInfo(_currentItem); }
/// <summary> /// 顯示資訊 /// </summary> /// <param name="prepareModel"></param> private void DisplayInfo(MaintainOperationMaster_mom_Info operationModel) { MaintenanceInfoProprety mip = new MaintenanceInfoProprety(); mip.mom_cOperationCode = operationModel.mom_cOperationCode; mip.mom_cMachineModel = operationModel.mom_cMachineModel; mip.mom_cOperationName = operationModel.mom_cOperationName; mip.mom_cOperationTypeName = operationModel.mom_cOperationType; mip.mom_iCompleteTime = operationModel.mom_iCompleteTime; mip.IsActiveChiness = (MaintenanceInfoProprety.YesNo)Enum.Parse(typeof(MaintenanceInfoProprety.YesNo), operationModel.IsAtiveChiness); mip.mom_cStandardFilePath = operationModel.mom_cStandardFilePath; //(NO:0005078) Add By Leothlink TonyWu On 07/18/2014 >>> if (operationModel.mom_iRecordID != 0) { _PlanEquipmentList = _maintainOperationMasterBL.GetPlanMaintainEquipments(operationModel.mom_iRecordID); ShowPlanEquipment(); } //(NO:0005078) Add By Leothlink TonyWu On 07/18/2014 <<< this.ppgMaintenanceInfo.SelectedObject = mip; }
/// <summary> /// 保存保存部件清单 /// </summary> /// <param name="p_objMOMInfo"></param> /// <param name="p_objMaintainInfo"></param> /// <param name="p_lisEquipments"></param> /// <returns></returns> /// <remarks>(NO:0005078) Add By Leothlink TonyWu On 07/18/2014</remarks> public static bool SaveMaintainEquipments(MaintainOperationMaster_mom_Info p_objMOMInfo, MaintainRecord_mtr_Info p_objMaintainInfo, List<MaintainEquipmentMapping_mem_Info> p_lisEquipments) { List<MaintainOperation> l_lisInsert = new List<MaintainOperation>(); try { if (p_lisEquipments.Count > 0) { foreach (var l_objEquipment in p_lisEquipments) { MaintainOperation l_objItem = new MaintainOperation() { AddBy = l_objEquipment.mem_cAddBy, AddTime = DateTime.Now, Duration = p_objMOMInfo.mom_iCompleteTime.ToString(), EndTime = p_objMaintainInfo.mtr_dEndTime, EquipNumber = l_objEquipment.mem_cEquipmentNum, IsActive = true, OperationCode = p_objMOMInfo.mom_cOperationCode, OperationName = p_objMOMInfo.mom_cOperationName, OperationType = p_objMOMInfo.mom_cOperationType, ParentEquipNumber = l_objEquipment.mem_cPreEquipmentNum, RecordId = l_objEquipment.mem_cRecordID, StandardFile = p_objMOMInfo.mom_cStandardFilePath, StartTime = p_objMaintainInfo.mtr_dBeginTime, MtrId = p_objMaintainInfo.mtr_RecordID, MtrPlanId = p_objMaintainInfo.mtr_iPlanID == null ? 0 : p_objMaintainInfo.mtr_iPlanID.Value }; l_lisInsert.Add(l_objItem); } } else { MaintainOperation l_objItem = new MaintainOperation() { AddBy = "SYSTEM", AddTime = DateTime.Now, Duration = p_objMOMInfo.mom_iCompleteTime.ToString(), EndTime = p_objMaintainInfo.mtr_dEndTime, EquipNumber = "", IsActive = true, OperationCode = p_objMOMInfo.mom_cOperationCode, OperationName = p_objMOMInfo.mom_cOperationName, OperationType = p_objMOMInfo.mom_cOperationType, ParentEquipNumber = "", RecordId = Guid.Empty, StandardFile = p_objMOMInfo.mom_cStandardFilePath, StartTime = p_objMaintainInfo.mtr_dBeginTime, MtrId = p_objMaintainInfo.mtr_RecordID, MtrPlanId = p_objMaintainInfo.mtr_iPlanID == null ? 0 : p_objMaintainInfo.mtr_iPlanID.Value }; l_lisInsert.Add(l_objItem); } _MaximoServiceWS.SaveMaintainList(p_objMaintainInfo.mtr_RecordID, l_lisInsert.ToArray()); return true; } catch { return false; } }
/// <summary> /// 保養動作主檔 /// </summary> public List<MaintainOperationMaster_mom_Info> GetMaintainOperationMaster(string machineType) { try { List<MaintainOperationMaster_mom_Info> list = new List<MaintainOperationMaster_mom_Info>(); StringBuilder strSql = new StringBuilder(); strSql.AppendLine("select"); strSql.AppendLine("mom_iRecordID,mom_cOperationCode,mom_cOperationName,mom_cOperationType,mom_cMachineModel,mom_lIsAtive,mom_iCompleteTime,mom_cStandardFilePath,mom_cAdd,mom_dAddDate,mom_cLast,mom_dLastDate "); strSql.AppendLine("from MaintainOperationMaster_mom "); strSql.AppendLine("where mom_cMachineModel='"+machineType.Trim()+"'"); strSql.AppendLine("and mom_lIsAtive=1 "); using (SqlDataReader sdr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (sdr.Read()) { MaintainOperationMaster_mom_Info model = new MaintainOperationMaster_mom_Info(); if (sdr["mom_iRecordID"] != null && sdr["mom_iRecordID"].ToString() != "") { model.mom_iRecordID = int.Parse(sdr["mom_iRecordID"].ToString()); } if (sdr["mom_cOperationCode"] != null && sdr["mom_cOperationCode"].ToString() != "") { model.mom_cOperationCode = sdr["mom_cOperationCode"].ToString(); } if (sdr["mom_cOperationName"] != null && sdr["mom_cOperationName"].ToString() != "") { model.mom_cOperationName = sdr["mom_cOperationName"].ToString(); } if (sdr["mom_cOperationType"] != null && sdr["mom_cOperationType"].ToString() != "") { model.mom_cOperationType = sdr["mom_cOperationType"].ToString(); } if (sdr["mom_cMachineModel"] != null && sdr["mom_cMachineModel"].ToString() != "") { model.mom_cMachineModel = sdr["mom_cMachineModel"].ToString(); } if (sdr["mom_lIsAtive"] != null && sdr["mom_lIsAtive"].ToString() != "") { if ((sdr["mom_lIsAtive"].ToString() == "1") || (sdr["mom_lIsAtive"].ToString().ToLower() == "true")) { model.mom_lIsAtive = true; } else { model.mom_lIsAtive = false; } } if (sdr["mom_iCompleteTime"] != null && sdr["mom_iCompleteTime"].ToString() != "") { model.mom_iCompleteTime = int.Parse(sdr["mom_iCompleteTime"].ToString()); } if (sdr["mom_cStandardFilePath"] != null && sdr["mom_cStandardFilePath"].ToString() != "") { model.mom_cStandardFilePath = sdr["mom_cStandardFilePath"].ToString(); } if (sdr["mom_cAdd"] != null && sdr["mom_cAdd"].ToString() != "") { model.mom_cAdd = sdr["mom_cAdd"].ToString(); } if (sdr["mom_dAddDate"] != null && sdr["mom_dAddDate"].ToString() != "") { model.mom_dAddDate = DateTime.Parse(sdr["mom_dAddDate"].ToString()); } if (sdr["mom_cLast"] != null && sdr["mom_cLast"].ToString() != "") { model.mom_cLast = sdr["mom_cLast"].ToString(); } if (sdr["mom_dLastDate"] != null && sdr["mom_dLastDate"].ToString() != "") { model.mom_dLastDate = DateTime.Parse(sdr["mom_dLastDate"].ToString()); } list.Add(model); } } return list; } catch (Exception ex) { throw ex; } }
public List<MaintainOperationMaster_mom_Info> SearchRecords(Model.IModel.IModelObject searchCondition) { List<MaintainOperationMaster_mom_Info> list = new List<MaintainOperationMaster_mom_Info>(); MaintainOperationMaster_mom_Info info = new MaintainOperationMaster_mom_Info(); info = searchCondition as MaintainOperationMaster_mom_Info; StringBuilder sqlString = new StringBuilder(); sqlString.AppendLine("SELECT TOP " + Common.DefineConstantValue.ListRecordMaxCount.ToString()); sqlString.AppendLine("cmt_cRemark as mom_cOperationTypeName,*"); sqlString.AppendLine("FROM MaintainOperationMaster_mom LEFT JOIN CodeMaster_cmt"); sqlString.AppendLine("on cmt_cKey1='" + Common.DefineConstantValue.CodeMasterDefine.KEY1_TYPEVALUE + "' and cmt_cKey2='" + Common.DefineConstantValue.CodeMasterDefine.KEY2_MAINTENANCETYPE + "' and cmt_cValue=mom_cOperationType"); sqlString.AppendLine("WHERE 1=1"); if (info.mom_cOperationCode != "") { sqlString.AppendLine("AND mom_cOperationCode='" + info.mom_cOperationCode + "'"); } if (info.mom_cMachineModel != "") { sqlString.AppendLine("AND mom_cMachineModel='" + info.mom_cMachineModel + "'"); } if (info.mom_cOperationType != "") { sqlString.AppendLine("AND mom_cOperationType='" + info.mom_cOperationType + "'"); } if (info.mom_cOperationName != "") { sqlString.AppendLine("AND mom_cOperationName='" + info.mom_cOperationName + "'"); } IEnumerable<MaintainOperationMaster_mom_Info> infos = null; using (MainDBDataContext db = new MainDBDataContext()) { infos = db.ExecuteQuery<MaintainOperationMaster_mom_Info>(sqlString.ToString(), new object[] { }); if (infos != null) { list = infos.ToList<MaintainOperationMaster_mom_Info>(); } } return list; }
public bool InsertRecord(MaintainOperationMaster_mom_Info infoObject) { bool isSuccess = false; #region 舊代碼 //MaintainOperationMaster_mom_Info info = new MaintainOperationMaster_mom_Info(); //info = infoObject; //using (MainDBDataContext db = new MainDBDataContext()) //{ // MaintainOperationMaster_mom newTab = Common.General.CopyObjectValue<MaintainOperationMaster_mom_Info, MaintainOperationMaster_mom>(infoObject); // db.MaintainOperationMaster_mom.InsertOnSubmit(newTab); // db.SubmitChanges(); // isSuccess = true; //} #endregion //Add By Ximonliang 2015-03-09------------------------>> string strSql = string.Empty; if (infoObject != null) { try { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { SqlTransaction transaction = null; conn.Open(); //開啟連接 transaction = conn.BeginTransaction(); //開啟事務 strSql += "Insert into MaintainOperationMaster_mom" + Environment.NewLine; strSql += "( mom_cOperationCode, mom_cOperationName, mom_cOperationType, mom_cMachineModel, mom_lIsAtive, mom_iCompleteTime, mom_cStandardFilePath, mom_cAdd, mom_dAddDate, mom_cLast, mom_dLastDate)" + Environment.NewLine; strSql += "values" + Environment.NewLine; strSql += "('" + infoObject.mom_cOperationCode + "','" + infoObject.mom_cOperationName + "','" + infoObject.mom_cOperationType + "','" + infoObject.mom_cMachineModel + "',1," + infoObject.mom_iCompleteTime + ",'" + infoObject.mom_cStandardFilePath + "','" + infoObject.mom_cAdd + "',getdate(),'" + infoObject.mom_cLast + "',getdate())" + Environment.NewLine; try { isSuccess = ExecuteSQL(strSql, transaction); } catch (Exception Ex) { transaction.Rollback(); throw Ex; } finally { if (isSuccess) transaction.Commit(); } } } catch (Exception Ex) { throw Ex; } } //Add By Ximonliang 2015-03-09------------------------<< return isSuccess; }
public MaintainOperationMaster_mom_Info GetRecord_Previous(Model.Base.DataBaseCommandInfo commandInfo) { MaintainOperationMaster_mom_Info info = new MaintainOperationMaster_mom_Info(); ; #region 舊代碼 //using (MainDBDataContext db = new MainDBDataContext()) //{ // MaintainOperationMaster_mom query = db.MaintainOperationMaster_mom // .Where(t => t.mom_iRecordID < Convert.ToInt32(commandInfo.KeyInfoList[0].KeyValue)) // .OrderByDescending(t => t.mom_iRecordID) // .FirstOrDefault(); // info = Common.General.CopyObjectValue<MaintainOperationMaster_mom, MaintainOperationMaster_mom_Info>(query); //} #endregion //Add By Ximonliang 2015-03-09------------------------>> string strSql = string.Empty; strSql += "select top 1 * " + Environment.NewLine; strSql += "from MaintainOperationMaster_mom NOLOCK" + Environment.NewLine; strSql += "where mom_iRecordID < " + Convert.ToInt32(commandInfo.KeyInfoList[0].KeyValue) + Environment.NewLine; strSql += "order by mom_iRecordID desc" + Environment.NewLine; try { using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql)) { while (reader.Read()) { #region 實體賦值 if (reader["mom_iRecordID"] != null && reader["mom_iRecordID"].ToString() != string.Empty) { info.mom_iRecordID = Convert.ToInt32(reader["mom_iRecordID"].ToString()); } if (reader["mom_cOperationCode"] != null && reader["mom_cOperationCode"].ToString() != string.Empty) { info.mom_cOperationCode = reader["mom_cOperationCode"].ToString().Trim(); } if (reader["mom_cOperationName"] != null && reader["mom_cOperationName"].ToString() != string.Empty) { info.mom_cOperationName = reader["mom_cOperationName"].ToString().Trim(); } if (reader["mom_cOperationType"] != null && reader["mom_cOperationType"].ToString() != string.Empty) { info.mom_cOperationType = reader["mom_cOperationType"].ToString().Trim(); } if (reader["mom_cMachineModel"] != null && reader["mom_cMachineModel"].ToString() != string.Empty) { info.mom_cMachineModel = reader["mom_cMachineModel"].ToString().Trim(); } if (reader["mom_lIsAtive"] != null && reader["mom_lIsAtive"].ToString() != string.Empty) { info.mom_lIsAtive = Convert.ToBoolean(reader["mom_lIsAtive"].ToString().Trim()); } if (reader["mom_iCompleteTime"] != null && reader["mom_iCompleteTime"].ToString() != string.Empty) { info.mom_iCompleteTime = Convert.ToInt32(reader["mom_iCompleteTime"].ToString().Trim()); } if (reader["mom_cStandardFilePath"] != null && reader["mom_cStandardFilePath"].ToString() != string.Empty) { info.mom_cStandardFilePath = reader["mom_cStandardFilePath"].ToString().Trim(); } if (reader["mom_cAdd"] != null && reader["mom_cAdd"].ToString() != string.Empty) { info.mom_cAdd = reader["mom_cAdd"].ToString().Trim(); } if (reader["mom_dAddDate"] != null && reader["mom_dAddDate"].ToString() != string.Empty) { info.mom_dAddDate = Convert.ToDateTime(reader["mom_dAddDate"].ToString()); } if (reader["mom_cLast"] != null && reader["mom_cLast"].ToString() != string.Empty) { info.mom_cLast = reader["mom_cLast"].ToString().Trim(); } if (reader["mom_dLastDate"] != null && reader["mom_dLastDate"].ToString() != string.Empty) { info.mom_dLastDate = Convert.ToDateTime(reader["mom_dLastDate"].ToString()); } #endregion break; } } } catch (Exception Ex) { throw Ex; } //Add By Ximonliang 2015-03-09------------------------<< return info; }
public List<MaintainOperationMaster_mom_Info> FindRecord(MaintainOperationMaster_mom_Info info) { return SearchRecords(info); }
public MaintainOperationMaster_mom_Info DisplayRecord(Model.IModel.IModelObject KeyObject) { MaintainOperationMaster_mom_Info info = new MaintainOperationMaster_mom_Info(); #region 舊代碼 //using (MainDBDataContext db = new MainDBDataContext()) //{ // MaintainOperationMaster_mom disTab = db.MaintainOperationMaster_mom.SingleOrDefault(t => t.mom_iRecordID == ((KeyObject) as MaintainOperationMaster_mom_Info).mom_iRecordID); // if (disTab != null) // { // info = Common.General.CopyObjectValue<MaintainOperationMaster_mom, MaintainOperationMaster_mom_Info>(disTab); // } //} #endregion //Add By Ximonliang 2015-03-09------------------------>> string strSql = string.Empty; if (KeyObject != null) { strSql += "select * from MaintainOperationMaster_mom NOLOCK" + Environment.NewLine; strSql += "where mom_iRecordID=" + ((KeyObject) as MaintainOperationMaster_mom_Info).mom_iRecordID + Environment.NewLine; try { using (SqlDataReader reader = DbHelperSQL.ExecuteReader(strSql)) { while (reader.Read()) { #region 實體賦值 if (reader["mom_iRecordID"] != null && reader["mom_iRecordID"].ToString() != string.Empty) { info.mom_iRecordID = Convert.ToInt32(reader["mom_iRecordID"].ToString()); } if (reader["mom_cOperationCode"] != null && reader["mom_cOperationCode"].ToString() != string.Empty) { info.mom_cOperationCode = reader["mom_cOperationCode"].ToString().Trim(); } if (reader["mom_cOperationName"] != null && reader["mom_cOperationName"].ToString() != string.Empty) { info.mom_cOperationName = reader["mom_cOperationName"].ToString().Trim(); } if (reader["mom_cOperationType"] != null && reader["mom_cOperationType"].ToString() != string.Empty) { info.mom_cOperationType = reader["mom_cOperationType"].ToString().Trim(); } if (reader["mom_cMachineModel"] != null && reader["mom_cMachineModel"].ToString() != string.Empty) { info.mom_cMachineModel = reader["mom_cMachineModel"].ToString().Trim(); } if (reader["mom_lIsAtive"] != null && reader["mom_lIsAtive"].ToString() != string.Empty) { info.mom_lIsAtive = Convert.ToBoolean(reader["mom_lIsAtive"].ToString().Trim()); } if (reader["mom_iCompleteTime"] != null && reader["mom_iCompleteTime"].ToString() != string.Empty) { info.mom_iCompleteTime = Convert.ToInt32(reader["mom_iCompleteTime"].ToString().Trim()); } if (reader["mom_cStandardFilePath"] != null && reader["mom_cStandardFilePath"].ToString() != string.Empty) { info.mom_cStandardFilePath = reader["mom_cStandardFilePath"].ToString().Trim(); } if (reader["mom_cAdd"] != null && reader["mom_cAdd"].ToString() != string.Empty) { info.mom_cAdd = reader["mom_cAdd"].ToString().Trim(); } if (reader["mom_dAddDate"] != null && reader["mom_dAddDate"].ToString() != string.Empty) { info.mom_dAddDate = Convert.ToDateTime(reader["mom_dAddDate"].ToString()); } if (reader["mom_cLast"] != null && reader["mom_cLast"].ToString() != string.Empty) { info.mom_cLast = reader["mom_cLast"].ToString().Trim(); } if (reader["mom_dLastDate"] != null && reader["mom_dLastDate"].ToString() != string.Empty) { info.mom_dLastDate = Convert.ToDateTime(reader["mom_dLastDate"].ToString()); } #endregion break; } } } catch (Exception Ex) { throw Ex; } } //Add By Ximonliang 2015-03-09------------------------<< return info; }
public bool UpdateRecord(MaintainOperationMaster_mom_Info infoObject) { bool isSuccess = false; #region 舊代碼 //using (MainDBDataContext db = new MainDBDataContext()) //{ // MaintainOperationMaster_mom query = db.MaintainOperationMaster_mom.SingleOrDefault(t => t.mom_iRecordID == infoObject.mom_iRecordID); // if (query != null) // { // query.mom_cOperationName = infoObject.mom_cOperationName; // query.mom_cOperationType = infoObject.mom_cOperationType; // query.mom_cMachineModel = infoObject.mom_cMachineModel; // query.mom_cStandardFilePath = infoObject.mom_cStandardFilePath; // //*(No: )Modify By Leothlink Sunwind Lee (Date:2013/03/06)*/lIsDeleted改為lIsAtive // //query.mom_lIsDeleted = infoObject.mom_lIsDeleted; // query.mom_lIsAtive = infoObject.mom_lIsAtive; // //*(No: )End Modify By Leothlink Sunwind Lee (Date:2013/03/06)*/lIsDeleted改為lIsAtive // query.mom_iCompleteTime = infoObject.mom_iCompleteTime; // query.mom_cLast = infoObject.mom_cLast; // query.mom_dLastDate = infoObject.mom_dLastDate; // db.SubmitChanges(); // isSuccess = true; // } //} #endregion //Add By Ximonliang 2015-03-09------------------------>> string strSql = string.Empty; if (infoObject != null) { try { using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { SqlTransaction transaction = null; conn.Open(); //開啟連接 transaction = conn.BeginTransaction(); //開啟事務 strSql += "update MaintainOperationMaster_mom" + Environment.NewLine; strSql += "set mom_cOperationName='" + infoObject.mom_cOperationName + "'" + Environment.NewLine; strSql += ",mom_cOperationType='" + infoObject.mom_cOperationType + "'" + Environment.NewLine; strSql += ",mom_cMachineModel='" + infoObject.mom_cMachineModel + "'" + Environment.NewLine; strSql += ",mom_cStandardFilePath='" + infoObject.mom_cStandardFilePath + "'" + Environment.NewLine; strSql += ",mom_lIsAtive=" + (infoObject.mom_lIsAtive == true ? "1" : "0") + Environment.NewLine; strSql += ",mom_iCompleteTime=" + infoObject.mom_iCompleteTime + Environment.NewLine; strSql += ",mom_cLast='" + infoObject.mom_cLast + "'" + Environment.NewLine; strSql += ",mom_dLastDate=getdate()" + Environment.NewLine; strSql += "where mom_iRecordID=" + infoObject.mom_iRecordID + Environment.NewLine; try { isSuccess = ExecuteSQL(strSql, transaction); } catch (Exception Ex) { transaction.Rollback(); throw Ex; } finally { if (isSuccess) transaction.Commit(); } } } catch (Exception Ex) { throw Ex; } } //Add By Ximonliang 2015-03-09------------------------<< return isSuccess; }
private string GetMaintainOperationMasterSQL(MaintainOperationMaster_mom_Info model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (model.mom_iRecordID != null) { strSql1.Append("mom_iRecordID,"); strSql2.Append("" + model.mom_iRecordID + ","); } if (model.mom_cOperationCode != null) { strSql1.Append("mom_cOperationCode,"); strSql2.Append("'" + model.mom_cOperationCode + "',"); } if (model.mom_cOperationName != null) { strSql1.Append("mom_cOperationName,"); strSql2.Append("'" + model.mom_cOperationName + "',"); } if (model.mom_cOperationType != null) { strSql1.Append("mom_cOperationType,"); strSql2.Append("'" + model.mom_cOperationType + "',"); } if (model.mom_cMachineModel != null) { strSql1.Append("mom_cMachineModel,"); strSql2.Append("'" + model.mom_cMachineModel + "',"); } if (model.mom_lIsAtive != null) { strSql1.Append("mom_lIsAtive,"); strSql2.Append("" + (model.mom_lIsAtive ? 1 : 0) + ","); } if (model.mom_cStandardFilePath != null) { strSql1.Append("mom_cStandardFilePath,"); strSql2.Append("'" + model.mom_cStandardFilePath + "',"); } if (model.mom_iCompleteTime != null) { strSql1.Append("mom_iCompleteTime,"); strSql2.Append("" + model.mom_iCompleteTime + ","); } if (model.mom_cAdd != null) { strSql1.Append("mom_cAdd,"); strSql2.Append("'" + model.mom_cAdd + "',"); } if (model.mom_dAddDate != null) { strSql1.Append("mom_dAddDate,"); strSql2.Append("'" + model.mom_dAddDate.ToString(this._sqlLiteDatetimeFormat) + "',"); } if (model.mom_cLast != null) { strSql1.Append("mom_cLast,"); strSql2.Append("'" + model.mom_cLast + "',"); } if (model.mom_dLastDate != null) { strSql1.Append("mom_dLastDate,"); strSql2.Append("'" + model.mom_dLastDate.ToString(this._sqlLiteDatetimeFormat) + "',"); } strSql.Append("insert into MaintainOperationMaster_mom("); 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(); }