public OpCheckListDetailObj GetOpCheckListDetailByInternalID(string InternalID) { OpCheckListDetailObj obj2 = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); parameters.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.InternalID.ActualFieldName, InternalID)); base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpCheckListDetail.ActualTableName); DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table != null) { if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; obj2 = new OpCheckListDetailObj(row[this.DataStructrure.Tables.OpCheckListDetail.InternalID.ActualFieldName].ToString()) { Answer = row[this.DataStructrure.Tables.OpCheckListDetail.Answer.ActualFieldName].ToString(), CheckListObj = new MasterCheckListObj(row[this.DataStructrure.Tables.OpCheckListDetail.CheckListID.ActualFieldName].ToString()), OpCheckListHeader = new OpCheckListHeaderObj(row[this.DataStructrure.Tables.OpCheckListDetail.HeaderID.ActualFieldName].ToString()) }; } return(obj2); } base.error_occured = true; base.ErrMsg = "[OpCheckListDetailManager] : GetOpCheckListDetailByInternalID : " + base.CurDBEngine.ErrorMessage; return(obj2); } base.error_occured = true; base.ErrMsg = "[OpCheckListDetailManager] : GetOpCheckListDetailByInternalID : " + base.ErrMsg; return(obj2); }
public bool UpdateOpCheckListDetail(OpCheckListDetailObj CurOpCheckListDetail) { bool flag = false; if (this.TryConnection()) { DatabaseParameters values = new DatabaseParameters(); DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.InternalID.ActualFieldName, CurOpCheckListDetail.InternalID)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.Answer.ActualFieldName, CurOpCheckListDetail.Answer.Replace("'", "''"), true, true)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.CheckListID.ActualFieldName, CurOpCheckListDetail.CheckListObj.InternalID)); values.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.HeaderID.ActualFieldName, CurOpCheckListDetail.OpCheckListHeader.InternalID)); base.CurSQLFactory.UpdateCommand(keys, values, this.DataStructrure.Tables.OpCheckListDetail.ActualTableName); if (!(flag = base.CurDBEngine.ExecuteQuery(base.CurSQLFactory.SQL))) { base.error_occured = true; string errMsg = base.ErrMsg; base.ErrMsg = errMsg + "[OpCheckListHeaderManager] : UpdateOpCheckListDetail : " + base.CurSQLFactory.SQL + " : " + base.CurDBEngine.ErrorMessage; } return(flag); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpCheckListHeaderManager] : UpdateOpCheckListDetail : " + base.ErrMsg; return(flag); }
public OpCheckListDetailCollection GetOpCheckListDetail() { OpCheckListDetailCollection details = null; if (this.TryConnection()) { DatabaseParameters parameters = new DatabaseParameters(); base.CurSQLFactory.SelectCommand(parameters, this.DataStructrure.Tables.OpCheckListDetail.ActualTableName); DataTable table = base.CurDBEngine.SelectQuery(base.CurSQLFactory.SQL); if (table != null) { details = new OpCheckListDetailCollection(); foreach (DataRow row in table.Rows) { OpCheckListDetailObj obj2 = new OpCheckListDetailObj(row[this.DataStructrure.Tables.OpCheckListDetail.InternalID.ActualFieldName].ToString()) { Answer = row[this.DataStructrure.Tables.OpCheckListDetail.Answer.ActualFieldName].ToString(), CheckListObj = new MasterCheckListObj(row[this.DataStructrure.Tables.OpCheckListDetail.CheckListID.ActualFieldName].ToString()), OpCheckListHeader = new OpCheckListHeaderObj(row[this.DataStructrure.Tables.OpCheckListDetail.HeaderID.ActualFieldName].ToString()) }; details.Add(obj2); } return(details); } base.error_occured = true; base.ErrMsg = "[OpCheckListDetailManager] : GetOpCheckListDetail : " + base.CurDBEngine.ErrorMessage; return(details); } base.error_occured = true; base.ErrMsg = "[OpCheckListDetailManager] : GetOpCheckListDetail : " + base.ErrMsg; return(details); }
public string CreateOpCheckListDetailSQL(OpCheckListDetailObj CurOpCheckListDetail) { if (this.TryConnection()) { DatabaseParameters keys = new DatabaseParameters(); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.InternalID.ActualFieldName, CurOpCheckListDetail.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.Answer.ActualFieldName, CurOpCheckListDetail.Answer.Replace("'", "''"), true, true)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.CheckListID.ActualFieldName, CurOpCheckListDetail.CheckListObj.InternalID)); keys.Add(new DatabaseParameter(this.DataStructrure.Tables.OpCheckListDetail.HeaderID.ActualFieldName, CurOpCheckListDetail.OpCheckListHeader.InternalID)); base.CurSQLFactory.InsertCommand(keys, this.DataStructrure.Tables.OpCheckListDetail.ActualTableName); return(base.CurSQLFactory.SQL); } base.error_occured = true; base.ErrMsg = base.ErrMsg + "[OpCheckListHeaderManager] : CreateOpCheckListDetail : " + base.ErrMsg; return(""); }