/// <summary> /// Сохранить изменения в БД /// </summary> /// <param name="objProfile">профайл</param> /// <returns>true - удачное завершение; false - ошибка</returns> public override System.Boolean Update(UniXP.Common.CProfile objProfile) { System.String strErr = ""; System.Boolean bRet = CIntWaybillStateDataBaseModel.EditObjectInDataBase(this.ID, this.Name, this.Description, this.IsActive, this.IsDefault, this.IntWaybillStateId, objProfile, ref strErr); if (bRet == false) { DevExpress.XtraEditors.XtraMessageBox.Show(strErr, "Внимание", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } return(bRet); }
/// <summary> /// Возвращает список состояний накладной /// </summary> /// <param name="objProfile">профайл</param> /// <param name="cmdSQL">SQL-команда</param> /// <param name="strErr">сообщение об ошибке</param> /// <returns>список состояний накладной</returns> public static List <CIntWaybillState> GetIntWaybillStateList(UniXP.Common.CProfile objProfile, ref System.String strErr) { List <CIntWaybillState> objList = new List <CIntWaybillState>(); try { // вызов статического метода из класса, связанного с БД System.Data.DataTable dtList = CIntWaybillStateDataBaseModel.GetWaybillStateList(objProfile, null, ref strErr); if (dtList != null) { CIntWaybillState objListItem = null; foreach (System.Data.DataRow objItem in dtList.Rows) { objListItem = new CIntWaybillState(); objListItem.ID = new Guid(System.Convert.ToString(objItem["IntWaybillState_Guid"])); objListItem.Name = ((objItem["IntWaybillState_Name"] == System.DBNull.Value) ? "" : System.Convert.ToString(objItem["IntWaybillState_Name"])); objListItem.Description = ((objItem["IntWaybillState_Description"] == System.DBNull.Value) ? "" : System.Convert.ToString(objItem["IntWaybillState_Description"])); objListItem.IntWaybillStateId = ((objItem["IntWaybillState_Id"] == System.DBNull.Value) ? 0 : System.Convert.ToInt32(System.Convert.ToString(objItem["IntWaybillState_Id"]))); if (objItem["IntWaybillState_IsActive"] != System.DBNull.Value) { objListItem.IsActive = System.Convert.ToBoolean(System.Convert.ToString(objItem["IntWaybillState_IsActive"])); } if (objItem["IntWaybillState_IsDefault"] != System.DBNull.Value) { objListItem.IsDefault = System.Convert.ToBoolean(System.Convert.ToString(objItem["IntWaybillState_IsDefault"])); } objList.Add(objListItem); } } dtList = null; } catch (System.Exception f) { strErr += (String.Format(" {0}", f.Message)); } return(objList); }
/// <summary> /// Добавить запись в БД /// </summary> /// <param name="objProfile">профайл</param> /// <returns>true - удачное завершение; false - ошибка</returns> public override System.Boolean Add(UniXP.Common.CProfile objProfile) { System.String strErr = ""; System.Guid GUID_ID = System.Guid.Empty; System.Boolean bRet = CIntWaybillStateDataBaseModel.AddNewObjectToDataBase( this.Name, this.Description, this.IsActive, this.IsDefault, this.IntWaybillStateId, ref GUID_ID, objProfile, ref strErr); if (bRet == true) { this.ID = GUID_ID; } else { DevExpress.XtraEditors.XtraMessageBox.Show(strErr, "Внимание", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error); } return(bRet); }