You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
193 lines
9.7 KiB
Plaintext
193 lines
9.7 KiB
Plaintext
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_NOCARD', '无卡', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_BADCARD', '坏卡', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_LOSTCARD', '丢卡', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_BALCK', '黑名单', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_OBUBADCARD', 'OBU/ETC坏卡', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_ETCBADCARD', 'OBU坏卡操作', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPFLAG_OBUBADETCOP', 'OBU坏卡ETC卡操作', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPKIND_NOCARD', '纸券', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_NOCARD', '手动抬杆', 1, 6,29);
|
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_TAC', '重取TAC码', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_HANDLEDOWN', '使用手动落杆', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_MORECARD', '多卡班长认证', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_CANCECOIL', '取消线圈控制发收卡', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_CLEARWEIGHT', '清除一条计重积压数据', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_EDITAXSI', '轴数修改', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_AXSIWEIGHT', '班长刷卡-输入轴数、重量', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_SUSP', '可疑车辆-发卡/收费班长确认', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_CLMORETIME', '取消超时停留', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_BIGCAR', '大件车班长确认', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_EMERCAR', '抢险救灾车班长确认', 1, 6,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_OPTYPE_MINFEE', '班长确认最短路径', 1, 6,29);
|
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_EVENT_REMARK', '特殊操作-备注信息', 1, 1,29);
|
|
|
|
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_GREEN_DEPART', '绿通记录-车主所在单位', 1, 1,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_GREEN_GOODS', '绿通记录-货物种类', 1, 1,29);
|
|
INSERT INTO M_CODE([TYPENAME], [EXPLAIN], [EDITFLAY], [FLAG],[SUBCOMNO]) VALUES ('M_GREEN_REMARK', '绿通记录-备注信息', 1, 1,29);
|
|
|
|
|
|
update CMS_PRMIS_TABLE set PRMISURL='BaseMg/M_DC_DutyRecordMg.aspx' where PRMISID=2031
|
|
insert into CMS_PRMIS_TABLE values(2047,'特殊操作管理',2000,'PortMg/EventOpMg.aspx',2040,3,7,null,null,null,null,null);
|
|
insert into CMS_PRMIS_TABLE values(2048,'绿通信息管理',2000,'PortMg/M_DC_GreenRecordMg.aspx',2040,3,7,null,null,null,null,null);
|
|
|
|
|
|
//点击列排序
|
|
function LoadContextMenu(e, type) {
|
|
Ext.net.DirectMethods.ShowContentLog(type);
|
|
menuLog.showAt(e.getXY());
|
|
}
|
|
|
|
<style type="text/css">
|
|
.lbcolor {
|
|
color: red;
|
|
}
|
|
</style>
|
|
|
|
<ext:Store ID="stContentLog" runat="server" AutoDataBind="true">
|
|
<Reader>
|
|
<ext:JsonReader>
|
|
<Fields>
|
|
<ext:RecordField Name="DT" Type="Date"></ext:RecordField>
|
|
<ext:RecordField Name="OPMAN"></ext:RecordField>
|
|
<ext:RecordField Name="DIS"></ext:RecordField>
|
|
</Fields>
|
|
</ext:JsonReader>
|
|
</Reader>
|
|
</ext:Store>
|
|
|
|
<ext:Store ID="stNewLine" runat="server">
|
|
<Reader>
|
|
<ext:JsonReader>
|
|
<Fields>
|
|
<ext:RecordField Name="ID">
|
|
</ext:RecordField>
|
|
<ext:RecordField Name="TEXT">
|
|
</ext:RecordField>
|
|
</Fields>
|
|
</ext:JsonReader>
|
|
</Reader>
|
|
</ext:Store>
|
|
|
|
|
|
<ext:Label runat="server" Text="-----------异常清况------------" CtCls="lbcolor"></ext:Label>
|
|
<ext:ComboBox runat="server" ID="cmbExpInfoSelect" FieldLabel="新记录" StoreID="stNewLine" DisplayField="TEXT" ValueField="ID" AnchorHorizontal="98%">
|
|
<DirectEvents>
|
|
<Select OnEvent="cmbExpInfoSelect_Select"></Select>
|
|
</DirectEvents>
|
|
</ext:ComboBox>
|
|
<ext:LinkButton FieldLabel="-" runat="server" Text="历史记录">
|
|
<Listeners>
|
|
<Click Handler="LoadContextMenu(e,7);" />
|
|
</Listeners>
|
|
</ext:LinkButton>
|
|
|
|
|
|
|
|
|
|
<ext:Menu ID="menuLog" runat="server" AutoWidth="true">
|
|
<Items>
|
|
<ext:Panel runat="server" Layout="FormLayout" Height="250" Width="560" AutoScroll="true" Border="false">
|
|
<Items>
|
|
<ext:GridPanel Title="" runat="server" Layout="FormLayout" Width="600" StoreID="stContentLog" AutoExpandColumn="DIS" AutoHeight="true" ColumnLines="true">
|
|
<ColumnModel>
|
|
<Columns>
|
|
<ext:DateColumn DataIndex="DT" ColumnID="DT" Header="时间" Format="yyyy-MM-dd HH:mm:ss" Width="120" Hidden="true" Align="Center"></ext:DateColumn>
|
|
<ext:Column DataIndex="OPMAN" ColumnID="OPMAN" Header="人员" Width="60" Align="Center"></ext:Column>
|
|
<ext:Column DataIndex="DIS" ColumnID="DIS" Width="420" Header="内容" Resizable="true" Groupable="true">
|
|
<Editor>
|
|
<ext:TextField runat="server"></ext:TextField>
|
|
</Editor>
|
|
</ext:Column>
|
|
</Columns>
|
|
</ColumnModel>
|
|
<SelectionModel>
|
|
<ext:RowSelectionModel runat="server" SingleSelect="true"></ext:RowSelectionModel>
|
|
</SelectionModel>
|
|
</ext:GridPanel>
|
|
</Items>
|
|
</ext:Panel>
|
|
</Items>
|
|
</ext:Menu>
|
|
|
|
<ext:Hidden runat="server" ID="hdInAimLog"></ext:Hidden>
|
|
<ext:Hidden runat="server" ID="hdOpInfoLog"></ext:Hidden>
|
|
|
|
|
|
|
|
|
|
CommonHelper.CreateContentJson(hdOldDutyYlLog.Value.ToString(), txtOldDutyYl.Text.Trim(), hdUserId.Value.ToString(), hdMan.Value.ToString());
|
|
|
|
|
|
public void BindNewLine()
|
|
{
|
|
DataTable dt = new DataTable();
|
|
dt.Columns.Add("VALUE", typeof(string));
|
|
dt.Columns.Add("TEXT", typeof(string));
|
|
|
|
DataRow dr = dt.NewRow();
|
|
dr["VALUE"] = "&";
|
|
dr["TEXT"] = "新内容";
|
|
dt.Rows.Add(dr);
|
|
//stNewLine.DataSource = codbll.GetCodDicList(" TYPENAME='MC_NEWLINE'");
|
|
stNewLine.DataSource = dt;
|
|
stNewLine.DataBind();
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
/// <param name="sender"></param>
|
|
/// <param name="e"></param>
|
|
protected void cmbExpInfoSelect_Select(object sender, Ext.Net.DirectEventArgs e)
|
|
{
|
|
if (string.IsNullOrEmpty(txtExcInfo.Text))
|
|
{
|
|
txtExcInfo.Text += "\r\n&" + DateTime.Now.ToString("HH:mm:ss") + "\t";
|
|
}
|
|
else
|
|
{
|
|
txtExcInfo.Text += "\r\n&" + DateTime.Now.ToString("HH:mm:ss") + "\t";
|
|
}
|
|
}
|
|
|
|
|
|
#region 痕记录
|
|
/// <summary>
|
|
/// 输入框
|
|
/// </summary>
|
|
/// <param name="type"></param>
|
|
[DirectMethod]
|
|
public void ShowContentLog(string type)
|
|
{
|
|
DataTable dt = new DataTable();
|
|
try
|
|
{
|
|
switch (type)
|
|
{
|
|
case "1":
|
|
if (hdBadInfoLog.Value != null && !string.IsNullOrEmpty(hdBadInfoLog.Value.ToString()))
|
|
{
|
|
dt = CommonHelper.JXContentJson(hdBadInfoLog.Value.ToString());
|
|
}
|
|
break;
|
|
case "2":
|
|
if (hdExpInfoLog.Value != null && !string.IsNullOrEmpty(hdExpInfoLog.Value.ToString()))
|
|
{
|
|
dt = CommonHelper.JXContentJson(hdExpInfoLog.Value.ToString());
|
|
}
|
|
break;
|
|
}
|
|
}
|
|
catch
|
|
{
|
|
dt = new DataTable();
|
|
}
|
|
stContentLog.DataSource = dt;
|
|
stContentLog.DataBind();
|
|
}
|
|
#endregion 痕记录
|