/// <summary>
/// 新增时的数据校验
/// </summary>
/// <param name="pDTInfo"></param>
/// <returns></returns>
public Common.CResultInfo AddCheck(System.Data.DataTable pDTInfo)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();
try
{
if (Common.CCommonCheck.CheckFieldValueExist(m_sTableCode, m_sPKField, pDTInfo.Rows[0][m_sTableCode + "." + m_sPKField].ToString()) == true)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = "记录已经存在，请重新录入!";
pResultInfo.ErrorResID = "IDAlreayExist";
return(pResultInfo);
}
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
/// <summary>
/// 修改数据的校验
/// </summary>
/// <param name="pDTInfo"></param>
/// <returns></returns>
public Common.CResultInfo ModifyCheck(System.Data.DataTable pDTInfo)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();
try
{
if (Common.CCommonCheck.CheckDataModified(m_sTableCode, m_sPKField, pDTInfo.Rows[0][m_sTableCode + "." + m_sPKField].ToString(), pDTInfo.Rows[0]["vTP"].ToString()) == true)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = "数据已经被修改，修改失败!";
pResultInfo.ErrorResID = "DataModified";
return(pResultInfo);
}
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
/// <summary>
/// 新增数据到数据库中
/// </summary>
/// <param name="pDTInfo"></param>
/// <returns></returns>
public Common.CResultInfo Add(System.Data.DataTable pDTInfo)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();;
try
{
string sParentID = pDTInfo.Rows[0][base.TableCode + ".vParentID"].ToString();
pResultInfo = base.Add(pDTInfo);
if (pResultInfo.bSuccess == false)
{
return(pResultInfo);
}
if (sParentID.Trim() != "")
{
Cnwit.Utility.DataAcess pDataAccess = Common.GetProjectDataAcess.GetDataAcess();
pDataAccess.scExecuteQuery("update " + base.TableCode + " set bChildFlag = 0 where vID = '" + sParentID + "';update " + base.TableCode + " set vParentID = '" + sParentID + "' where vID = '" + pDTInfo.Rows[0][base.TableCode + ".vID"].ToString() + "'");
return(pResultInfo);
}
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
public Common.CResultInfo SynUserInfo(System.Data.DataTable dtInfo, string sUserID, string sUserName)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();
string sEmployeeID = dtInfo.Rows[0]["sc_employee.vEmployeeID"].ToString().Trim();
string sMobile = dtInfo.Rows[0]["sc_employee.vMobile"].ToString().Trim();
string sTelephone = dtInfo.Rows[0]["sc_employee.vTelephone"].ToString().Trim();
string sEmail = dtInfo.Rows[0]["sc_employee.vEmail"].ToString().Trim();
try
{
if (sUserID.Trim() == "")
{
if (Common.CCommonCheck.CheckFieldValueExist("sc_user", "vUserID", sUserID))
{ //用户已经存在，不能删除，只能进行撤销工作
pResultInfo.bSuccess = false;
pResultInfo.ErrorResID = "UserIDExist";
return(pResultInfo);
}
else
{ //属于添加操作,提示不能为空
pResultInfo.bSuccess = false;
pResultInfo.ErrorResID = "UserIDNotNull";
return(pResultInfo);
}
}
if (sUserName.Trim() == "")
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorResID = "UserNameNotNull";
return(pResultInfo);
}
string sPK = System.Guid.NewGuid().ToString();
string sSql = "Insert into sc_user(PK_SC_User,vUserID,vUserName,vMobile,vTelephone,vEmail,vEmployeeid) values('" + sPK + "','" + sUserID + "','" + sUserName + "','" + sMobile + "','" + sTelephone + "','" + sEmail + "','" + sEmployeeID + "')";
DataAcess pDataAccess = Common.GetProjectDataAcess.GetDataAcess();
pDataAccess.scExecuteQuery(sSql);
pResultInfo.bSuccess = true;
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
/// <summary>
/// 删除数据校验
/// </summary>
/// <param name="pDTInfo"></param>
/// <returns></returns>
public Common.CResultInfo DeleteCheck(System.Data.DataTable pDTInfo)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();
try
{
foreach (System.Data.DataRow pDRInfo in pDTInfo.Rows)
{
}
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
/// <summary>
/// 新增数据到数据库中
/// </summary>
/// <param name="pDTInfo"></param>
/// <returns></returns>
public Common.CResultInfo Add(System.Data.DataTable pDTInfo)
{
Common.CResultInfo pResultInfo = new Common.CResultInfo();
try
{
string sInsertSql = GenerateInsertSql(pDTInfo);
DataAcess pDataAccess = Common.GetProjectDataAcess.GetDataAcess();
pDataAccess.scExecuteQuery(sInsertSql);
pResultInfo.bSuccess = true;
}
catch (System.Data.SqlClient.SqlException sqlErr)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorID = sqlErr.Number.ToString();
}
catch (System.Exception err)
{
pResultInfo.bSuccess = false;
pResultInfo.ErrorDesc = err.Message;
}
return(pResultInfo);
}
