public bool InsertRecord(CodeMasterInfo infoObject)
{
string sqlString = string.Empty;
bool isSuccess = false;
if (infoObject == null)
{
return isSuccess;
}
sqlString = "INSERT INTO " + this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()] + "(" + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCValue.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtFNumber.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCRemark.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCRemark2.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCAdd.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtDAddDate.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCLast.ToString()] + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtDLastDate.ToString()] + ")" + this._newLineSybm;
sqlString += "VALUES(" + this._newLineSybm;
sqlString += "'" + infoObject.CmtCKey1.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += "'" + infoObject.CmtCKey2.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += "'" + infoObject.CmtCValue.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += infoObject.CmtFNumber.ToString() + "," + this._newLineSybm;
sqlString += "'" + infoObject.CmtCRemark.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += "'" + infoObject.CmtCRemark2.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += "'" + infoObject.CmtCAdd.Trim().Replace("'", "''") + "'," + this._newLineSybm;
if (infoObject.CmtDAddDate == null)
{
sqlString += "NULL," + this._newLineSybm;
}
else
{
sqlString += "'" + infoObject.CmtDAddDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "'," + this._newLineSybm;
}
sqlString += "'" + infoObject.CmtCLast.Trim().Replace("'", "''") + "'," + this._newLineSybm;
if (infoObject.CmtDLastDate == null)
{
sqlString += "NULL)" + this._newLineSybm;
}
else
{
sqlString += "'" + infoObject.CmtDLastDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "')" + this._newLineSybm;
}
DataAccessLayer dal = new DataAccessLayer();
try
{
isSuccess = dal.ExecNonQuery(sqlString);
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public bool UpdateRecord(CodeMasterInfo infoObject)
{
string sqlString = string.Empty;
bool isSuccess = false;
if (infoObject == null)
{
return isSuccess;
}
sqlString = "UPDATE " + this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()] + " SET " + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCValue.ToString()] + "='" + infoObject.CmtCValue.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtFNumber.ToString()] + "=" + infoObject.CmtFNumber.ToString() + "," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCRemark.ToString()] + "='" + infoObject.CmtCRemark.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCRemark2.ToString()] + "='" + infoObject.CmtCRemark2.Trim().Replace("'", "''") + "'," + this._newLineSybm;
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtCLast.ToString()] + "='" + infoObject.CmtCLast.Trim().Replace("'", "''") + "'," + this._newLineSybm;
if (infoObject.CmtDLastDate == null)
{
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtDLastDate.ToString()] + "=NULL" + this._newLineSybm;
}
else
{
sqlString += this._dataBaseDic[CodeMasterInfoEnum.CmtDLastDate.ToString()] + "='" + infoObject.CmtDLastDate.Value.ToString("yyyy-MM-dd hh:mm:ss") + "'" + this._newLineSybm;
}
sqlString += " WHERE " + this._dataBaseDic[CodeMasterInfoEnum.CmtIRecID.ToString()] + "=" + infoObject.CmtIRecID.ToString();
DataAccessLayer dal = new DataAccessLayer();
try
{
isSuccess = dal.ExecNonQuery(sqlString);
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public CodeMasterInfo GetTableFieldLenght()
{
CodeMasterInfo codeMasterInfo = null;
codeMasterInfo = new CodeMasterInfo();
codeMasterInfo.CmtCKey1_Lenght = 30;
codeMasterInfo.CmtCKey2_Lenght = 30;
codeMasterInfo.CmtCValue_Lenght = 30;
codeMasterInfo.CmtCRemark_Lenght = 200;
codeMasterInfo.CmtCRemark2_Lenght = 200;
codeMasterInfo.CmtCAdd_Lenght = 20;
codeMasterInfo.CmtCLast_Lenght = 20;
#region MyRegion
//Dictionary<string, int> dic = null;
//DataBaseCommand<CodeMasterInfo> dbc = new DataBaseCommand<CodeMasterInfo>();
//try
//{
// dic = dbc.GetTableFieldLenght(this._dataBaseDic[CodeMasterInfoEnum.TableName.ToString()]);
//}
//catch (Exception Ex)
//{
// throw Ex;
//}
//if (dic != null)
//{
// codeMasterInfo = new CodeMasterInfo();
// codeMasterInfo.CmtCKey1_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCKey1.ToString()]];
// codeMasterInfo.CmtCKey2_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()]];
// codeMasterInfo.CmtCValue_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCValue.ToString()]];
// codeMasterInfo.CmtCRemark_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCRemark.ToString()]];
// codeMasterInfo.CmtCRemark2_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCKey2.ToString()]];
// codeMasterInfo.CmtCAdd_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCAdd.ToString()]];
// codeMasterInfo.CmtCLast_Lenght = dic[this._dataBaseDic[CodeMasterInfoEnum.CmtCLast.ToString()]];
//}
#endregion
return codeMasterInfo;
}