void rptRemarks_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var ltlRemarkType = e.Item.FindControl("ltlRemarkType") as Literal;
var ltlAddDate = e.Item.FindControl("ltlAddDate") as Literal;
var ltlDepartmentAndUserName = e.Item.FindControl("ltlDepartmentAndUserName") as Literal;
var ltlRemark = e.Item.FindControl("ltlRemark") as Literal;
var departmentID = SqlUtils.EvalInt(e.Item.DataItem, "DepartmentID");
var userName = SqlUtils.EvalString(e.Item.DataItem, "UserName");
var addDate = SqlUtils.EvalDateTime(e.Item.DataItem, "AddDate");
var remarkType = EGovInteractRemarkTypeUtils.GetEnumType(SqlUtils.EvalString(e.Item.DataItem, "RemarkType"));
var remark = SqlUtils.EvalString(e.Item.DataItem, "Remark");
if (string.IsNullOrEmpty(remark))
{
e.Item.Visible = false;
}
else
{
phRemarks.Visible = true;
ltlRemarkType.Text = EGovInteractRemarkTypeUtils.GetText(remarkType);
ltlAddDate.Text = DateUtils.GetDateAndTimeString(addDate);
ltlDepartmentAndUserName.Text = $"{DepartmentManager.GetDepartmentName(departmentID)}({userName})";
ltlRemark.Text = remark;
}
}
}
public void Insert(GovInteractRemarkInfo remarkInfo)
{
var sqlString = "INSERT INTO wcm_GovInteractRemark(PublishmentSystemID, NodeID, ContentID, RemarkType, Remark, DepartmentID, UserName, AddDate) VALUES (@PublishmentSystemID, @NodeID, @ContentID, @RemarkType, @Remark, @DepartmentID, @UserName, @AddDate)";
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, remarkInfo.PublishmentSystemID),
GetParameter(ParmNodeId, EDataType.Integer, remarkInfo.NodeID),
GetParameter(ParmContentId, EDataType.Integer, remarkInfo.ContentID),
GetParameter(ParmRemarkType, EDataType.VarChar, 50, EGovInteractRemarkTypeUtils.GetValue(remarkInfo.RemarkType)),
GetParameter(ParmRemark, EDataType.NVarChar, 255, remarkInfo.Remark),
GetParameter(ParmDepartmentId, EDataType.Integer, remarkInfo.DepartmentID),
GetParameter(ParmUserName, EDataType.VarChar, 50, remarkInfo.UserName),
GetParameter(ParmAddDate, EDataType.DateTime, remarkInfo.AddDate)
};
ExecuteNonQuery(sqlString, parms);
}
public static string GetApplyRemark(int publishmentSystemID, int contentID)
{
var remarkBuilder = new StringBuilder();
var remarkInfoArrayList = DataProvider.GovInteractRemarkDao.GetRemarkInfoArrayList(publishmentSystemID, contentID);
foreach (GovInteractRemarkInfo remarkInfo in remarkInfoArrayList)
{
if (!string.IsNullOrEmpty(remarkInfo.Remark))
{
if (remarkBuilder.Length > 0)
{
remarkBuilder.Append("<br />");
}
remarkBuilder.Append(
$@"<span style=""color:gray;"">{EGovInteractRemarkTypeUtils.GetText(remarkInfo.RemarkType)}意见: </span>{StringUtils
.MaxLengthText(remarkInfo.Remark, 25)}");
}
}
return(remarkBuilder.ToString());
}
public ArrayList GetRemarkInfoArrayList(int publishmentSystemId, int contentId)
{
var arraylist = new ArrayList();
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentsystemid, EDataType.Integer, publishmentSystemId),
GetParameter(ParmContentId, EDataType.Integer, contentId)
};
using (var rdr = ExecuteReader(SqlSelectAll, parms))
{
while (rdr.Read())
{
var i = 0;
var remarkInfo = new GovInteractRemarkInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), EGovInteractRemarkTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
arraylist.Add(remarkInfo);
}
rdr.Close();
}
return(arraylist);
}
public GovInteractRemarkInfo GetRemarkInfo(int remarkId)
{
GovInteractRemarkInfo remarkInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmRemarkId, EDataType.Integer, remarkId)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
var i = 0;
remarkInfo = new GovInteractRemarkInfo(GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), EGovInteractRemarkTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetDateTime(rdr, i));
}
rdr.Close();
}
return(remarkInfo);
}
