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