/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttributeInfo">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseAttributeInfo, TBaseAttributeInfoVo.T_BASE_ATTRIBUTE_INFO_TABLE); strSQL += string.Format(" where ID='{0}' ", tBaseAttributeInfo.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttributeInfo_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseAttributeInfo_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttributeInfoVo tBaseAttributeInfo_UpdateSet, TBaseAttributeInfoVo tBaseAttributeInfo_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tBaseAttributeInfo_UpdateSet, TBaseAttributeInfoVo.T_BASE_ATTRIBUTE_INFO_TABLE); strSQL += this.BuildWhereStatement(tBaseAttributeInfo_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取属性信息 /// </summary> /// <returns></returns> private string getAttributeInfo() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); int intTotalCount = 0; DataTable dt = new DataTable(); TBaseAttributeInfoVo TBaseAttributeInfoVo = new TBaseAttributeInfoVo(); TBaseAttributeInfoVo.IS_DEL = "0"; TBaseAttributeInfoVo.SORT_FIELD = strSortname; TBaseAttributeInfoVo.SORT_TYPE = strSortorder; if (!String.IsNullOrEmpty(srhNmae) || !String.IsNullOrEmpty(srhControlId)) { TBaseAttributeInfoVo.ATTRIBUTE_NAME = srhNmae; TBaseAttributeInfoVo.CONTROL_NAME = srhControlId; dt = new TBaseAttributeInfoLogic().SelectDefinedTadble(TBaseAttributeInfoVo, intPageIndex, intPageSize); intTotalCount = new TBaseAttributeInfoLogic().GetSelecDefinedtResultCount(TBaseAttributeInfoVo); } else { dt = new TBaseAttributeInfoLogic().SelectByTable(TBaseAttributeInfoVo, intPageIndex, intPageSize); intTotalCount = new TBaseAttributeInfoLogic().GetSelectResultCount(TBaseAttributeInfoVo); } string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttributeInfoVo tBaseAttributeInfo, int iIndex, int iCount) { string strSQL = " select * from T_BASE_ATTRIBUTE_INFO {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tBaseAttributeInfo)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = "delete from T_BASE_ATTRIBUTE_INFO "; strSQL += this.BuildWhereStatement(tBaseAttributeInfo); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取属性信息 /// </summary> /// <returns></returns> public static string getAttributeInfo() { TBaseAttributeInfoVo TBaseAttributeInfoVo = new TBaseAttributeInfoVo(); TBaseAttributeInfoVo.IS_DEL = "0"; DataTable dt = new TBaseAttributeInfoLogic().SelectByTable(TBaseAttributeInfoVo); return(DataTableToJson(dt)); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TBaseAttributeInfoVo TBaseAttributeInfoVo = new TBaseAttributeInfoVo(); TBaseAttributeInfoVo.ID = Request["id"].ToString(); TBaseAttributeInfoVo.IS_DEL = "0"; TBaseAttributeInfoVo TBaseAttributeInfoVoTemp = new TBaseAttributeInfoLogic().Details(TBaseAttributeInfoVo); return(ToJson(TBaseAttributeInfoVoTemp)); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { TBaseAttributeInfoVo TBaseAttributeInfoVo = autoBindRequest(Request, new TBaseAttributeInfoVo()); TBaseAttributeInfoVo.ID = GetSerialNumber("AttributeInfo_Id"); TBaseAttributeInfoVo.IS_DEL = "0"; bool isSuccess = new TBaseAttributeInfoLogic().Create(TBaseAttributeInfoVo); if (isSuccess) { WriteLog("新增属性信息", "", LogInfo.UserInfo.USER_NAME + "新增属性信息" + TBaseAttributeInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TBaseAttributeInfoVo TBaseAttributeInfoVo = autoBindRequest(Request, new TBaseAttributeInfoVo()); TBaseAttributeInfoVo.ID = Request["id"].ToString(); TBaseAttributeInfoVo.IS_DEL = "0"; bool isSuccess = new TBaseAttributeInfoLogic().Edit(TBaseAttributeInfoVo); if (isSuccess) { WriteLog("修改属性信息", "", LogInfo.UserInfo.USER_NAME + "修改属性信息" + TBaseAttributeInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
public static string deleteAttributeInfo(string strValue) { TBaseAttributeInfoVo TBaseAttributeInfoVo = new TBaseAttributeInfoVo(); TBaseAttributeInfoVo.ID = strValue; TBaseAttributeInfoVo.IS_DEL = "1"; bool isSuccess = new TBaseAttributeInfoLogic().Edit(TBaseAttributeInfoVo); if (isSuccess) { new PageBase().WriteLog("删除属性信息", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除属性信息" + TBaseAttributeInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取自定义查询结果总数 Create By Castle(胡方扬) 2012-11-19 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <returns></returns> public int GetSelecDefinedtResultCount(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = String.Format("SELECT * FROM T_BASE_ATTRIBUTE_INFO WHERE IS_DEL='{0}'", tBaseAttributeInfo.IS_DEL); if (!String.IsNullOrEmpty(tBaseAttributeInfo.ATTRIBUTE_NAME)) { strSQL += String.Format(" AND ATTRIBUTE_NAME LIKE '%{0}%'", tBaseAttributeInfo.ATTRIBUTE_NAME); } if (!String.IsNullOrEmpty(tBaseAttributeInfo.CONTROL_NAME)) { strSQL += String.Format(" AND CONTROL_NAME ='{0}'", tBaseAttributeInfo.CONTROL_NAME); } return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count); }
/// <summary> /// 自定义查询 Create By Castle(胡方扬) 2012-11-19 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <param name="iIndex">起始页</param> /// <param name="iCount">条数</param> /// <returns></returns> public DataTable SelectDefinedTadble(TBaseAttributeInfoVo tBaseAttributeInfo, int iIndex, int iCount) { string strSQL = String.Format("SELECT * FROM T_BASE_ATTRIBUTE_INFO WHERE IS_DEL='{0}'", tBaseAttributeInfo.IS_DEL); if (!String.IsNullOrEmpty(tBaseAttributeInfo.ATTRIBUTE_NAME)) { strSQL += String.Format(" AND ATTRIBUTE_NAME LIKE '%{0}%'", tBaseAttributeInfo.ATTRIBUTE_NAME); } if (!String.IsNullOrEmpty(tBaseAttributeInfo.CONTROL_NAME)) { strSQL += String.Format(" AND CONTROL_NAME ='{0}'", tBaseAttributeInfo.CONTROL_NAME); } return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TBaseAttributeInfoVo tBaseAttributeInfo, int iIndex, int iCount) { return(access.SelectByTable(tBaseAttributeInfo, iIndex, iCount)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttributeInfoVo> SelectByObject(TBaseAttributeInfoVo tBaseAttributeInfo, int iIndex, int iCount) { return(access.SelectByObject(tBaseAttributeInfo, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseAttributeInfo">对象条件</param> /// <returns>对象</returns> public TBaseAttributeInfoVo Details(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.Details(tBaseAttributeInfo)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.GetSelectResultCount(tBaseAttributeInfo)); }
public TBaseAttributeInfoLogic(TBaseAttributeInfoVo _tBaseAttributeInfo) { tBaseAttributeInfo = _tBaseAttributeInfo; access = new TBaseAttributeInfoAccess(); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.Delete(tBaseAttributeInfo)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tBaseAttributeInfo">对象条件</param> /// <returns>对象</returns> public TBaseAttributeInfoVo Details(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = String.Format("select * from T_BASE_ATTRIBUTE_INFO " + this.BuildWhereStatement(tBaseAttributeInfo)); return(SqlHelper.ExecuteObject(new TBaseAttributeInfoVo(), strSQL)); }
public string UpdateSubTaskInfo(string workID, string strUser, string JsonSubTask, string JsonPoint, string JsonItem) { string strResult = "false"; var identification = CCFlowFacade.GetFlowIdentification(strUser, long.Parse(workID)); TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskLogic().Details(identification); TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskLogic().Details(objSubtaskVo.TASK_ID); DataTable dtSubTask = JSONToDataTable2(JsonSubTask); DataTable dtPoint = JSONToDataTable2(JsonPoint); DataTable dtItem = JSONToDataTable2(JsonItem); //更新任务的现状信息 if (dtSubTask.Rows.Count > 0) { objSubtaskVo.SAMPLE_ASK_DATE = dtSubTask.Rows[0]["SAMPLE_ASK_DATE"].ToString(); new TMisMonitorSubtaskLogic().Edit(objSubtaskVo); for (int i = 0; i < dtSubTask.Columns.Count; i++) { if (dtSubTask.Columns[i].ColumnName != "TICKET_NUM" && dtSubTask.Columns[i].ColumnName != "SAMPLE_ASK_DATE") { TMisMonitorSampleSkyVo objSampleSky = new TMisMonitorSampleSkyVo(); objSampleSky.SUBTASK_ID = objSubtaskVo.ID; objSampleSky.WEATHER_ITEM = dtSubTask.Columns[i].ColumnName; objSampleSky = new TMisMonitorSampleSkyLogic().Details(objSampleSky); if (objSampleSky.ID.Length > 0) { objSampleSky.WEATHER_INFO = dtSubTask.Rows[0][i].ToString(); new TMisMonitorSampleSkyLogic().Edit(objSampleSky); } else { objSampleSky.ID = GetSerialNumber("TMisMonitorSampleSky"); objSampleSky.SUBTASK_ID = objSubtaskVo.ID; objSampleSky.WEATHER_ITEM = dtSubTask.Columns[i].ColumnName; objSampleSky.WEATHER_INFO = dtSubTask.Rows[0][i].ToString(); new TMisMonitorSampleSkyLogic().Create(objSampleSky); } } } strResult = "true"; } //更新监测点位信息 if (dtPoint.Rows.Count > 0) { for (int i = 0; i < dtPoint.Rows.Count; i++) { TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo(); objSampleInfoVo.SUBTASK_ID = objSubtaskVo.ID; objSampleInfoVo.SAMPLE_NAME = dtPoint.Rows[i]["SAMPLE_NAME"].ToString(); objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo); if (objSampleInfoVo.ID.Length > 0) { objSampleInfoVo.SAMPLE_COUNT = dtPoint.Rows[i]["SAMPLE_COUNT"].ToString(); new TMisMonitorSampleInfoLogic().Edit(objSampleInfoVo); #region 更新点位图 if (dtPoint.Rows[i]["photo"].ToString().Length > 0) { string strImage = dtPoint.Rows[i]["photo"].ToString(); int tag = 0; FileStream out1 = null; byte[] bs = Convert.FromBase64String(strImage); //获取主文件路径 string mastPath = System.Configuration.ConfigurationManager.AppSettings["AttPath"].ToString(); //获取业务Id string strBusinessId = objSampleInfoVo.ID; //获取业务类型 string strBusinessType = "PointPoto"; //获取完整文件名称 string strFullName = strBusinessId + ".png"; //获取文件扩展名称 string strExtendName = strFullName.Substring(strFullName.LastIndexOf(".")); string strSerialNumber = GetSerialNumber("attFileId"); //文件夹路径 string strfolderPath = strBusinessType + "\\" + DateTime.Now.ToString("yyyyMMdd"); //新命名的文件名称 string strNewFileName = DateTime.Now.ToString("yyyyMMddHHmm") + "-" + strSerialNumber + strExtendName; //上传的完整路径 string strResultPath = mastPath + "\\" + strfolderPath + "\\" + strNewFileName; //开始上传附件 try { //判断文件夹是否存在,如果不存在则创建 if (Directory.Exists(mastPath + "\\" + strfolderPath) == false) { Directory.CreateDirectory(mastPath + "\\" + strfolderPath); } //判断原来是否已经上传过文件,如果有的话则获取原来已经上传的文件路径 TOaAttVo TOaAttVo = new TOaAttVo(); TOaAttVo.BUSINESS_TYPE = strBusinessType; TOaAttVo.BUSINESS_ID = strBusinessId; //TOaAttVo.ATTACH_NAME = this.ATTACH_NAME.Text.Trim(); DataTable objTable = new TOaAttLogic().SelectByTable(TOaAttVo); if (objTable.Rows.Count > 0) { //如果存在记录 //获取该记录的ID string strId = objTable.Rows[0]["ID"].ToString(); //获取原来文件的路径 string strOldFilePath = objTable.Rows[0]["UPLOAD_PATH"].ToString(); //如果存在的话,删除原来的文件 if (File.Exists(mastPath + "\\" + strOldFilePath)) { File.Delete(mastPath + "\\" + strOldFilePath); } //将新的信息写入数据库 TOaAttVo TOaAttVoTemp = new TOaAttVo(); TOaAttVoTemp.ID = strId; TOaAttVoTemp.ATTACH_NAME = "点位图"; TOaAttVoTemp.ATTACH_TYPE = strExtendName; TOaAttVoTemp.UPLOAD_PATH = strfolderPath + "\\" + strNewFileName; TOaAttVoTemp.UPLOAD_DATE = DateTime.Now.ToString("yyyy-MM-dd"); TOaAttVoTemp.UPLOAD_PERSON = strUser; TOaAttVoTemp.DESCRIPTION = "点位图"; TOaAttVoTemp.REMARKS = bs.Length + "KB";//文件的大小 new TOaAttLogic().Edit(TOaAttVoTemp); } else { //如果不存在记录 TOaAttVo TOaAttVoTemp = new TOaAttVo(); TOaAttVoTemp.ID = strSerialNumber; TOaAttVoTemp.BUSINESS_ID = strBusinessId; TOaAttVoTemp.BUSINESS_TYPE = strBusinessType; TOaAttVoTemp.ATTACH_NAME = "点位图"; TOaAttVoTemp.ATTACH_TYPE = strExtendName; TOaAttVoTemp.UPLOAD_PATH = strfolderPath + "\\" + strNewFileName; TOaAttVoTemp.UPLOAD_DATE = DateTime.Now.ToString("yyyy-MM-dd"); TOaAttVoTemp.UPLOAD_PERSON = strUser; TOaAttVoTemp.DESCRIPTION = "点位图"; TOaAttVoTemp.REMARKS = bs.Length + "KB";//文件的大小 new TOaAttLogic().Create(TOaAttVoTemp); } if (tag == 0) { out1 = new FileStream(strResultPath, FileMode.CreateNew, FileAccess.Write); } else { out1 = new FileStream(strResultPath, FileMode.Append, FileAccess.Write); } out1.Write(bs, 0, bs.Length); if (out1 != null) { try { out1.Close(); } catch (IOException e) { // TODO Auto-generated catch block } } } catch (Exception ex) { } } #endregion for (int j = 0; j < dtPoint.Columns.Count; j++) { if (dtPoint.Columns[j].ColumnName != "SAMPLE_NAME" && dtPoint.Columns[j].ColumnName != "SAMPLE_COUNT" && dtPoint.Columns[j].ColumnName != "photo") { TBaseAttributeInfoVo objAttributeInfoVo = new TBaseAttributeInfoVo(); objAttributeInfoVo.IS_DEL = "0"; objAttributeInfoVo.ATTRIBUTE_NAME = dtPoint.Columns[j].ColumnName; objAttributeInfoVo = new TBaseAttributeInfoLogic().Details(objAttributeInfoVo); if (objAttributeInfoVo.ID.Length > 0) { string Attribute_Code = objAttributeInfoVo.ID; TBaseAttrbuteValue3Vo objAttValue = new TBaseAttrbuteValue3Vo(); objAttValue.OBJECT_ID = objSampleInfoVo.POINT_ID; objAttValue.ATTRBUTE_CODE = Attribute_Code; objAttValue.IS_DEL = "0"; objAttValue = new TBaseAttrbuteValue3Logic().Details(objAttValue); if (objAttValue.ID == "") { objAttValue.ID = GetSerialNumber("t_base_attribute_value3_id"); objAttValue.IS_DEL = "0"; objAttValue.OBJECT_ID = objSampleInfoVo.POINT_ID; objAttValue.OBJECT_TYPE = objAttributeInfoVo.CONTROL_NAME; objAttValue.ATTRBUTE_CODE = Attribute_Code; objAttValue.ATTRBUTE_VALUE = dtPoint.Rows[i][dtPoint.Columns[j].ColumnName.ToString()].ToString(); new TBaseAttrbuteValue3Logic().Create(objAttValue); } else { objAttValue.ATTRBUTE_VALUE = dtPoint.Rows[i][dtPoint.Columns[j].ColumnName.ToString()].ToString(); new TBaseAttrbuteValue3Logic().Edit(objAttValue); } } } } } } strResult = "true"; } //更新监测项目的信息 if (dtItem.Rows.Count > 0) { for (int i = 0; i < dtItem.Rows.Count; i++) { TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo(); objSampleInfoVo.SUBTASK_ID = objSubtaskVo.ID; objSampleInfoVo.SAMPLE_NAME = dtItem.Rows[i]["SAMPLE_NAME"].ToString(); objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo); if (objSampleInfoVo.ID.Length > 0) { TBaseItemInfoVo objItemInfoVo = new TBaseItemInfoVo(); objItemInfoVo.ITEM_NAME = dtItem.Rows[i]["ITEM_NAME"].ToString(); objItemInfoVo.IS_DEL = "0"; objItemInfoVo = new TBaseItemInfoLogic().Details(objItemInfoVo); TMisMonitorResultVo objResultVo = new TMisMonitorResultVo(); objResultVo.SAMPLE_ID = objSampleInfoVo.ID; objResultVo.ITEM_ID = objItemInfoVo.ID; TMisMonitorResultVo objResultSetVo = new TMisMonitorResultVo(); objResultSetVo.ITEM_RESULT = dtItem.Rows[i]["ITEM_RESULT"].ToString(); new TMisMonitorResultLogic().Edit(objResultSetVo, objResultVo); } } strResult = "true"; } return(strResult); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.Create(tBaseAttributeInfo)); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <returns></returns> public TBaseAttributeInfoVo SelectByObject(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.SelectByObject(tBaseAttributeInfo)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <returns>是否成功</returns> public bool Create(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = SqlHelper.BuildInsertExpress(tBaseAttributeInfo, TBaseAttributeInfoVo.T_BASE_ATTRIBUTE_INFO_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TBaseAttributeInfoVo> SelectByObject(TBaseAttributeInfoVo tBaseAttributeInfo, int iIndex, int iCount) { string strSQL = String.Format("select * from T_BASE_ATTRIBUTE_INFO " + this.BuildWhereStatement(tBaseAttributeInfo)); return(SqlHelper.ExecuteObjectList(tBaseAttributeInfo, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseAttributeInfo"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = "select * from T_BASE_ATTRIBUTE_INFO " + this.BuildWhereStatement(tBaseAttributeInfo); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tBaseAttributeInfo">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TBaseAttributeInfoVo tBaseAttributeInfo) { string strSQL = "select Count(*) from T_BASE_ATTRIBUTE_INFO " + this.BuildWhereStatement(tBaseAttributeInfo); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttributeInfo">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.Edit(tBaseAttributeInfo)); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tBaseAttributeInfo"></param> /// <returns></returns> public string BuildWhereStatement(TBaseAttributeInfoVo tBaseAttributeInfo) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tBaseAttributeInfo) { //ID if (!String.IsNullOrEmpty(tBaseAttributeInfo.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tBaseAttributeInfo.ID.ToString())); } //属性名称 if (!String.IsNullOrEmpty(tBaseAttributeInfo.ATTRIBUTE_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ATTRIBUTE_NAME = '{0}'", tBaseAttributeInfo.ATTRIBUTE_NAME.ToString())); } //控件ID if (!String.IsNullOrEmpty(tBaseAttributeInfo.CONTROL_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTROL_ID = '{0}'", tBaseAttributeInfo.CONTROL_ID.ToString())); } //控件名称 if (!String.IsNullOrEmpty(tBaseAttributeInfo.CONTROL_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND CONTROL_NAME = '{0}'", tBaseAttributeInfo.CONTROL_NAME.ToString())); } //控件宽度 if (!String.IsNullOrEmpty(tBaseAttributeInfo.WIDTH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND WIDTH = '{0}'", tBaseAttributeInfo.WIDTH.ToString())); } //是否可编辑 if (!String.IsNullOrEmpty(tBaseAttributeInfo.ENABLE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ENABLE = '{0}'", tBaseAttributeInfo.ENABLE.ToString())); } //可否为空 if (!String.IsNullOrEmpty(tBaseAttributeInfo.IS_NULL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_NULL = '{0}'", tBaseAttributeInfo.IS_NULL.ToString())); } //最大长度 if (!String.IsNullOrEmpty(tBaseAttributeInfo.MAX_LENGTH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MAX_LENGTH = '{0}'", tBaseAttributeInfo.MAX_LENGTH.ToString())); } //字典项 if (!String.IsNullOrEmpty(tBaseAttributeInfo.DICTIONARY.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DICTIONARY = '{0}'", tBaseAttributeInfo.DICTIONARY.ToString())); } //数据库表名 if (!String.IsNullOrEmpty(tBaseAttributeInfo.TABLE_NAME.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TABLE_NAME = '{0}'", tBaseAttributeInfo.TABLE_NAME.ToString())); } //文本字段 if (!String.IsNullOrEmpty(tBaseAttributeInfo.TEXT_FIELD.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TEXT_FIELD = '{0}'", tBaseAttributeInfo.TEXT_FIELD.ToString())); } //值字段 if (!String.IsNullOrEmpty(tBaseAttributeInfo.VALUE_FIELD.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND VALUE_FIELD = '{0}'", tBaseAttributeInfo.VALUE_FIELD.ToString())); } //排序 if (!String.IsNullOrEmpty(tBaseAttributeInfo.SN.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND SN = '{0}'", tBaseAttributeInfo.SN.ToString())); } //使用状态(0为启用、1为停用) if (!String.IsNullOrEmpty(tBaseAttributeInfo.IS_DEL.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tBaseAttributeInfo.IS_DEL.ToString())); } //备注1 if (!String.IsNullOrEmpty(tBaseAttributeInfo.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tBaseAttributeInfo.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tBaseAttributeInfo.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tBaseAttributeInfo.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tBaseAttributeInfo.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tBaseAttributeInfo.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tBaseAttributeInfo.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tBaseAttributeInfo.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tBaseAttributeInfo.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tBaseAttributeInfo.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tBaseAttributeInfo"></param> /// <returns></returns> public DataTable SelectByTable(TBaseAttributeInfoVo tBaseAttributeInfo) { return(access.SelectByTable(tBaseAttributeInfo)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tBaseAttributeInfo_UpdateSet">UpdateSet用户对象</param> /// <param name="tBaseAttributeInfo_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TBaseAttributeInfoVo tBaseAttributeInfo_UpdateSet, TBaseAttributeInfoVo tBaseAttributeInfo_UpdateWhere) { return(access.Edit(tBaseAttributeInfo_UpdateSet, tBaseAttributeInfo_UpdateWhere)); }