/// <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); }