public override void Submit_OnClick(object sender, EventArgs e)
{
var isChanged = false;
GovInteractTypeInfo typeInfo = null;
if (_typeId > 0)
{
try
{
typeInfo = DataProvider.GovInteractTypeDao.GetTypeInfo(_typeId);
if (typeInfo != null)
{
typeInfo.TypeName = tbTypeName.Text;
}
DataProvider.GovInteractTypeDao.Update(typeInfo);
Body.AddSiteLog(PublishmentSystemId, "修改办件类型", $"办件类型:{typeInfo.TypeName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "办件类型修改失败！");
}
}
else
{
var typeNameArrayList = DataProvider.GovInteractTypeDao.GetTypeNameArrayList(_nodeId);
if (typeNameArrayList.IndexOf(tbTypeName.Text) != -1)
{
FailMessage("办件类型添加失败，办件类型名称已存在！");
}
else
{
try
{
typeInfo = new GovInteractTypeInfo(0, tbTypeName.Text, _nodeId, PublishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
Body.AddSiteLog(PublishmentSystemId, "添加办件类型", $"办件类型:{typeInfo.TypeName}");
isChanged = true;
}
catch (Exception ex)
{
FailMessage(ex, "办件类型添加失败！");
}
}
}
if (isChanged)
{
PageUtils.CloseModalPageAndRedirect(Page, PageGovInteractType.GetRedirectUrl(PublishmentSystemId, _nodeId));
}
}
public void Update(GovInteractTypeInfo typeInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmInteractName, EDataType.NVarChar, 50, typeInfo.TypeName),
GetParameter(ParmTypeId, EDataType.Integer, typeInfo.TypeID),
};
ExecuteNonQuery(SqlUpdate, parms);
}
public void Insert(GovInteractTypeInfo typeInfo)
{
var sqlString = "INSERT INTO wcm_GovInteractType (TypeName, NodeID, PublishmentSystemID, Taxis) VALUES (@TypeName, @NodeID, @PublishmentSystemID, @Taxis)";
var taxis = GetMaxTaxis(typeInfo.NodeID) + 1;
var parms = new IDataParameter[]
{
GetParameter(ParmInteractName, EDataType.NVarChar, 50, typeInfo.TypeName),
GetParameter(ParmNodeId, EDataType.Integer, typeInfo.NodeID),
GetParameter(ParmPublishmentsystemid, EDataType.Integer, typeInfo.PublishmentSystemID),
GetParameter(ParmTaxis, EDataType.Integer, taxis)
};
ExecuteNonQuery(sqlString, parms);
}
public static void AddDefaultTypeInfos(int publishmentSystemId, int nodeId)
{
var typeInfo = new GovInteractTypeInfo(0, "求决", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "举报", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "投诉", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "咨询", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "建议", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "感谢", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
typeInfo = new GovInteractTypeInfo(0, "其他", nodeId, publishmentSystemId, 0);
DataProvider.GovInteractTypeDao.Insert(typeInfo);
}
public GovInteractTypeInfo GetTypeInfo(int typeId)
{
GovInteractTypeInfo typeInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmTypeId, EDataType.Integer, typeId)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
var i = 0;
typeInfo = new GovInteractTypeInfo(GetInt(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i));
}
rdr.Close();
}
return(typeInfo);
}
public ArrayList GetTypeInfoArrayList(int nodeId)
{
var arraylist = new ArrayList();
var parms = new IDataParameter[]
{
GetParameter(ParmNodeId, EDataType.Integer, nodeId)
};
using (var rdr = ExecuteReader(SqlSelectAll, parms))
{
while (rdr.Read())
{
var i = 0;
var typeInfo = new GovInteractTypeInfo(GetInt(rdr, i++), GetString(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i++), GetInt(rdr, i));
arraylist.Add(typeInfo);
}
rdr.Close();
}
return(arraylist);
}
