public ReturnValueInfo UpdateRecord(DeptMasterInfo deptInfo)
{
if (deptInfo == null)
{
return(null);
}
ReturnValueInfo returnValue = new ReturnValueInfo();
bool isSuccess = false;
try
{
isSuccess = this._deptMasterDA.UpdateRecord(deptInfo);
}
catch (Exception Ex)
{
throw Ex;
}
if (isSuccess)
{
returnValue.boolValue = true;
returnValue.messageText = DefineConstantValue.SystemMessageText.strMessageText_I_UpdateSuccess;
}
else
{
returnValue.boolValue = false;
returnValue.messageText = DefineConstantValue.SystemMessageText.strMessageText_I_UpdateFail;
}
return(returnValue);
}
public ReturnValueInfo InsertRecord(DeptMasterInfo deptInfo)
{
if (deptInfo == null)
{
return(null);
}
ReturnValueInfo returnValue = new ReturnValueInfo();
ValidateValue(deptInfo, returnValue);
if (!returnValue.boolValue)
{
return(returnValue);
}
bool isExistRecord = false;
try
{
isExistRecord = this._deptMasterDA.IsExistRecord(deptInfo.DpmCDeptNumber);
}
catch (Exception Ex)
{
throw Ex;
}
if (isExistRecord)
{
returnValue.boolValue = false;
returnValue.messageText = DefineConstantValue.SystemMessageText.strMessageText_I_RecordIsExist;
return(returnValue);
}
bool isSuccess = false;
try
{
isSuccess = this._deptMasterDA.InsertRecord(deptInfo);
}
catch (Exception Ex)
{
throw Ex;
}
if (isSuccess)
{
returnValue.boolValue = true;
returnValue.messageText = DefineConstantValue.SystemMessageText.strMessageText_I_AddSuccess;
}
else
{
returnValue.boolValue = false;
returnValue.messageText = DefineConstantValue.SystemMessageText.strMessageText_I_AddFail;
}
return(returnValue);
}
public Model.Master.DeptMasterInfo GetTableFieldLenght()
{
DeptMasterInfo deptMasterInfo = new DeptMasterInfo();
deptMasterInfo.DeptName_Lenght = 20;
deptMasterInfo.DeptNumber_Lenght = 20;
deptMasterInfo.Remark_Lenght = 50;
return(deptMasterInfo);
}
private void ValidateValue(DeptMasterInfo deptInfo, ReturnValueInfo returnValue)
{
string messageText = string.Empty;
returnValue.boolValue = true;
if (deptInfo.DpmCDeptNumber.Trim() == string.Empty)
{
returnValue.boolValue = false;
returnValue.messageText = "\"部门编号\"" + DefineConstantValue.SystemMessageText.strMessageText_W_CannotEmpty;
}
}
public DeptMasterInfo GetRecord(string deptNum)
{
DeptMasterInfo info = null;
try
{
info = _deptMasterDA.GetRecord(deptNum);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public DeptMasterInfo DisplayRecord(IModelObject KeyObject)
{
DeptMasterInfo info = null;
try
{
info = _deptMasterDA.DisplayRecord(KeyObject);
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public DeptMasterInfo GetTableFieldLenght()
{
DeptMasterInfo info = null;
try
{
info = this._deptMasterDA.GetTableFieldLenght();
}
catch (Exception Ex)
{
throw Ex;
}
return(info);
}
public DeptMasterInfo GetRecord(IModelObject KeyObject)
{
string sqlString = string.Empty;
DeptMasterInfo info = KeyObject as DeptMasterInfo;
sqlString = "SELECT * FROM " + this._dataDictionary[DeptMasterInfoEnum.TableName.ToString()] + Environment.NewLine;
sqlString += " WHERE " + this._dataDictionary[DeptMasterInfoEnum.DpmCDeptNumber.ToString()] + "='" + info.DpmCDeptNumber.Replace("'", "''") + "'";
DataBaseCommand <DeptMasterInfo> dbCommand = new DataBaseCommand <DeptMasterInfo>();
DeptMasterInfo deptMasterInfo;
try
{
deptMasterInfo = dbCommand.GetRecord(sqlString, this._dataDictionary);
}
catch (Exception Ex)
{
throw Ex;
}
return(deptMasterInfo);
}
public bool DeleteRecord(IModelObject KeyObject)
{
string sqlString = string.Empty;
bool isSuccess = false;
DeptMasterInfo info = KeyObject as DeptMasterInfo;
sqlString = "DELETE FROM " + this._dataDictionary[DeptMasterInfoEnum.TableName.ToString()] + this._newLineSybm;
sqlString += " WHERE " + this._dataDictionary[DeptMasterInfoEnum.RecordID.ToString()] + "=" + info.RecordID.ToString();
DataAccessLayer dal = new DataAccessLayer();
try
{
isSuccess = dal.ExecNonQuery(sqlString);
}
catch (Exception Ex)
{
throw Ex;
}
return(isSuccess);
}
bool DAL.IDAL.IMainDA <DeptMasterInfo> .UpdateRecord(DeptMasterInfo infoObject)
{
throw new NotImplementedException();
}
