public ReturnValueInfo UpdateRecord(ClientMasterInfo clientInfo)
{
if (clientInfo == null)
{
return null;
}
ReturnValueInfo returnValue = new ReturnValueInfo();
bool isSuccess = false;
try
{
isSuccess = this._clientMasterDA.UpdateRecord(clientInfo);
}
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;
}
private void ValidateValue(ClientMasterInfo clientInfo, ReturnValueInfo returnValue)
{
string messageText = string.Empty;
returnValue.boolValue = true;
if (clientInfo.ClmCClientNum.Trim() == string.Empty)
{
returnValue.boolValue = false;
returnValue.messageText = "\"客户编号\"" + DefineConstantValue.SystemMessageText.strMessageText_W_CannotEmpty;
}
}
public ReturnValueInfo InsertRecord(ClientMasterInfo clientInfo)
{
if (clientInfo == null)
{
return null;
}
ReturnValueInfo returnValue = new ReturnValueInfo();
ValidateValue(clientInfo, returnValue);
if (!returnValue.boolValue)
{
return returnValue;
}
bool isExistRecord = false;
try
{
isExistRecord = this._clientMasterDA.IsExistRecord(clientInfo.ClmCClientNum);
}
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._clientMasterDA.InsertRecord(clientInfo);
}
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 ClientMasterInfo[] SearchRecords(ClientMasterInfo clientMasterInfo)
{
ClientMasterInfo[] infos = null;
List<ClientMasterInfo> deptMasterInfoList = null;
try
{
deptMasterInfoList = this._clientMasterDA.SearchRecords(clientMasterInfo);
}
catch (Exception Ex)
{
throw Ex;
}
if (deptMasterInfoList != null)
{
infos = deptMasterInfoList.ToArray();
}
return infos;
}
private ClientMasterInfo GetRecord(SqlDataReader dr)
{
ClientMasterInfo clientMaster = null;
if (dr != null)
{
clientMaster = new ClientMasterInfo();
if (dr["clm_iRecID"] != null)
{
clientMaster.ClmIRecID = Convert.ToInt32(dr["clm_iRecID"]);
}
if (dr["clm_cClientNum"] != null)
{
clientMaster.ClmCClientNum = dr["clm_cClientNum"].ToString().Trim();
}
if (dr["clm_cEnglishName"] != null)
{
clientMaster.ClmCEnglishName = dr["clm_cEnglishName"].ToString().Trim();
}
if (dr["clm_cChinaName"] != null)
{
clientMaster.ClmCChinaName = dr["clm_cChinaName"].ToString().Trim();
}
if (dr["clm_cTaxNumber"] != null)
{
clientMaster.ClmCTaxNumber = dr["clm_cTaxNumber"].ToString().Trim();
}
if (dr["clm_cLinkman"] != null)
{
clientMaster.ClmCLinkman = dr["clm_cLinkman"].ToString().Trim();
}
if (dr["clm_cAddress"] != null)
{
clientMaster.ClmCAddress = dr["clm_cAddress"].ToString().Trim();
}
if (dr["clm_cPhone"] != null)
{
clientMaster.ClmCPhone = dr["clm_cPhone"].ToString().Trim();
}
if (dr["clm_cFax"] != null)
{
clientMaster.ClmCFax = dr["clm_cFax"].ToString().Trim();
}
if (dr["clm_cWebSite"] != null)
{
clientMaster.ClmCWebSite = dr["clm_cWebSite"].ToString().Trim();
}
if (dr["clm_cRemark"] != null)
{
clientMaster.ClmCRemark = dr["clm_cRemark"].ToString().Trim();
}
if (dr["clm_cAdd"] != null)
{
clientMaster.ClmCAdd = dr["clm_cAdd"].ToString().Trim();
}
if (dr["clm_dAddDate"] != null)
{
clientMaster.ClmDAddDate = Convert.ToDateTime(dr["clm_dAddDate"]);
}
if (dr["clm_cLast"] != null)
{
clientMaster.ClmCLast = dr["clm_cLast"].ToString().Trim();
}
if (dr["clm_dLastDate"] != null)
{
clientMaster.ClmDLastDate = Convert.ToDateTime(dr["clm_dLastDate"]);
}
}
return clientMaster;
}
public bool UpdateRecord(ClientMasterInfo infoObject)
{
string l_strSQL = string.Empty;
bool isSuccess = false;
if (infoObject == null)
{
return isSuccess;
}
l_strSQL = "UPDATE ClientMaster_clm SET ";
l_strSQL += "clm_cEnglishName='"+infoObject.ClmCEnglishName.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cChinaName=N'"+infoObject.ClmCChinaName.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cTaxNumber=N'" + infoObject.ClmCTaxNumber.Replace("'", "''").Trim() + "'," + Environment.NewLine;
l_strSQL += "clm_cLinkman=N'"+infoObject.ClmCLinkman.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cAddress=N'"+infoObject.ClmCAddress.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cPhone=N'"+infoObject.ClmCPhone.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cFax=N'"+infoObject.ClmCFax.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cWebSite=N'"+infoObject.ClmCWebSite.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cRemark=N'"+infoObject.ClmCRemark.Replace("'", "''").Trim()+"'," + Environment.NewLine;
l_strSQL += "clm_cLast='"+infoObject.ClmCLast.Replace("'", "''")+"'," + Environment.NewLine;
l_strSQL += "clm_dLastDate=GETDATE() " + Environment.NewLine;
l_strSQL += " WHERE clm_iRecID=" + infoObject.ClmIRecID.ToString();
DataAccessLayer dal = new DataAccessLayer();
try
{
isSuccess = dal.ExecNonQuery(l_strSQL);
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public List<ClientMasterInfo> SearchRecords(ClientMasterInfo clientMasterInfo)
{
string sqlString = string.Empty;
string whereString = string.Empty;
sqlString = "SELECT TOP 100 clm_iRecID,"+Environment.NewLine;
sqlString+="clm_cClientNum,"+Environment.NewLine;
sqlString+="clm_cEnglishName,"+Environment.NewLine;
sqlString+="clm_cChinaName,"+Environment.NewLine;
sqlString += "clm_cTaxNumber," + Environment.NewLine;
sqlString+="clm_cLinkman,"+Environment.NewLine;
sqlString+="clm_cAddress,"+Environment.NewLine;
sqlString+="clm_cPhone,"+Environment.NewLine;
sqlString+="clm_cFax,"+Environment.NewLine;
sqlString+="clm_cWebSite,"+Environment.NewLine;
sqlString+="clm_cRemark,"+Environment.NewLine;
sqlString+="clm_cAdd,"+Environment.NewLine;
sqlString+="clm_dAddDate,"+Environment.NewLine;
sqlString+="clm_cLast,"+Environment.NewLine;
sqlString+="clm_dLastDate "+Environment.NewLine;
sqlString+=" FROM ClientMaster_clm ";
if (clientMasterInfo != null)
{
whereString = " WHERE 1=1 ";
if (clientMasterInfo.ClmCClientNum.Trim().Length > 0)
{
whereString += " AND clm_cClientNum='" + clientMasterInfo.ClmCClientNum.Trim().Replace("'","''")+"'";
}
if (clientMasterInfo.ClmCChinaName.Trim().Length > 0)
{
//whereString += " AND clm_cChinaName LIKE N'" + General.ReplaceSQLLikeCondition(clientMasterInfo.ClmCChinaName.Trim().Replace("'", "''")) + "'";
}
}
sqlString += whereString;
DataAccessLayer dal = new DataAccessLayer();
List<ClientMasterInfo> clientMasterInfoList=null;
SqlDataReader dr = null;
try
{
dr = dal.GetDataReader(sqlString);
if (dr != null)
{
clientMasterInfoList = new List<ClientMasterInfo>();
ClientMasterInfo cmInfo = null;
while (dr.Read())
{
cmInfo = GetRecord(dr);
clientMasterInfoList.Add(cmInfo);
}
}
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (dr != null)
{
dr.Close();
}
}
return clientMasterInfoList;
}
public bool InsertRecord(ClientMasterInfo infoObject)
{
string l_strSQL = string.Empty;
bool isSuccess = false;
if (infoObject == null)
{
return isSuccess;
}
l_strSQL = "INSERT ClientMaster_clm(";
l_strSQL += "clm_cClientNum," + Environment.NewLine;
l_strSQL += "clm_cEnglishName," + Environment.NewLine;
l_strSQL += "clm_cChinaName," + Environment.NewLine;
l_strSQL += "clm_cTaxNumber," + Environment.NewLine;
l_strSQL += "clm_cLinkman," + Environment.NewLine;
l_strSQL += "clm_cAddress," + Environment.NewLine;
l_strSQL += "clm_cPhone," + Environment.NewLine;
l_strSQL += "clm_cFax," + Environment.NewLine;
l_strSQL += "clm_cWebSite," + Environment.NewLine;
l_strSQL += "clm_cRemark," + Environment.NewLine;
l_strSQL += "clm_cAdd," + Environment.NewLine;
l_strSQL += "clm_dAddDate," + Environment.NewLine;
l_strSQL += "clm_cLast," + Environment.NewLine;
l_strSQL += "clm_dLastDate )" + Environment.NewLine;
l_strSQL += " VALUES(";
l_strSQL += "'" + infoObject.ClmCClientNum.Trim().Replace("'", "''") + "'";
l_strSQL += ",'" + infoObject.ClmCEnglishName.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCChinaName.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCTaxNumber.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCLinkman.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCAddress.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCPhone.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCFax.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCWebSite.Replace("'", "''").Trim() + "'";
l_strSQL += ",N'" + infoObject.ClmCRemark.Replace("'", "''").Trim() + "'";
l_strSQL += ",'" + infoObject.ClmCAdd.Replace("'", "''").Trim() + "'";
l_strSQL += ",GETDATE()";
l_strSQL += ",'" + infoObject.ClmCLast.Replace("'", "''") + "'";
l_strSQL += ",GETDATE())";
DataAccessLayer dal = new DataAccessLayer();
try
{
isSuccess = dal.ExecNonQuery(l_strSQL);
}
catch (Exception Ex)
{
throw Ex;
}
return isSuccess;
}
public ClientMasterInfo GetTableFieldLenght()
{
ClientMasterInfo cmInfo = new ClientMasterInfo();
cmInfo.ClmCClientNum_Lenght = 30;
cmInfo.ClmCChinaName_Lenght = 50;
cmInfo.ClmCEnglishName_Lenght = 100;
cmInfo.ClmCTaxNumber_Lenght = 50;
cmInfo.ClmCLinkman_Lenght = 50;
cmInfo.ClmCAddress_Lenght = 100;
cmInfo.ClmCPhone_Lenght = 50;
cmInfo.ClmCFax_Lenght = 50;
cmInfo.ClmCWebSite_Lenght = 50;
cmInfo.ClmCRemark_Lenght = 200;
return cmInfo;
}