/// <summary>
/// 添加用户皮肤
/// </summary>
/// <param name="memberId">创建者编号</param>
/// <param name="userType">用户类型</param>
/// <param name="personalityPicture">个性图片</param>
/// <param name="personalityBackgroundPicture">个性背景图片</param>
/// <returns></returns>
public static MemberSkin AddMemberSkin(
String memberId,
Comm.UserType userType,
String personalityPicture,
String personalityBackgroundPicture)
{
//创建用户皮肤
MemberSkin obj = CreateMemberSkin(memberId, userType, personalityPicture, personalityBackgroundPicture);
if (obj.ID != "")
{
////增加动态
//BiZ.Member.Activity.ActivityController.AddActivity(
// memberId,
// BiZ.Member.Activity.ActivityType.AddInterest,
// BiZ.Member.Activity.ActivityController.GetActivityContent_AddInterest_Title(),
// BiZ.Member.Activity.ActivityController.GetActivityContent_AddInterest(obj.ID, title, content, iconpath),
// false);
return obj;
}
else
{
//保存兴趣错误
return null;
}
}
public SVWSTC(Comm.Protocol protocol,string ip,int port)
{
this.protocol = protocol;
new System.Threading.Thread(Communication_Task).Start();
this.ip = ip;
this.port = port;
}
void MFCC_AVI_OnTCReport(object tc, Comm.TextPackage txt)
{
if (txt.Text[0] == 0x4f && txt.Text[1] == 0x04) //avi 主動回報
{
int day, hour, min, sec;
day = txt.Text[6];
hour = txt.Text[7];
min=txt.Text[8];
sec = txt.Text[9];
// System.DateTime dt = new DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month, day, hour, min, sec);
System.DateTime dt = new DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month, System.DateTime.Now.Day, System.DateTime.Now.Hour, System.DateTime.Now.Minute, System.DateTime.Now.Second);
// System.DateTime dt = new DateTime(System.DateTime.Now.Year, System.DateTime.Now.Month,day, hour, min, sec);
byte[] plate = new byte[6];
System.Array.Copy(txt.Text, 10, plate,0 , 6);
string plateStr =System.Text.UnicodeEncoding.Unicode.GetString( System.Text.Encoding.Convert(System.Text.Encoding.ASCII, System.Text.Encoding.Unicode, plate)).Trim();
ConsoleServer.WriteLine(((Comm.TCBase)tc).DeviceName + "," + dt + "," + plateStr);
string sql = string.Format("insert into tblAviData1Min (devicename,timestamp,vehicle_plate) values('{0}','{1}','{2}')",
((Comm.TCBase)tc).DeviceName, Comm.DB2.Db2.getTimeStampString(dt), plateStr);
this.dbServer.SendSqlCmd(sql);
try
{
//if (!isInRobj)
//{
if(this.r_host_comm!=null)
this.r_host_comm.AddAviData(new RemoteInterface.MFCC.AVIPlateData(((Comm.TCBase)tc).DeviceName, dt, plateStr));
//}
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
// finally
}
else if (txt.Text[0] == 0x4f && txt.Text[1] == 0x00)
{
try
{
ConsoleServer.WriteLine(((Comm.TCBase)tc).DeviceName + ",總流量接收!");
System.Data.DataSet ds = this.protocol.GetSendDsByTextPackage(txt,Comm.CmdType.CmdReport);
int day, hour, min,amount;
System.Data.DataRow r = ds.Tables[0].Rows[0];
day = System.Convert.ToInt32(r["day"]);
hour = System.Convert.ToInt32(r["hour"]);
min = System.Convert.ToInt32(r["minute"]);
amount = System.Convert.ToInt32(r["amount"]);
DateTime dt=new DateTime(DateTime.Now.Year,DateTime.Now.Month,day,hour,min,0);
string sql = string.Format("insert into tblAviRecognition (devicename,timestamp,volume) values('{0}','{1}',{2})",
((Comm.TCBase)tc).DeviceName, Comm.DB2.Db2.getTimeStampString(dt), amount);
this.dbServer.SendSqlCmd(sql);
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
}
public BluetoothConnect(ref Comm.BT.BTPort btport)
{
_btport = btport;
InitializeComponent();
#if DEBUG
txtBTAddress.Text = "0006660309E8";
#endif
}
void MFCC_WIS_OnTCReport(object tc, Comm.TextPackage txt)
{
// Comm.TCBase tcc = tc as Comm.TCBase;
//if (txt.Text[0] == 0x5f && txt.Text[1] = 0xda)
//{
//}
//throw new Exception("The method or operation is not implemented.");
}
public ImagePush(String ContentID, String MemberID, List<Content.Image> ImageList, String ImageContent, ImagePushCount ImagePushCount, DateTime CreatedTime, Comm.DeletedFlag DeleteFlag)
{
this.ContentID = ContentID;
this.MemberID = MemberID;
this.Creater = new BiZ.Creater.Creater(MemberID);
this.ImageList = ImageList;
this.ImageContent = ImageContent;
this.ImagePushCount = ImagePushCount;
this.CreatedTime = CreatedTime;
this.DeleteFlag = DeleteFlag;
}
public FeaturedContent(String image, String content, String creator, Comm.UsedFlag usedFlag)
{
this.CreatedTime = DateTime.Now;
this.Image = image;
this.Content = content;
if (creator != null && creator != "" && creator != "4eb0fde42101b0824e2b018f") //不等于管理员
this.Creator = new Creater.Creater(creator);
else
this.Creator = null;
this.UsedFlag = usedFlag;
}
public BluetoothConnect(ref Comm.BT.BTPort btport)
{
PriceMarkdown.ResClass2 _resClass = PriceMarkdown.ResClass2.getInstance();
_resClass.colorizeForm(this);
_btport = btport;
InitializeComponent();
#if DEBUG
txtBTAddress.Text = "000666025f1d";
#endif
}
public ICanBeenComment getICanBeenComment(Comm.ContentType name)
{
ICanBeenComment iCanBeenComment = null;
switch (name)
{
case Comm.ContentType.PublicContent: iCanBeenComment = new Content.PublicContent(); break;
case Comm.ContentType.InterView: iCanBeenComment = new InterView.InterView(); break;
default: break;
}
return iCanBeenComment;
}
void showLangSelect(ref SerialPort serConn, ref Comm.BT.BTPort btConn)
{
comport = serConn;
btport = btConn;
//if (bUseSocket)
// comport = null;
//else
// btport = null;
frmLanguage dlg = new frmLanguage(ref comport, ref btport);
dlg.ShowDialog();
dlg.Dispose();
}
void MFCC_SCM_OnTCReport(object tc, Comm.TextPackage txt)
{
//throw new Exception("The method or operation is not implemented.");
Comm.TCBase dev=(Comm.TCBase)tc;
if (txt.Text[0] == 0x86 || txt.Text[0] == 0xa7 || txt.Text[0] == 0xae || txt.Text[0] == 0xaf && txt.Text[1] == 0x01)
{
// ConsoleServer.WriteLine("In Rms Report:0x" + Util.ToHexString(txt.Text[0]));
System.Data.DataSet ds = this.protocol.GetSendDsByTextPackage(txt, Comm.CmdType.CmdReport);
ds.AcceptChanges();
this.notifier.NotifyAll(new NotifyEventObject(EventEnumType.MFCC_Report_Event,dev.DeviceName,ds));
}
}
void dledev_OnReport(object sender, Comm.TextPackage txtObj)
{
// throw new Exception("The method or operation is not implemented.");
try
{
if (txtObj.Text[0] == 0x10)
{
System.Data.DataSet ds = protocol.GetSendDsByTextPackage(txtObj, Comm.CmdType.CmdReport);
string mesg = "";
for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
{
mesg += ds.Tables[0].Columns[i].ColumnName + ":" + ds.Tables[0].Rows[0][ds.Tables[0].Columns[i].ColumnName].ToString() + "\t";
}
ConsoleServer.WriteLine(mesg);
SVWS_Status svws_status = new SVWS_Status(ds);
Program.mfcc_svws.stausmgr.AddSVWS_Status(svws_status);
}
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
if (txtObj.Text[0] == 0x11)
{
System.Data.DataSet ds = protocol.GetSendDsByTextPackage(txtObj, Comm.CmdType.CmdReport);
string mesg = "";
for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
{
mesg += ds.Tables[0].Columns[i].ColumnName + ":" + ds.Tables[0].Rows[0][ds.Tables[0].Columns[i].ColumnName].ToString() + "\t";
}
ConsoleServer.WriteLine(mesg);
SVWS_Status svws_status = new SVWS_Status(ds);
Program.mfcc_svws.stausmgr.AddSVWS_Status(svws_status);
}
else
if (txtObj.Text[0] == 0x12)
{
lock (dledev.GetStream())
{
byte[] data = dledev.PackData(0xffff, new byte[]{0x12,(byte)(DateTime.Now.Year%100),(byte)DateTime.Now.Month,(byte) DateTime.Now.Day,
(byte) DateTime.Now.Hour, (byte) DateTime.Now.Minute, (byte) DateTime.Now.Second}, (byte)txtObj.Seq);
dledev.GetStream().Write(data, 0, data.Length);
}
}
}
public InvitationCode(int inviteCode, String usedMember, String generatedMember, string generatedMemberId, Comm.UsedFlag usedFlag)
{
this.CreatedTime = DateTime.Now;
this.InviteCode = inviteCode;
if (usedMember != null && usedMember != "")
this.UsedMember = new Creater.Creater(usedMember);
else
this.UsedMember = null;
if (generatedMember != null && generatedMember != "" && generatedMember != "4eb0fde42101b0824e2b018f") //不等于管理员
this.GeneratedMember = new Creater.Creater(generatedMember);
else
this.GeneratedMember = null;
this.GeneratedMemberId = generatedMemberId;
this.UsedFlag = usedFlag;
}
/// <summary>
/// 返回所有回复的集合的数量
/// </summary>
/// <param name="deleteFlag">删除状态</param>
/// <returns>回复集合的数量</returns>
public static long findAllCount(Comm.DeletedFlag deleteFlag)
{
try
{
QueryComplete qc = Query.EQ("DeleteFlag", deleteFlag);
return MongoDBHelper.GetCount(Comment.GetCollectionName(), qc);
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// 添加一条精选内容
/// </summary>
/// <param name="featuredContentId">精选内容编号</param>
/// <param name="usedFlag">使用标记</param>
/// <returns>精选内容对象</returns>
public static CBB.ExceptionHelper.OperationResult AddFeaturedContent(String image, String content, String creator, Comm.UsedFlag usedFlag)
{
try
{
CBB.ExceptionHelper.OperationResult result = null;
FeaturedContent featContent = new FeaturedContent(image, content, creator, usedFlag);
result = Add(featContent);
return result;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// 按回复对象编号返回回复集合
/// </summary>
/// <param name="contentID">回复对象编号</param>
/// <param name="deleteFlag">删除状态</param>
/// <param name="pageno">当前页数</param>
/// <param name="pagesize">每页条数</param>
/// <returns>回复集合</returns>
public static IList<Comment> findForContent(String contentID, Comm.DeletedFlag deleteFlag, int pageno, int pagesize)
{
try
{
QueryComplete qc = Query.And(Query.EQ("CommentToID", contentID), Query.EQ("DeleteFlag", deleteFlag));
MongoCursor<Comment> mc = MongoDBHelper.GetCursor<Comment>(Comment.GetCollectionName(), qc, new SortByDocument("UpdateTime", -1), pageno, pagesize);
List<Comment> objs = new List<Comment>();
objs.AddRange(mc);
return objs;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// 返回所有的顶部图片推送集合
/// </summary>
/// <param name="deleteFlag">删除状态</param>
/// <param name="pageno">当前页数</param>
/// <param name="pagesize">每页条数</param>
/// <returns>顶部图片推送集合</returns>
public static List<ImagePush> findAll(Comm.DeletedFlag deleteFlag, int pageno, int pagesize)
{
try
{
QueryComplete qc = Query.EQ("DeleteFlag", deleteFlag);
MongoCursor<ImagePush> mc = MongoDBHelper.GetCursor<ImagePush>(ImagePush.GetCollectionName(), qc, new SortByDocument("UpdateTime", -1), pageno, pagesize);
List<ImagePush> objs = new List<ImagePush>();
objs.AddRange(mc);
return objs;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
public frmPrint(ref Comm.BT.BTPort btPort, ref System.IO.Ports.SerialPort serPort, int iLang)
{
InitializeComponent();
_iLang = iLang;
_btPort = btPort;
_serPort = serPort;
res = ResClass2.getInstance();
res.colorizeForm(this);
lblOldPrice.Text = res._labelsText(ResClass2.frmPrintText.oldPrice, iLang);
lblNewPrice.Text = res._labelsText(ResClass2.frmPrintText.newPrice, iLang);
btnPrint.Text = res._labelsText(ResClass2.frmPrintText.printButton, iLang);
varLabel = res._reducedText(iLang);// getVarLabel(iLang);
lblCurrencyOld.Text = ResClass2.sCurrency[iLang];
lblCurrencyNew.Text = ResClass2.sCurrency[iLang];
}
/// <summary>
/// Called every frame from Robot.update() if it's the current state (top of the stack)
/// </summary>
/// <param name="r">The robot to update</param>
public override void update(Robot r)
{
bool finished = false;
////////////////////////////////////////////////////////////////////////////////////////
// Initialize variables if necessary when first enter state
////////////////////////////////////////////////////////////////////////////////////////
if (!initialized)
{
initialized = true;
state = BuildState.WAITING_FOR_INITIALIZATION;
if (initialCommand.text.StartsWith(MessageBuildStart.TAG))
{
MessageBuildStart msgData;
if (MessageBuildStart.TryParse(initialCommand.text, out msgData))
{
waitQueue = msgData.waitQueue;
xMax = msgData.xMax;
xMin = msgData.xMin;
r.pushState(new RobotStateQueue(new Queue <Vector2>(waitQueue), 1.5f));
state = BuildState.QUEUING;
r.pushState(new RobotStateSleep(2 * r.id));
}
else
{
Log.a(LogTag.ROBOT, "Failed to parse " + MessageBuildStart.TAG + " data.");
finished = true;
}
}
else
{
Log.a(LogTag.ROBOT, "Failed to parse initial MessageBuildStart");
finished = true;
}
}
////////////////////////////////////////////////////////////////////////////////////////
// Reset variables if robot is returning from another state
////////////////////////////////////////////////////////////////////////////////////////
if (resume)
{
resume = false;
switch (state) // resuming from this state
{
case BuildState.QUEUING:
{
state = BuildState.FRONT_OF_QUEUE;
Comm.directMessage(r.id, Comm.SATELLITE, "build\nrequest_task");
break;
}
case BuildState.FINISHED:
{
finished = true;
break;
}
default:
{
break;
}
}
}
////////////////////////////////////////////////////////////////////////////////////////
// Update
////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////
// Process messages: TODO
////////////////////////////////////////////////////////////////////////////////////////
int count = r.unhandledMessages.Count;
for (int i = 0; i < count; ++i)
{
bool handledMessage = false;
CommMessage msg = r.unhandledMessages.Dequeue();
// TODO: this if-block is more repugnant than someone kicking a puppy
if (msg.text.StartsWith("build"))
{
handledMessage = true;
if (msg.text.StartsWith(MessageBuildStart.TAG))
{
MessageBuildStart msgData;
if (MessageBuildStart.TryParse(msg.text, out msgData))
{
if (state == BuildState.WAITING_FOR_INITIALIZATION)
{
waitQueue = msgData.waitQueue;
xMax = msgData.xMax;
xMin = msgData.xMin;
r.pushState(new RobotStateQueue(new Queue <Vector2>(waitQueue), 1.5f));
state = BuildState.QUEUING;
r.pushState(new RobotStateSleep(2 * r.id));
}
else
{
Log.e(LogTag.ROBOT, "Received " + MessageBuildStart.TAG + " message outside of WAITING_FOR_INITIALIZATION state");
}
}
else
{
Log.a(LogTag.ROBOT, "Failed to parse " + MessageBuildStart.TAG + " data.");
}
}
else if (msg.text.StartsWith(MessageBuildTask.TAG))
{
MessageBuildTask msgData;
if (MessageBuildTask.TryParse(msg.text, out msgData))
{
if (state == BuildState.FRONT_OF_QUEUE)
{
perimeterMax = new Vector2(xMax.x, msgData.resourcePlacement.y - 4);
perimeterMin = new Vector2(xMin.x, msgData.resourcePlacement.y - 4);
perimeterBreak = new Vector2(msgData.resourcePlacement.x, perimeterMax.y);
Queue <Vector2> placementToEndPerimeter = new Queue <Vector2>();
placementToEndPerimeter.Enqueue(perimeterBreak);
placementToEndPerimeter.Enqueue(perimeterMin);
Queue <Vector2> startToPlacementPerimeter = new Queue <Vector2>();
startToPlacementPerimeter.Enqueue(perimeterMax);
startToPlacementPerimeter.Enqueue(perimeterBreak);
if (msgData.lastTask)
{
r.pushState(new RobotStateMove(new Vector2(r.id * -1.5f, 31)));
state = BuildState.FINISHED;
}
else
{
r.pushState(new RobotStateQueue(new Queue <Vector2>(waitQueue), 2f));
state = BuildState.QUEUING;
}
r.pushState(new RobotStateMove(xMin));
r.pushState(new RobotStateQueue(placementToEndPerimeter, 2f, 0.1f));
r.pushState(new RobotStatePlaceResource(msgData.resourcePlacement));
r.pushState(new RobotStateQueue(startToPlacementPerimeter, 2f, 0.1f));
r.pushState(new RobotStateSendMessage("build\nleft_cache", Comm.SATELLITE));
r.pushState(new RobotStateMove(xMax));
r.pushState(new RobotStateRetrieveResource(msgData.resourceOrigin));
}
else
{
Log.e(LogTag.ROBOT, "Received " + MessageConstructionTask.TAG + " message outside of FRONT_OF_QUEUE state");
}
}
else
{
Log.a(LogTag.ROBOT, "Failed to parse " + MessageConstructionTask.TAG + " data.");
}
}
else if (msg.text == "build/finished")
{
r.pushState(new RobotStateMove(new Vector2(r.id * -1.5f, 31)));
state = BuildState.FINISHED;
}
else
{
Log.a(LogTag.ROBOT, "Unknown build message:\n" + msg.text);
}
}
if (!handledMessage) // didn't process message, leave for next state
{
r.unhandledMessages.Enqueue(msg);
}
}
////////////////////////////////////////////////////////////////////////////////////////
// "Clean up" robot state
////////////////////////////////////////////////////////////////////////////////////////
if (finished)
{
Log.d(LogTag.ROBOT, "Robot " + r.id + " has finished build (satellite).");
// Pop state off the stack
r.popState();
}
}
private string VD20SecToCsvStr(string devName, Comm.TC.VD_MinAvgData data)
{
// RemoteInterface.MFCC.VD1MinCycleEventData Vd1Min = (RemoteInterface.MFCC.VD1MinCycleEventData)objEvent.EventObj;
System.Data.DataSet ds = data.orgds;
ds.AcceptChanges();
String type = ds.Tables[0].Rows[0]["response_type"].ToString().Trim().ToUpper();
String response_type = String.Empty;
if (type == "0")
response_type = "1";
else
response_type = "0";
//string TIMESTAMP = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" +
// ((ds.Tables[0].Rows[0]["day"].ToString().Length == 2) ? ds.Tables[0].Rows[0]["day"].ToString() : "0" + ds.Tables[0].Rows[0]["day"].ToString()) + " " +
// ((ds.Tables[0].Rows[0]["hour"].ToString().Length == 2) ? ds.Tables[0].Rows[0]["hour"].ToString() : "0" + ds.Tables[0].Rows[0]["hour"].ToString()) + ":" +
// ((ds.Tables[0].Rows[0]["minute"].ToString().Length == 2) ? ds.Tables[0].Rows[0]["minute"].ToString() : "0" + ds.Tables[0].Rows[0]["minute"].ToString()) + ":00";
string TIMESTAMP = "TIMESTAMP('"+Comm.DB2.Db2.getTimeStampString(data.dateTime)+"')";
int lane_count = data.orgVDLaneData.Length;// Convert.ToInt32(ds.Tables[0].Rows[0]["lane_count"]);
String[,] myString = new String[14,7];
for (int i = 0; i < lane_count; i++)
{
myString[0, i] = data.orgVDLaneData[i].small_car_volume.ToString(); // Convert.ToString(ds.Tables[1].Rows[i]["small_car_volume"]);
myString[1, i] = data.orgVDLaneData[i].big_car_volume .ToString() ; //Convert.ToString(ds.Tables[1].Rows[i]["big_car_volume"]);
myString[2, i] = data.orgVDLaneData[i].connect_car_volume.ToString();//Convert.ToString(ds.Tables[1].Rows[i]["connect_car_volume"]);
myString[3, i] = "-1";
myString[4, i] = data.orgVDLaneData[i].small_car_speed.ToString(); //Convert.ToString(ds.Tables[1].Rows[i]["small_car_speed"]);
myString[5, i] = data.orgVDLaneData[i].big_car_speed.ToString(); //Convert.ToString(ds.Tables[1].Rows[i]["big_car_speed"]);
myString[6, i] = data.orgVDLaneData[i].connect_car_speed.ToString();//Convert.ToString(ds.Tables[1].Rows[i]["connect_car_speed"]);
myString[7, i] = "-1";
myString[8, i] = data.orgVDLaneData[i].small_car_length.ToString(); // Convert.ToString(ds.Tables[1].Rows[i]["small_car_length"]);
myString[9, i] = data.orgVDLaneData[i].big_car_length.ToString(); //Convert.ToString(ds.Tables[1].Rows[i]["big_car_length"]);
myString[10, i] = data.orgVDLaneData[i].connect_car_length.ToString();// Convert.ToString(ds.Tables[1].Rows[i]["connect_car_length"]);
myString[11, i] = "-1";
myString[12, i] = data.orgVDLaneData[i].interval.ToString();//Convert.ToString(ds.Tables[1].Rows[i]["average_car_interval"]);
myString[13, i] = data.orgVDLaneData[i].occupancy.ToString();//Convert.ToString(ds.Tables[1].Rows[i]["average_occupancy"]);
}
String second20 = "";
second20 += "'"+devName + "'," + TIMESTAMP + ((data.IsValid)?",'V',":",'I'," )+ response_type + ",";
for(int i=0;i<14;i++)
for (int j = 0; j < 7; j++)
{
if (myString[i, j] != null)
second20 += myString[i, j] + ",";
else
second20 += "-1,";
}
second20 = second20.Substring(0, second20.Length - 1);
return second20;
}
public static IList<Comment> GetMemberNameContentIDComment(String contentID, String memberLable, Comm.DeletedFlag deleteFlag, int pageNo, int pageSize)
{
try
{
QueryComplete qc = null;
if (memberLable != "")
{
Regex regex;
regex = new Regex(memberLable, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
qc = Query.And(Query.EQ("CommentToID", contentID), Query.Matches("Content", regex), Query.EQ("DeleteFlag", deleteFlag));
}
else
{
qc = Query.And(Query.EQ("CommentToID", contentID), Query.EQ("DeleteFlag", deleteFlag));
}
MongoCursor<Comment> mc = MongoDBHelper.GetCursor<Comment>(
Comment.GetCollectionName(),
qc,
new SortByDocument("UpdateTime", -1),
pageNo,
pageSize);
List<Comment> objs = new List<Comment>();
objs.AddRange(mc);
return objs;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// Update the linkage status between the core systems and their data connections
/// </summary>
private void UpdateCommunicationsLinkages()
{
int EMSStatus = 0;
//First, go through all of our communications links, and show them.
bool AddedItems = false;
MM_Communication_Linkage[] Comms = new List <MM_Communication_Linkage>(Data_Integration.Communications.Values).ToArray();
foreach (MM_Communication_Linkage Comm in Comms)
{
if (Comm.CommStatus != null)
{
Comm.UpdateStatus(ref EMSStatus);
}
else
{
AddedItems = true;
ListViewGroup ThisGroup;
if (!Groups.TryGetValue(Comm.Group, out ThisGroup))
{
Groups.Add(Comm.Group, ThisGroup = lvComm.Groups.Add(Comm.Group, Comm.Group));
}
Comm.CommStatus = lvComm.Items.Add(Comm.Name);
Comm.CommStatus.Group = ThisGroup;
Comm.CommStatus.ToolTipText = Comm.SCADAName;
if (Comm.Name == "Overall")
{
Comm.CommStatus.Text = Comm.Group;
}
else if (Comm.Critical)
{
Comm.CommStatus.Font = new Font(Comm.CommStatus.Font, FontStyle.Bold | FontStyle.Underline);
Comm.CommStatus.Text = Comm.Name;
}
else
{
Comm.CommStatus.Text = Comm.Name;
}
Comm.CommStatus.ForeColor = Color.White;
}
}
CommStatus.SetEMSStatus(EMSStatus);
//Now, if we have new linkages, let's clear everything and redo.
if (AddedItems)
{
using (Graphics g = Graphics.FromHwnd(lvComm.Handle))
{
Size MaxSize = Size.Empty;
foreach (MM_Communication_Linkage Comm in Comms)
{
Size ThisSize = Size.Ceiling(g.MeasureString(Comm.CommStatus.Text, Comm.CommStatus.Font));
MaxSize.Width = Math.Max(MaxSize.Width, ThisSize.Width);
MaxSize.Height = Math.Max(MaxSize.Height, ThisSize.Height);
}
lvComm.TileSize = new Size(MaxSize.Width + 5, MaxSize.Height + 5);
}
}
this.lblServer.Text = "Server: " + MM_Server_Interface.ClientName;
}
void MFCC_VD_OnFiveMinAvgData(object vdtc, Comm.TC.VD_MinAvgData data)
{
try
{
if (r_host_comm == null)
return;
// lock(this.r_host_comm)
this.r_host_comm.setVDFiveMinData(data.devName, data.ToVD1MinCycleEventData());
}
catch (Exception ex)
{
ConsoleServer.WriteLine("HostException!"+ex.Message+ex.StackTrace);
}
}
public ActionResult Index(string userID, int cardID)
{
if (!db.Users.Any(s => s.Id == userID))
{
return(Json(Comm.ToJsonResult("UserNoFound", "用户不存在"), JsonRequestBehavior.AllowGet));
}
var card = db.Cards.FirstOrDefault(s => s.ID == cardID && s.Enable && s.EnterpriseID.HasValue);
if (card == null)
{
return(Json(Comm.ToJsonResult("CardNoFound", "卡片不存在或卡片不是企业"), JsonRequestBehavior.AllowGet));
}
var ent = db.Enterprises.FirstOrDefault(s => s.ID == card.EnterpriseID);
var models = db.HomePageModulars
.Where(s => s.EnterpriseID == card.EnterpriseID)
.OrderBy(s => s.Sort)
.ToList();
var modulars = models.Select(s =>
{
object item;
switch (s.Type)
{
default:
case HomePageModularType.Html:
item = new
{
Title = s.Title,
Content = s.Content,
Type = s.Type,
};
break;
case HomePageModularType.Banner:
case HomePageModularType.Images:
item = new
{
Title = s.Title,
Content = s.Content.SplitToArray <string>(),
Type = s.Type,
};
break;
case HomePageModularType.Contact:
item = new
{
Title = s.Title,
Content = new
{
Phone = ent.PhoneNumber,
Email = ent.Email,
Address = new
{
Name = $"{ent.Province}{ent.City}{ent.District}{ent.Address}",
Lat = ent.Lat,
Lng = ent.Lng
}
},
Type = s.Type
};
break;
}
return(item);
});
return(Json(Comm.ToJsonResult("Success", "成功", modulars), JsonRequestBehavior.AllowGet));
}
public ActionResult GetCardInfo(int?pCardID, string userID)
{
try
{
if (string.IsNullOrWhiteSpace(userID))
{
return(Json(Comm.ToJsonResult("Error", "UserID为空"), JsonRequestBehavior.AllowGet));
}
var query = (from c in db.CardPersonals
where c.Enable
select c);
if (pCardID.HasValue)
{
query = query.Where(s => s.ID == pCardID);
}
else
{
query = query.Where(s => s.UserID == userID);
}
var card = query.FirstOrDefault();
if (card == null)
{
var user = db.Users.FirstOrDefault(s => s.Id == userID);
if (user == null)
{
return(Json(Comm.ToJsonResult("UserNoFound", "用户不出在"), JsonRequestBehavior.AllowGet));
}
return(Json(Comm.ToJsonResult("PCardNoFound", "名片不存在", new
{
user.Avatar,
Name = user.NickName,
UserID = user.Id
}), JsonRequestBehavior.AllowGet));
}
pCardID = card.ID;
if (card.UserID != userID)
{
Bll.UserLogs.Add(new UserLog
{
UserID = userID,
RelationID = card.ID,
TargetUserID = card.UserID,
Type = Common.Enums.UserLogType.CardPersonalRead
});
}
db = new ApplicationDbContext();
card = db.CardPersonals.FirstOrDefault(s => s.ID == card.ID);
var vip = db.Vips.FirstOrDefault(s => s.CardID == pCardID);
var likeCount = db.UserLogs
.Count(s => s.Type == Common.Enums.UserLogType.CardPersonalLike &&
s.RelationID == pCardID);
var hadLike = db.UserLogs.Any(s => s.RelationID == pCardID &&
s.Type == Common.Enums.UserLogType.CardPersonalLike &&
s.UserID == userID);
//获取最近访问的12个人头像
var leastUsers = (from l in db.UserLogs
from u in db.Users
where l.Type == Common.Enums.UserLogType.CardPersonalRead &&
l.RelationID == card.ID &&
u.Id == l.UserID
select new
{
UserID = u.Id,
u.Avatar,
l.CreateDateTime
}).GroupBy(s => new { s.UserID, s.Avatar })
.Select(s => new
{
s.Key.UserID,
s.Key.Avatar,
CreateDateTime = s.Max(x => x.CreateDateTime)
})
.OrderByDescending(s => s.CreateDateTime)
.Take(12)
.ToList();
var notifyCount = db.WeChatMiniNotifyForms.Count(s => s.UserID == userID && s.EndDateTime > DateTime.Now);
var data = new
{
card.Name,
card.Avatar,
card.Position,
Phone = card.PhoneNumber,
card.Mobile,
card.Email,
card.WeChatCode,
card.Remark,
Video = Url.ContentNullEmpty(card.Video),
card.Voice,
VideoThumbnail = string.IsNullOrWhiteSpace(card.Video) ? null : Comm.ResizeImage(card.Video),
card.Info,
card.Industry,
Images = card.Images.SplitToArray <string>() ?? new List <string>(),
PCardID = card.ID,
EnterpriseName = card.Enterprise,
card.Address,
card.City,
card.District,
card.Province,
FullAddress = $"{card.Province}{card.City}{card.District}{card.Address}",
Lat = card.Lat,
Lng = card.Lng,
Poster = Comm.ResizeImage(card.Poster),
WeChatMiniQrCode = Comm.ResizeImage(card.WeChatMiniQrCode),
Age = card.Birthday.GetAgeForBirthday(),
card.Gender,
Birthday = card.Birthday?.ToString("yyyy-MM-dd"),
Code = vip.Code,
Type = vip.Type,
Viewers = leastUsers.Select(s => s.Avatar).ToList(),
LikeCount = likeCount,
HadLike = hadLike,
NotifyCount = notifyCount,
ViewCount = card.View
};
return(Json(Comm.ToJsonResult("Success", "成功", data), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(Comm.ToJsonResult("Error", ex.Message), JsonRequestBehavior.AllowGet));
}
}
private KFB_BASEBALL GetKFB_BASEBALL(string s_aCBXH)
{
KFB_BASEBALL mo_KFB_BASEBALL = new KFB_BASEBALL();
mo_KFB_BASEBALL.N_RF_LOCK_V = 0;
mo_KFB_BASEBALL.N_RF_LOCK_H = 0;
mo_KFB_BASEBALL.N_DX_LOCK_V = 0;
mo_KFB_BASEBALL.N_DX_LOCK_H = 0;
mo_KFB_BASEBALL.N_DY_LOCK_V = 0;
mo_KFB_BASEBALL.N_DY_LOCK_H = 0;
mo_KFB_BASEBALL.N_SY_LOCK_V = 0;
mo_KFB_BASEBALL.N_SY_LOCK_H = 0;
mo_KFB_BASEBALL.N_DS_LOCK_V = 0;
mo_KFB_BASEBALL.N_DS_LOCK_H = 0;
mo_KFB_BASEBALL.N_VISIT_RESULT = 0;
mo_KFB_BASEBALL.N_HOME_RESULT = 0;
mo_KFB_BASEBALL.N_REMARK = "";
mo_KFB_BASEBALL.N_SF9J = 0; //0:打滿九局 1:未滿九局
mo_KFB_BASEBALL.N_SFDS = 0; //新比賽是否移至單式0:否 1:是
mo_KFB_BASEBALL.N_SFGP = 0; //0:不跟盤 1:跟盤
mo_KFB_BASEBALL.N_UP_VISIT_RESULT = 0; //上半場客隊結果比賽結果
mo_KFB_BASEBALL.N_UP_HOME_RESULT = 0; //上半場主隊結果比賽結果
mo_KFB_BASEBALL.N_SFXZ = 0; //會員是否下注,0:關閉會員下注 1:開放會員下注(走地) 2:開放會員下注(單式)
mo_KFB_BASEBALL.N_XZZT = 0; //0:移至未開賽(單式or走地) 1:移至已開賽
mo_KFB_BASEBALL.N_LOCK = 0; //0:不鎖定 1:強制鎖定
mo_KFB_BASEBALL.N_SAMETEAM = hidTeam.Value;
GameCalculationDB o_KFB_BASEBALL_BLL = new GameCalculationDB();
if (this.hidMode.Value.Equals("Modify"))
{
mo_KFB_BASEBALL = o_KFB_BASEBALL_BLL.GetModel(Convert.ToInt32(this.hidN_ID.Value));
}
if (!this.hidN_ID.Value.Equals("-1"))
{
mo_KFB_BASEBALL.N_ID = Convert.ToInt32(this.hidN_ID.Value);
}
else
{
mo_KFB_BASEBALL.N_ID = Convert.ToInt32(Comm.GetNO());
}
mo_KFB_BASEBALL.N_LX = ms_TYPE;
mo_KFB_BASEBALL.N_CBXH = Convert.ToInt32(s_aCBXH);
mo_KFB_BASEBALL.N_ZWDATE = Convert.ToDateTime(this.drpZWYear.Value + "/" + this.drpZWMonth.Value + "/" + this.drpZWDay.Value);
mo_KFB_BASEBALL.N_GAMEDATE = Convert.ToDateTime(this.drpBSYear.Value + "/" + this.drpBSMonth.Value + "/" + this.drpBSDay.Value).AddHours(double.Parse(this.drpBSHour.Value)).AddMinutes(double.Parse(this.drpBSMinute.Value));
mo_KFB_BASEBALL.N_LMNO = Convert.ToInt32(Request.Form["hidLM"]);
mo_KFB_BASEBALL.N_VISIT = Convert.ToInt32(Request.Form["hidVisit"]);
mo_KFB_BASEBALL.N_HOME = Convert.ToInt32(Request.Form["hidHome"]);
if (this.rdoVisit.Checked)
{
mo_KFB_BASEBALL.N_VH = mo_KFB_BASEBALL.N_VISIT;
}
else if (this.rdoHome.Checked)
{
mo_KFB_BASEBALL.N_VH = mo_KFB_BASEBALL.N_HOME;
}
else
{
mo_KFB_BASEBALL.N_VH = 0;
}
mo_KFB_BASEBALL.N_SFZD = Convert.ToInt32(this.rdoZD.SelectedValue);//0:不開走地 1:開走地 2:走地中
mo_KFB_BASEBALL.N_VISIT_NO = Convert.ToInt32(this.txtVisitNo.Text);
mo_KFB_BASEBALL.N_HOME_NO = Convert.ToInt32(this.txtHomeNo.Text);
mo_KFB_BASEBALL.N_TSA = this.txtVisitTSNo.Text;
mo_KFB_BASEBALL.N_TSB = this.txtHomeTSNo.Text;
mo_KFB_BASEBALL.N_VISIT_JZF = Convert.ToInt32(this.txtVisitJZF.Text);
mo_KFB_BASEBALL.N_HOME_JZF = Convert.ToInt32(this.txtHomeJZF.Text);
mo_KFB_BASEBALL.N_SFJZF = Convert.ToInt32(this.rdoOpenJZF.SelectedValue);
mo_KFB_BASEBALL.N_ZBXH = Convert.ToInt32(this.drpZBName.SelectedValue);
mo_KFB_BASEBALL.N_HYDZSX = Convert.ToDecimal(this.txtDZSX.Text);
mo_KFB_BASEBALL.N_HYDCSX = Convert.ToDecimal(this.txtDCSX.Text);
mo_KFB_BASEBALL.N_RFFS = Convert.ToDecimal(this.drpRFFS.Value);
mo_KFB_BASEBALL.N_RFLX = Convert.ToInt32(this.drpRFLX.Value);
mo_KFB_BASEBALL.N_RFBL = Convert.ToInt32(this.txtRFBL.Value);
mo_KFB_BASEBALL.N_LRFPL = Convert.ToDecimal(this.txtLRFPL.Value);
mo_KFB_BASEBALL.N_RRFPL = Convert.ToDecimal(this.txtRRFPL.Value);
mo_KFB_BASEBALL.N_LRFCJ = Convert.ToDecimal(this.drpLRFCJ.Value);
mo_KFB_BASEBALL.N_RRFCJ = Convert.ToDecimal(this.drpRRFCJ.Value);
mo_KFB_BASEBALL.N_LRFSX = Convert.ToDecimal(this.txtLRFSX.Value);
mo_KFB_BASEBALL.N_RRFSX = Convert.ToDecimal(this.txtRRFSX.Value);
mo_KFB_BASEBALL.N_RFCJJE = Convert.ToDecimal(this.txtRFCJJE.Value);
mo_KFB_BASEBALL.N_RFCJFS = Convert.ToInt32(this.drpRFCJFS.Value);
if (this.drpRFCJFS.Value.Equals("0"))
{
mo_KFB_BASEBALL.N_RFCJPL = Convert.ToDecimal(this.drpRFCJPL.Value);
}
else
{
mo_KFB_BASEBALL.N_RFCJPL = Convert.ToDecimal(this.drpRFCJPL1.Value);
}
mo_KFB_BASEBALL.N_DXFS = Convert.ToDecimal(this.drpDXFS.Value);
mo_KFB_BASEBALL.N_DXLX = Convert.ToInt32(this.drpDXLX.Value);
mo_KFB_BASEBALL.N_DXBL = Convert.ToInt32(this.txtDXBL.Value);
mo_KFB_BASEBALL.N_DXDPL = Convert.ToDecimal(this.txtDXDPL.Value);
mo_KFB_BASEBALL.N_DXXPL = Convert.ToDecimal(this.txtDXXPL.Value);
mo_KFB_BASEBALL.N_DXDCJ = Convert.ToDecimal(this.drpDXDCJ.Value);
mo_KFB_BASEBALL.N_DXXCJ = Convert.ToDecimal(this.drpDXXCJ.Value);
mo_KFB_BASEBALL.N_DXDCSX = 0;
mo_KFB_BASEBALL.N_LDXSX = Convert.ToDecimal(this.txtLDXSX.Value);
mo_KFB_BASEBALL.N_RDXSX = Convert.ToDecimal(this.txtRDXSX.Value);
mo_KFB_BASEBALL.N_DXCJ = Convert.ToDecimal(this.txtDXCJ.Value);
mo_KFB_BASEBALL.N_DXCJPL = Convert.ToDecimal(this.drpDXCJPL.Value);
if ((this.chkLet.Value.Equals("0") && this.chkLet.Checked) || (this.chkLet.Value.Equals("1") && !this.chkLet.Checked))
{
mo_KFB_BASEBALL.N_LDYPL = Convert.ToDecimal(this.txtRDYPL.Value);
mo_KFB_BASEBALL.N_RDYPL = Convert.ToDecimal(this.txtLDYPL.Value);
}
else
{
mo_KFB_BASEBALL.N_LDYPL = Convert.ToDecimal(this.txtLDYPL.Value);
mo_KFB_BASEBALL.N_RDYPL = Convert.ToDecimal(this.txtRDYPL.Value);
}
mo_KFB_BASEBALL.N_LDYCJ = Convert.ToDecimal(this.drpLDYCJ.Value);
mo_KFB_BASEBALL.N_RDYCJ = Convert.ToDecimal(this.drpRDYCJ.Value);
mo_KFB_BASEBALL.N_LDYSX = Convert.ToDecimal(this.txtLDYSX.Value);
mo_KFB_BASEBALL.N_RDYSX = Convert.ToDecimal(this.txtRDYSX.Value);
mo_KFB_BASEBALL.N_DYCJ = Convert.ToDecimal(this.txtDYCJ.Value);
mo_KFB_BASEBALL.N_DYCJPL = Convert.ToDecimal(this.drpDYCJPL.Value);
//if ((this.chkLet.Value.Equals("0") && this.chkLet.Checked) || (this.chkLet.Value.Equals("1") && !this.chkLet.Checked))
//{
// mo_KFB_BASEBALL.N_LSYPL = Convert.ToDecimal(this.txtRSYPL.Value);
// mo_KFB_BASEBALL.N_RSYPL = Convert.ToDecimal(this.txtLSYPL.Value);
//}
//else
//{
// mo_KFB_BASEBALL.N_LSYPL = Convert.ToDecimal(this.txtLSYPL.Value);
// mo_KFB_BASEBALL.N_RSYPL = Convert.ToDecimal(this.txtRSYPL.Value);
//}
//mo_KFB_BASEBALL.N_LSYCJ = Convert.ToDecimal(this.drpLSYCJ.Value);
//mo_KFB_BASEBALL.N_RSYCJ = Convert.ToDecimal(this.drpRSYCJ.Value);
//mo_KFB_BASEBALL.N_LSYSX = Convert.ToDecimal(this.txtLSYSX.Value);
//mo_KFB_BASEBALL.N_RSYSX = Convert.ToDecimal(this.txtRSYSX.Value);
//mo_KFB_BASEBALL.N_SYCJ = Convert.ToDecimal(this.txtSYCJ.Value);
//mo_KFB_BASEBALL.N_SYCJPL = Convert.ToDecimal(this.drpSYCJPL.Value);
mo_KFB_BASEBALL.N_LSYPL = 0;
mo_KFB_BASEBALL.N_RSYPL = 0;
mo_KFB_BASEBALL.N_LSYCJ = 0;
mo_KFB_BASEBALL.N_RSYCJ = 0;
mo_KFB_BASEBALL.N_LSYSX = 0;
mo_KFB_BASEBALL.N_RSYSX = 0;
mo_KFB_BASEBALL.N_SYCJ = 0;
mo_KFB_BASEBALL.N_SYCJPL = 0;
mo_KFB_BASEBALL.N_DSDPL = Convert.ToDecimal(this.txtDSDPL.Value);
mo_KFB_BASEBALL.N_DSSPL = Convert.ToDecimal(this.txtDSSPL.Value);
mo_KFB_BASEBALL.N_DSDCJ = Convert.ToDecimal(this.drpDSDCJ.Value);
mo_KFB_BASEBALL.N_DSSCJ = Convert.ToDecimal(this.drpDSSCJ.Value);
mo_KFB_BASEBALL.N_DSDCSX = 0;
mo_KFB_BASEBALL.N_LDSSX = Convert.ToDecimal(this.txtLDSSX.Value);
mo_KFB_BASEBALL.N_RDSSX = Convert.ToDecimal(this.txtRDSSX.Value);
mo_KFB_BASEBALL.N_DSCJ = Convert.ToDecimal(this.txtDSCJ.Value);
mo_KFB_BASEBALL.N_DSCJPL = Convert.ToDecimal(this.drpDSCJPL.Value);
mo_KFB_BASEBALL.N_LET = this.chkLet.Checked ? 1 : 0; //讓分互換
mo_KFB_BASEBALL.N_RF_OPEN = this.chkRFClose.Checked ? 1 : 0; //讓分關閉
mo_KFB_BASEBALL.N_DX_OPEN = this.chkDXClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_DY_OPEN = this.chkDYClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_SY_OPEN = 0;
mo_KFB_BASEBALL.N_DS_OPEN = this.chkDSClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_RQ_OPEN = this.chkRQClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_BD_OPEN = this.chkBDClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_BQC_OPEN = this.chkBQCClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_RF_GG = this.chkRFGGClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_DX_GG = this.chkDXGGClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_DY_GG = this.chkDYGGClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_SY_GG = 0;
mo_KFB_BASEBALL.N_DS_GG = this.chkDSGGClose.Checked ? 1 : 0;
mo_KFB_BASEBALL.N_BDGPL00 = Convert.ToDecimal(this.txt00.Text);
mo_KFB_BASEBALL.N_BDGPL11 = Convert.ToDecimal(this.txt11.Text);
mo_KFB_BASEBALL.N_BDGPL22 = Convert.ToDecimal(this.txt22.Text);
mo_KFB_BASEBALL.N_BDGPL33 = Convert.ToDecimal(this.txt33.Text);
mo_KFB_BASEBALL.N_BDGPL44 = Convert.ToDecimal(this.txt44.Text);
mo_KFB_BASEBALL.N_BDKPL10 = Convert.ToDecimal(this.txtkc10.Text);
mo_KFB_BASEBALL.N_BDKPL20 = Convert.ToDecimal(this.txtkc20.Text);
mo_KFB_BASEBALL.N_BDKPL21 = Convert.ToDecimal(this.txtkc21.Text);
mo_KFB_BASEBALL.N_BDKPL30 = Convert.ToDecimal(this.txtkc30.Text);
mo_KFB_BASEBALL.N_BDKPL31 = Convert.ToDecimal(this.txtkc31.Text);
mo_KFB_BASEBALL.N_BDKPL32 = Convert.ToDecimal(this.txtkc32.Text);
mo_KFB_BASEBALL.N_BDKPL40 = Convert.ToDecimal(this.txtkc40.Text);
mo_KFB_BASEBALL.N_BDKPL41 = Convert.ToDecimal(this.txtkc41.Text);
mo_KFB_BASEBALL.N_BDKPL42 = Convert.ToDecimal(this.txtkc42.Text);
mo_KFB_BASEBALL.N_BDKPL43 = Convert.ToDecimal(this.txtkc43.Text);
mo_KFB_BASEBALL.N_BDKPL5 = Convert.ToDecimal(this.txtkc5.Text);
mo_KFB_BASEBALL.N_BDZPL10 = Convert.ToDecimal(this.txtzc10.Text);
mo_KFB_BASEBALL.N_BDZPL20 = Convert.ToDecimal(this.txtzc20.Text);
mo_KFB_BASEBALL.N_BDZPL21 = Convert.ToDecimal(this.txtzc21.Text);
mo_KFB_BASEBALL.N_BDZPL30 = Convert.ToDecimal(this.txtzc30.Text);
mo_KFB_BASEBALL.N_BDZPL31 = Convert.ToDecimal(this.txtzc31.Text);
mo_KFB_BASEBALL.N_BDZPL32 = Convert.ToDecimal(this.txtzc32.Text);
mo_KFB_BASEBALL.N_BDZPL40 = Convert.ToDecimal(this.txtzc40.Text);
mo_KFB_BASEBALL.N_BDZPL41 = Convert.ToDecimal(this.txtzc41.Text);
mo_KFB_BASEBALL.N_BDZPL42 = Convert.ToDecimal(this.txtzc42.Text);
mo_KFB_BASEBALL.N_BDZPL43 = Convert.ToDecimal(this.txtzc43.Text);
mo_KFB_BASEBALL.N_BDZPL5 = Convert.ToDecimal(this.txtzc5.Text);
mo_KFB_BASEBALL.N_BDSX = Convert.ToDecimal(this.txtbdsx.Text);
mo_KFB_BASEBALL.N_BQCHH = Convert.ToDecimal(this.txtbqchh.Text);
mo_KFB_BASEBALL.N_BQCHK = Convert.ToDecimal(this.txtbqchk.Text);
mo_KFB_BASEBALL.N_BQCHZ = Convert.ToDecimal(this.txtbqchz.Text);
mo_KFB_BASEBALL.N_BQCKH = Convert.ToDecimal(this.txtbqckh.Text);
mo_KFB_BASEBALL.N_BQCKK = Convert.ToDecimal(this.txtbqckk.Text);
mo_KFB_BASEBALL.N_BQCKZ = Convert.ToDecimal(this.txtbqckz.Text);
mo_KFB_BASEBALL.N_BQCZH = Convert.ToDecimal(this.txtbqczh.Text);
mo_KFB_BASEBALL.N_BQCZK = Convert.ToDecimal(this.txtbqczk.Text);
mo_KFB_BASEBALL.N_BQCZZ = Convert.ToDecimal(this.txtbqczz.Text);
mo_KFB_BASEBALL.N_BQCSX = Convert.ToDecimal(this.txtbqcsx.Text);
mo_KFB_BASEBALL.N_RQSPL01 = Convert.ToDecimal(this.txtrqs01.Text);
mo_KFB_BASEBALL.N_RQSPL23 = Convert.ToDecimal(this.txtrqs23.Text);
mo_KFB_BASEBALL.N_RQSPL46 = Convert.ToDecimal(this.txtrqs46.Text);
mo_KFB_BASEBALL.N_RQSPL7 = Convert.ToDecimal(this.txtrqs7.Text);
mo_KFB_BASEBALL.N_RQSSX = Convert.ToDecimal(this.txtrqssx.Text);
mo_KFB_BASEBALL.N_HJPL = Convert.ToDecimal(this.txtN_HJPL.Value);
mo_KFB_BASEBALL.N_HJGGCJ = Convert.ToDecimal(this.drpN_HJGGCJ.Value);
mo_KFB_BASEBALL.N_HJSX = Convert.ToDecimal(this.txtN_HJSX.Value);
return(mo_KFB_BASEBALL);
}
//绑定当前资产－处置申报情况（包括处置方式）
private void BindData()
{
if (Request["id"] != null)
{
string id = Request["id"];
U_ZCBU zc1 = new U_ZCBU();
//////////////////////////////////////////
Hashtable ht = zc1.GetCurrentZcCZbyID(id);
if (ht.Count > 0)
{
this.danwei.Text = ht["danwei"].ToString();
if (ht["depart"] != null)
{
this.depart.Text = ht["depart"].ToString();
}
if (ht["zeren"] != null)
{
this.zeren.Text = ht["zeren"].ToString();
}
if (ht["zcstatus"] != null)
{
this.status.Text = ht["zcstatus"].ToString();
}
if (ht["statustext"] != null)
{
this.statusText.Text = ht["statustext"].ToString();
}
if (this.statusText.Text == "")
{
this.statusText.Text = "阅卷";
}
if (ht["xmsbh"] != null)
{
this.xmsbh.Text = ht["xmsbh"].ToString();
}
//根据权限显示信息
int status1 = 0;
if (this.status.Text != "")
{
status1 = Int32.Parse(this.status.Text);
}
string[] arr1 = new string[] { "zclx", "zcse", "xmbj", "fsxzly", "djyj", "zcczid" };
for (int i = 0; i < arr1.Length; i++)
{
if (ht[arr1[i]] != null)
{
Util.SetControlValue(this.zclx.Parent.FindControl(arr1[i]), ht[arr1[i]].ToString());
Util.SetControlValue(this.zclx.Parent.FindControl(arr1[i] + "_1"), Util.ChangeToShow(ht[arr1[i]].ToString()));
}
if (this.owner && status1 == (int)SP.开始审批)
{
this.zclx.Parent.FindControl(arr1[i] + "_1").Visible = false;
}
else
{
this.zclx.Parent.FindControl(arr1[i]).Visible = false;
}
if (Comm.IsRole("系统管理员"))
{
this.zclx.Parent.FindControl(arr1[i]).Visible = true;
this.zclx.Parent.FindControl(arr1[i] + "_1").Visible = false;
}
}
////////////////////////////////////////////
this.zclx.Parent.FindControl("zcczid").Visible = true;
this.BindZCCZDetail(zc1);
}
zc1.Close();
this.SetButton(); //设置按钮的权限
}
}
private void WriteParameterInfo(TdsMetaParameter param)
{
/*
* Ms.net send non-nullable datatypes as nullable and allows setting null values
* to int/float etc.. So, using Nullable form of type for all data
*/
param.IsNullable = true;
TdsColumnType colType = param.GetMetaType();
param.IsNullable = false;
bool partLenType = false;
int size = param.Size;
if (size < 1)
{
if (size < 0)
{
partLenType = true;
}
size = param.GetActualSize();
}
/*
* If the value is null, not setting the size to 0 will cause varchar
* fields to get inserted as an empty string rather than an null.
*/
if (param.Value == null || param.Value == DBNull.Value)
{
size = 0;
}
// Change colType according to the following table
/*
* Original Type Maxlen New Type
*
* NVarChar 4000 UCS2 NText
* BigVarChar 8000 ASCII Text
* BigVarBinary 8000 bytes Image
*
*/
TdsColumnType origColType = colType;
if (colType == TdsColumnType.BigNVarChar)
{
// param.GetActualSize() returns len*2
if (size == param.Size)
{
size <<= 1;
}
if ((size >> 1) > 4000)
{
colType = TdsColumnType.NText;
}
}
else if (colType == TdsColumnType.BigVarChar)
{
if (size > 8000)
{
colType = TdsColumnType.Text;
}
}
else if (colType == TdsColumnType.BigVarBinary)
{
if (size > 8000)
{
colType = TdsColumnType.Image;
}
}
// Calculation of TypeInfo field
/*
* orig size value TypeInfo field
*
* >= 0 <= Maxlen origColType + content len
* > Maxlen NewType as per above table + content len
* -1 origColType + USHORTMAXLEN (0xFFFF) + content len (TDS 9)
*
*/
// Write updated colType, iff partLenType == false
if (TdsVersion > TdsVersion.tds81 && partLenType)
{
Comm.Append((byte)origColType);
Comm.Append((short)-1);
}
else if (ServerTdsVersion > TdsVersion.tds70 &&
origColType == TdsColumnType.Decimal)
{
Comm.Append((byte)TdsColumnType.Numeric);
}
else
{
Comm.Append((byte)colType);
}
if (IsLargeType(colType))
{
Comm.Append((short)size); // Parameter size passed in SqlParameter
}
else if (IsBlobType(colType))
{
Comm.Append(size); // Parameter size passed in SqlParameter
}
else
{
Comm.Append((byte)size);
}
// Precision and Scale are non-zero for only decimal/numeric
if (param.TypeName == "decimal" || param.TypeName == "numeric")
{
Comm.Append((param.Precision != 0) ? param.Precision : Precision);
Comm.Append(param.Scale);
// Convert the decimal value according to Scale
if (param.Value != null && param.Value != DBNull.Value &&
((decimal)param.Value) != Decimal.MaxValue &&
((decimal)param.Value) != Decimal.MinValue &&
((decimal)param.Value) != long.MaxValue &&
((decimal)param.Value) != long.MinValue &&
((decimal)param.Value) != ulong.MaxValue &&
((decimal)param.Value) != ulong.MinValue)
{
long expo = (long)new Decimal(System.Math.Pow(10, (double)param.Scale));
long pVal = (long)(((decimal)param.Value) * expo);
param.Value = pVal;
}
}
/* VARADHAN: TDS 8 Debugging */
/*
* if (Collation != null) {
* Console.WriteLine ("Collation is not null");
* Console.WriteLine ("Column Type: {0}", colType);
* Console.WriteLine ("Collation bytes: {0} {1} {2} {3} {4}", Collation[0], Collation[1], Collation[2],
* Collation[3], Collation[4]);
* } else {
* Console.WriteLine ("Collation is null");
* }
*/
// Tds > 7.0 uses collation
if (Collation != null &&
(colType == TdsColumnType.BigChar || colType == TdsColumnType.BigNVarChar ||
colType == TdsColumnType.BigVarChar || colType == TdsColumnType.NChar ||
colType == TdsColumnType.NVarChar || colType == TdsColumnType.Text ||
colType == TdsColumnType.NText))
{
Comm.Append(Collation);
}
// LAMESPEC: size should be 0xFFFF for any bigvarchar, bignvarchar and bigvarbinary
// types if param value is NULL
if ((colType == TdsColumnType.BigVarChar ||
colType == TdsColumnType.BigNVarChar ||
colType == TdsColumnType.BigVarBinary ||
colType == TdsColumnType.Image) &&
(param.Value == null || param.Value == DBNull.Value))
{
size = -1;
}
else
{
size = param.GetActualSize();
}
if (IsLargeType(colType))
{
Comm.Append((short)size);
}
else if (IsBlobType(colType))
{
Comm.Append(size);
}
else
{
Comm.Append((byte)size);
}
if (size > 0)
{
switch (param.TypeName)
{
case "money": {
// 4 == SqlMoney::MoneyFormat.NumberDecimalDigits
Decimal val = Decimal.Round((decimal)param.Value, 4);
int[] arr = Decimal.GetBits(val);
if (val >= 0)
{
Comm.Append(arr[1]);
Comm.Append(arr[0]);
}
else
{
Comm.Append(~arr[1]);
Comm.Append(~arr[0] + 1);
}
break;
}
case "smallmoney": {
// 4 == SqlMoney::MoneyFormat.NumberDecimalDigits
Decimal val = Decimal.Round((decimal)param.Value, 4);
if (val < SMALLMONEY_MIN || val > SMALLMONEY_MAX)
{
throw new OverflowException(string.Format(
CultureInfo.InvariantCulture,
"Value '{0}' is not valid for SmallMoney."
+ " Must be between {1:N4} and {2:N4}.",
#if NET_2_0
val,
#else
val.ToString(CultureInfo.CurrentCulture),
#endif
SMALLMONEY_MIN, SMALLMONEY_MAX));
}
int[] arr = Decimal.GetBits(val);
int sign = (val > 0 ? 1: -1);
Comm.Append(sign * arr[0]);
break;
}
case "datetime":
Comm.Append((DateTime)param.Value, 8);
break;
case "smalldatetime":
Comm.Append((DateTime)param.Value, 4);
break;
case "varchar":
case "nvarchar":
case "char":
case "nchar":
case "text":
case "ntext":
byte [] tmp = param.GetBytes();
Comm.Append(tmp);
break;
case "uniqueidentifier":
Comm.Append(((Guid)param.Value).ToByteArray());
break;
default:
Comm.Append(param.Value);
break;
}
}
return;
}
//删除邮件
protected void Button1_Click(object sender, EventArgs e)
{
ZX_Email1BU emal1 = new ZX_Email1BU();
string id = Request.QueryString["id"];
DataSet ds1 = emal1.GetSendMail(id);
string file1 = ds1.Tables[0].Rows[0]["file1"].ToString();
if (file1 != "" && file1 != null)
{
ZX_EmailBu email1 = new ZX_EmailBu();
bool Cunzai = email1.IfCzFile(file1, "1");
if (Cunzai == false)
{
File.Delete(Server.MapPath(Application["root"] + "/Common/MailFiles/" + file1));
}
email1.Dispose();
}
string file2 = ds1.Tables[0].Rows[0]["file2"].ToString();
if (file2 != "" && file2 != null)
{
ZX_EmailBu email2 = new ZX_EmailBu();
bool Cunzai2 = email2.IfCzFile(file2, "2");
if (Cunzai2 == false)
{
File.Delete(Server.MapPath(Application["root"] + "/Common/MailFiles/" + file2));
}
email2.Dispose();
}
string file3 = ds1.Tables[0].Rows[0]["file3"].ToString();
if (file3 != "" && file3 != null)
{
ZX_EmailBu email3 = new ZX_EmailBu();
bool Cunzai3 = email3.IfCzFile(file3, "3");
if (Cunzai3 == false)
{
File.Delete(Server.MapPath(Application["root"] + "/Common/MailFiles/" + file3));
}
email3.Dispose();
}
string file4 = ds1.Tables[0].Rows[0]["file4"].ToString();
if (file4 != "" && file4 != null)
{
ZX_EmailBu email4 = new ZX_EmailBu();
bool Cunzai4 = email4.IfCzFile(file4, "4");
if (Cunzai4 == false)
{
File.Delete(Server.MapPath(Application["root"] + "/Common/MailFiles/" + file4));
}
email4.Dispose();
}
string file5 = ds1.Tables[0].Rows[0]["file5"].ToString();
if (file5 != "" && file5 != null)
{
ZX_EmailBu email5 = new ZX_EmailBu();
bool Cunzai5 = email5.IfCzFile(file5, "5");
if (Cunzai5 == false)
{
File.Delete(Server.MapPath(Application["root"] + "/Common/MailFiles/" + file5));
}
email5.Dispose();
}
emal1.DelMail(id);
emal1.Close();
Comm.ShowInfo("操作提示：删除留言数据成功！", Application["root"] + "/info/SendMail.aspx");
}
public override bool Connect(TdsConnectionParameters connectionParameters)
{
if (IsConnected)
{
throw new InvalidOperationException("The connection is already open.");
}
connectionParms = connectionParameters;
SetLanguage(connectionParameters.Language);
SetCharset("utf-8");
byte[] empty = new byte[0];
short authLen = 0;
byte pad = (byte)0;
byte[] domainMagic = { 6, 0x7d, 0x0f, 0xfd, 0xff, 0x0, 0x0, 0x0,
0x0, 0xe0, 0x83, 0x0, 0x0,
0x68, 0x01, 0x00, 0x00, 0x09, 0x04, 0x00, 0x00 };
byte[] sqlserverMagic = { 6, 0x0, 0x0, 0x0,
0x0, 0x0, 0x0, 0x0,
0x0, 0xe0, 0x03, 0x0,
0x0, 0x0, 0x0, 0x0,0x0, 0x0,
0x0, 0x0, 0x0 };
byte[] magic = null;
if (connectionParameters.DomainLogin)
{
magic = domainMagic;
}
else
{
magic = sqlserverMagic;
}
string username = connectionParameters.User;
string domain = null;
int idx = username.IndexOf("\\");
if (idx != -1)
{
domain = username.Substring(0, idx);
username = username.Substring(idx + 1);
connectionParameters.DefaultDomain = domain;
connectionParameters.User = username;
}
else
{
domain = Environment.UserDomainName;
connectionParameters.DefaultDomain = domain;
}
short partialPacketSize = (short)(86 + (
connectionParameters.Hostname.Length +
connectionParameters.ApplicationName.Length +
DataSource.Length +
connectionParameters.LibraryName.Length +
Language.Length +
connectionParameters.Database.Length +
connectionParameters.AttachDBFileName.Length) * 2);
if (connectionParameters.DomainLogin)
{
authLen = ((short)(32 + (connectionParameters.Hostname.Length +
domain.Length)));
partialPacketSize += authLen;
}
else
{
partialPacketSize += ((short)((username.Length + connectionParameters.Password.Length) * 2));
}
int totalPacketSize = partialPacketSize;
Comm.StartPacket(TdsPacketType.Logon70);
Comm.Append(totalPacketSize);
//Comm.Append (empty, 3, pad);
//byte[] version = {0x00, 0x0, 0x0, 0x71};
//Console.WriteLine ("Version: {0}", ClientVersion[3]);
Comm.Append(ClientVersion); // TDS Version 7
Comm.Append((int)this.PacketSize); // Set the Block Size
Comm.Append(empty, 3, pad);
Comm.Append(magic);
short curPos = 86;
// Hostname
Comm.Append(curPos);
Comm.Append((short)connectionParameters.Hostname.Length);
curPos += (short)(connectionParameters.Hostname.Length * 2);
if (connectionParameters.DomainLogin)
{
Comm.Append((short)0);
Comm.Append((short)0);
Comm.Append((short)0);
Comm.Append((short)0);
}
else
{
// Username
Comm.Append(curPos);
Comm.Append((short)username.Length);
curPos += ((short)(username.Length * 2));
// Password
Comm.Append(curPos);
Comm.Append((short)connectionParameters.Password.Length);
curPos += (short)(connectionParameters.Password.Length * 2);
}
// AppName
Comm.Append(curPos);
Comm.Append((short)connectionParameters.ApplicationName.Length);
curPos += (short)(connectionParameters.ApplicationName.Length * 2);
// Server Name
Comm.Append(curPos);
Comm.Append((short)DataSource.Length);
curPos += (short)(DataSource.Length * 2);
// Unknown
Comm.Append((short)curPos);
Comm.Append((short)0);
// Library Name
Comm.Append(curPos);
Comm.Append((short)connectionParameters.LibraryName.Length);
curPos += (short)(connectionParameters.LibraryName.Length * 2);
// Language
Comm.Append(curPos);
Comm.Append((short)Language.Length);
curPos += (short)(Language.Length * 2);
// Database
Comm.Append(curPos);
Comm.Append((short)connectionParameters.Database.Length);
curPos += (short)(connectionParameters.Database.Length * 2);
// MAC Address
Comm.Append((byte)0);
Comm.Append((byte)0);
Comm.Append((byte)0);
Comm.Append((byte)0);
Comm.Append((byte)0);
Comm.Append((byte)0);
// Authentication Stuff
Comm.Append((short)curPos);
if (connectionParameters.DomainLogin)
{
Comm.Append((short)authLen);
curPos += (short)authLen;
}
else
{
Comm.Append((short)0);
}
// Unknown
Comm.Append(curPos);
Comm.Append((short)(connectionParameters.AttachDBFileName.Length));
curPos += (short)(connectionParameters.AttachDBFileName.Length * 2);
// Connection Parameters
Comm.Append(connectionParameters.Hostname);
if (!connectionParameters.DomainLogin)
{
// SQL Server Authentication
Comm.Append(connectionParameters.User);
string scrambledPwd = EncryptPassword(connectionParameters.Password);
Comm.Append(scrambledPwd);
}
Comm.Append(connectionParameters.ApplicationName);
Comm.Append(DataSource);
Comm.Append(connectionParameters.LibraryName);
Comm.Append(Language);
Comm.Append(connectionParameters.Database);
if (connectionParameters.DomainLogin)
{
// the rest of the packet is NTLMSSP authentication
Type1Message msg = new Type1Message();
msg.Domain = domain;
msg.Host = connectionParameters.Hostname;
msg.Flags = NtlmFlags.NegotiateUnicode |
NtlmFlags.NegotiateNtlm |
NtlmFlags.NegotiateDomainSupplied |
NtlmFlags.NegotiateWorkstationSupplied |
NtlmFlags.NegotiateAlwaysSign; // 0xb201
Comm.Append(msg.GetBytes());
}
Comm.Append(connectionParameters.AttachDBFileName);
Comm.SendPacket();
MoreResults = true;
SkipToEnd();
return(IsConnected);
}
protected override void ProcessColumnInfo()
{
int numColumns = Comm.GetTdsShort();
for (int i = 0; i < numColumns; i += 1)
{
byte[] flagData = new byte[4];
for (int j = 0; j < 4; j += 1)
{
flagData[j] = Comm.GetByte();
}
bool nullable = (flagData[2] & 0x01) > 0;
//bool caseSensitive = (flagData[2] & 0x02) > 0;
bool writable = (flagData[2] & 0x0c) > 0;
bool autoIncrement = (flagData[2] & 0x10) > 0;
bool isIdentity = (flagData[2] & 0x10) > 0;
TdsColumnType columnType = (TdsColumnType)((Comm.GetByte() & 0xff));
byte xColumnType = 0;
if (IsLargeType(columnType))
{
xColumnType = (byte)columnType;
if (columnType != TdsColumnType.NChar)
{
columnType -= 128;
}
}
int columnSize;
string tableName = null;
if (IsBlobType(columnType))
{
columnSize = Comm.GetTdsInt();
tableName = Comm.GetString(Comm.GetTdsShort());
}
else if (IsFixedSizeColumn(columnType))
{
columnSize = LookupBufferSize(columnType);
}
else if (IsLargeType((TdsColumnType)xColumnType))
{
columnSize = Comm.GetTdsShort();
}
else
{
columnSize = Comm.GetByte() & 0xff;
}
if (IsWideType((TdsColumnType)columnType))
{
columnSize /= 2;
}
byte precision = 0;
byte scale = 0;
if (columnType == TdsColumnType.Decimal || columnType == TdsColumnType.Numeric)
{
precision = Comm.GetByte();
scale = Comm.GetByte();
}
else
{
precision = GetPrecision(columnType, columnSize);
scale = GetScale(columnType, columnSize);
}
string columnName = Comm.GetString(Comm.GetByte());
TdsDataColumn col = new TdsDataColumn();
Columns.Add(col);
#if NET_2_0
col.ColumnType = columnType;
col.ColumnName = columnName;
col.IsAutoIncrement = autoIncrement;
col.IsIdentity = isIdentity;
col.ColumnSize = columnSize;
col.NumericPrecision = precision;
col.NumericScale = scale;
col.IsReadOnly = !writable;
col.AllowDBNull = nullable;
col.BaseTableName = tableName;
col.DataTypeName = Enum.GetName(typeof(TdsColumnType), xColumnType);
#else
col ["ColumnType"] = columnType;
col ["ColumnName"] = columnName;
col ["IsAutoIncrement"] = autoIncrement;
col ["IsIdentity"] = isIdentity;
col ["ColumnSize"] = columnSize;
col ["NumericPrecision"] = precision;
col ["NumericScale"] = scale;
col ["IsReadOnly"] = !writable;
col ["AllowDBNull"] = nullable;
col ["BaseTableName"] = tableName;
col ["DataTypeName"] = Enum.GetName(typeof(TdsColumnType), xColumnType);
#endif
}
}
public void DeleteComm(int id)
{
Comm commToDelete = _repo.Query <Comm>().Where(c => c.Id == id).FirstOrDefault();
_repo.Delete(commToDelete);
}
void OnReceiveText(object sender, Comm.TextPackage txtObj)
{
try
{
this.IsConnected= DateTime.Now.Subtract(lastReceiveTime) < TimeSpan.FromMinutes(1);
lastReceiveTime = DateTime.Now;
sensorDev_OnReceiveText(sender, txtObj);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
/// <summary>
///
/// </summary>
/// <param name="messageLog"></param>
private void AssertMessage()
{
Comm.SpecAssertMessage(Repo.Message.MsgCodeList, MessageCode.Code1013, false);
Comm.SpecAssertMessage(Repo.Message.MsgCodeList, MessageCode.Code1014, false);
}
/// <summary>
/// 创建用户皮肤
/// </summary>
/// <param name="memberId">创建者</param>
/// <param name="userType">创建者类别</param>
/// <param name="personalityPicture">个性图片</param>
/// <param name="personalityBackgroundPicture">个性背景图片</param>
/// <returns>用户皮肤对象</returns>
private static MemberSkin CreateMemberSkin(
String memberId,
Comm.UserType userType,
String personalityPicture,
String personalityBackgroundPicture)
{
MemberSkin obj = new MemberSkin();
obj.Creater = memberId;
obj.UserType = userType;
obj.PersonalityPicture = personalityPicture;
obj.PersonalityBackgroundPicture = personalityBackgroundPicture;
obj.CreatedTime = DateTime.Now;
obj.Random = new Random().NextDouble();
try
{
MongoDatabase md = MongoDBHelper.MongoDB;
MongoCollection<MemberSkin> mc = md.GetCollection<MemberSkin>(MemberSkin.GetCollectionName());
mc.Save(obj);
return obj;
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
private void CheckChannelVerifyPeriod()
{
Comm.SpecAssertMessage(Repo.Message.MsgCodeList, MessageCode.Code1014, true);
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Query_Click(object sender, EventArgs e)
{
if (SelectedTag.Count <= 0)
{
MessageBox.Show(lbl_message[2]);
return;
}
this.pl_CalendarAndTime.Visible = false;
this.pl_CalendarAndTime2.Visible = false;
long startTime = ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
long endTime = ConvertDateTimeInt(DateTime.Parse(this.EndTime.Text));
long longStartTime = Comm.ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
var count = ConvertDateTimeInt(DateTime.Parse(this.EndTime.Text)) - ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
if (startTime > endTime)
{
//开始和结束时间位置互换
string sTime = this.StartTime.Text;
string eTime = this.EndTime.Text;
this.StartTime.Text = DateTime.Parse(eTime).ToString("yyyy-MM-dd HH:mm:ss");
this.EndTime.Text = DateTime.Parse(sTime).ToString("yyyy-MM-dd HH:mm:ss");
this.radCalendar_start.SelectedDate = DateTime.Parse(eTime);
this.radCalendar_end.SelectedDate = DateTime.Parse(sTime);
this.radCalendar_start.FocusedDate = DateTime.Parse(eTime);
this.radCalendar_end.FocusedDate = DateTime.Parse(sTime);
this.radTimePicker1.Value = Convert.ToDateTime(eTime);
this.radTimePicker2.Value = Convert.ToDateTime(sTime);
//时间获取并转换
startTime = ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
endTime = ConvertDateTimeInt(DateTime.Parse(this.EndTime.Text));
longStartTime = Comm.ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
count = ConvertDateTimeInt(DateTime.Parse(this.EndTime.Text)) - ConvertDateTimeInt(DateTime.Parse(this.StartTime.Text));
}
QueryStartTime = startTime;
QueryEndTime = endTime;
//查询时间不能相同
if (QueryStartTime == QueryEndTime)
{
MessageBox.Show(lbl_message[0]);
return;
}
//查询时间不能超过3天
if ((QueryEndTime - QueryStartTime) > 259200)
{
MessageBox.Show(lbl_message[1]);
return;
}
rpnl_load.Visible = true;
if (!backgroundWorker_historydata.IsBusy)
{
this.Cursor = Cursors.WaitCursor;//等待
//初始化曲线图
historyDataShow1.SetChart(longStartTime, count);
historyDataShow2.SetChart(longStartTime, count);
historyDataShow3.SetChart(longStartTime, count);
historyDataShow4.SetChart(longStartTime, count);
//初始化井深
historyDataDepthShow1.setDepth(longStartTime, (int)count);
backgroundWorker_historydata.RunWorkerAsync();
}
}
public ActionResult EditCardInfo(PersonalCardViewModels model)
{
try
{
var pCard = db.CardPersonals.FirstOrDefault(s => s.ID == model.PCardID && s.UserID == model.UserID);
if (pCard == null)
{
return(Json(Comm.ToJsonResult("Error", "名片不存在")));
}
//if (!ModelState.IsValid)
//{
// return Json(Comm.ToJsonResult("Error", ModelState.FirstErrorMessage()));
//}
if (model.Name != null)
{
if (!string.IsNullOrWhiteSpace(model.Name.Trim()))
{
pCard.Name = model.Name;
}
else
{
return(Json(Comm.ToJsonResult("Error", "名字不能空")));
}
}
if (model.Email != null)
{
if (string.IsNullOrWhiteSpace(model.Email))
{
pCard.Email = null;
}
else if (Reg.IsEmail(model.Email))
{
pCard.Email = model.Email;
}
else
{
return(Json(Comm.ToJsonResult("Error", "邮箱格式不正确")));
}
}
if (model.Mobile != null)
{
if (string.IsNullOrWhiteSpace(model.Mobile))
{
pCard.Mobile = null;
}
else if (Reg.IsMobile(model.Mobile))
{
pCard.Mobile = model.Mobile;
}
else
{
return(Json(Comm.ToJsonResult("Error", "手机号格式不正确")));
}
}
if (model.Phone != null)
{
if (string.IsNullOrWhiteSpace(model.Phone))
{
pCard.PhoneNumber = null;
}
else if (Reg.IsPhone(model.Phone))
{
pCard.PhoneNumber = model.Phone;
}
else
{
return(Json(Comm.ToJsonResult("Error", "座机号格式不正确")));
}
}
if (model.Position != null)
{
pCard.Position = model.Position.Trim();
}
if (model.Remark != null)
{
pCard.Remark = model.Remark.Trim();
}
if (model.WeChatCode != null)
{
pCard.WeChatCode = model.WeChatCode.Trim();
}
if (model.Avatar != null)
{
pCard.Avatar = model.Avatar.Trim();
}
if (model.Images != null)
{
pCard.Images = string.Join(",", model.Images);
}
if (model.Video != null)
{
pCard.Video = model.Video.Trim();
}
if (model.Voice != null)
{
pCard.Voice = model.Voice.Trim();
}
if (model.Info != null)
{
pCard.Info = model.Info.Trim();
}
if (model.Industry != null)
{
pCard.Industry = model.Industry.Trim();
}
if (model.Birthday != null)
{
if (string.IsNullOrWhiteSpace(model.Birthday))
{
pCard.Birthday = null;
}
else
{
DateTime birthday;
if (DateTime.TryParse(model.Birthday, out birthday))
{
pCard.Birthday = birthday;
}
else
{
Json(Comm.ToJsonResult("Error", "生日的格式不正确"));
}
}
}
if (model.Gender.HasValue)
{
pCard.Gender = model.Gender.Value;
}
if (model.Address != null)
{
pCard.Address = model.Address.Trim();
}
if (model.City != null)
{
pCard.City = model.City.Trim();
}
if (model.Province != null)
{
pCard.Province = model.Province.Trim();
}
if (model.District != null)
{
pCard.District = model.District.Trim();
}
if (model.EnterpriseName != null)
{
pCard.Enterprise = model.EnterpriseName.Trim();
}
if (model.Lat != null)
{
if (string.IsNullOrWhiteSpace(model.Lat))
{
pCard.Lat = null;
}
else
{
double temp;
if (double.TryParse(model.Lat, out temp))
{
pCard.Lat = temp;
}
else
{
Json(Comm.ToJsonResult("Error", "纬度格式不正确"));
}
}
}
if (model.Lng != null)
{
if (string.IsNullOrWhiteSpace(model.Lng))
{
pCard.Lng = null;
}
else
{
double temp;
if (double.TryParse(model.Lng, out temp))
{
pCard.Lng = temp;
}
else
{
Json(Comm.ToJsonResult("Error", "纬度格式不正确"));
}
}
}
db.SaveChanges();
return(Json(Comm.ToJsonResult("Success", "成功"), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(Comm.ToJsonResult("Error500", ex.Message), JsonRequestBehavior.AllowGet));
}
}
/// <summary>
///
/// </summary>
/// <param name="expectData"></param>
/// <param name="actualData"></param>
/// <param name="messageLog"></param>
private void AssertCorrectData(CollectionTypeSet expectData, CollectionTypeSet actualData, bool isCheckInput = true)
{
Comm.CheckInputValueIsNull(actualData);
AssertSet(expectData, actualData);
AssertMessage();
}
private void backgroundWorker_historydata_DoWork(object sender, DoWorkEventArgs e)
{
try
{
PostError = false;
if (SelectedTag.Count == 0)
{
CursorsDefault();
return;
}
QueryHistory model = new QueryHistory();
model.startTime = QueryStartTime;
model.endTime = QueryEndTime;
model.DrillId = AppDrill.DrillID;
model.DepthTag = depth;
List <string> tag = new List <string>();
foreach (var item in HistoryDataForm.SelectedTag)
{
tag.Add(item.Tag);
}
model.Tag = tag;
PostData = null;
PostData = new JavaScriptSerializer().Serialize(model);
var QueryData = Comm.HttpPost(PostUrl, PostData);
if (!string.IsNullOrEmpty(QueryData))
{
JavaScriptSerializer jsSerializer = new JavaScriptSerializer();
jsSerializer.MaxJsonLength = Int32.MaxValue;
dataList = jsSerializer.Deserialize <getHistoryData>(QueryData); //反序列化
Depthdatas = new List <HistoryDepthData>();
Depthdatas = dataList.Depthdatas;
foreach (var item in dataList.datas)
{
var IndexModel = SelectedTag.Where(o => o.Tag == item.Tag).FirstOrDefault();
DateTime d4 = DateTime.Now;
if (IndexModel != null)
{
switch (IndexModel.index)
{
case 1:
historyDataShow1.upChart(item.Datas, 1, item.Tag);
break;
case 2:
historyDataShow2.upChart(item.Datas, 2, item.Tag);
break;
case 3:
historyDataShow3.upChart(item.Datas, 3, item.Tag);
break;
case 4:
historyDataShow4.upChart(item.Datas, 4, item.Tag);
break;
}
}
}
}
}
catch
{
PostError = true;
}
}
private void CheckIsOverlap()
{
Comm.SpecAssertMessage(Repo.Message.MsgCodeList, MessageCode.Code1013, true);
}
//读取拼音码
private void txtProductName_TextChanged(object sender, EventArgs e)
{
txtSpellingCode.Text = Comm.HZToSpell(txtProductName.Text.Trim());
}
/// <summary>
/// Overloaded constructor
/// </summary>
public TesterProtocol(string strPortName, byte[] ucaKey)
{
byte[] Client = { 84, 69, 83, 84, 69, 82, 32 };
mPort = new SerialDirect(strPortName, 14, ucaKey, Client);
mPort.pVersion = 14;
}
void MFCC_BS_On_DegreeChange(Comm.TC.BSTC tc, DateTime dt, DataSet ds)
{
try
{
int sink = System.Convert.ToInt32(ds.Tables[0].Rows[0]["bs_sink"]);
int shift = System.Convert.ToInt32(ds.Tables[0].Rows[0]["bs_shift"]);
int degree = System.Convert.ToInt32(ds.Tables[0].Rows[0]["bs_degree"]);
int day, hour, min;
int response_type = System.Convert.ToInt32(ds.Tables[0].Rows[0]["response_type"]);
day = System.Convert.ToInt32(ds.Tables[0].Rows[0]["day"]);
hour = System.Convert.ToInt32(ds.Tables[0].Rows[0]["hour"]);
min = System.Convert.ToInt32(ds.Tables[0].Rows[0]["minute"]);
System.DateTime dtt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, day,hour, min, 0);
string sql = "insert into tblEventBS (DeviceName,TimeStamp,DataType,BS_SHIFT,BS_SINK,BS_Degree) values('{0}','{1}',{2},{3},{4},{5})";
dbServer.SendSqlCmd(string.Format(sql,tc.DeviceName,DbCmdServer.getTimeStampString(dtt),response_type,shift,sink,degree));
this.r_host_comm.setBS_EventData(tc.DeviceName,dtt,0,shift,sink,degree);
}
catch (Exception ex)
{
ConsoleServer.WriteLine("Host err:" + ex.Message);
}
}
void MFCC_VD_On20SecEvent(object vdtc, Comm.TC.VD_MinAvgData data)
{
Comm.TC.VDTC tc = (Comm.TC.VDTC)vdtc;
ConsoleServer.WriteLine(tc.DeviceName + "," + data.dateTime + ",20SecEvent!");
lock (fileLockObj)
{
string path = Comm.Util.CPath(System.AppDomain.CurrentDomain.BaseDirectory +string.Format( @"\Vd20Sec\{0:00}{1:00}{2:00}", data.year, data.month, data.day)) ;
if (!System.IO.File.Exists(path))
System.IO.Directory.CreateDirectory(Comm.Util.CPath(path));
System.IO.StreamWriter wr = System.IO.File.AppendText(Comm.Util.CPath(path + "\\" + string.Format("{0}.txt", tc.DeviceName)));
// wr.WriteLine(tc.DeviceName+","+data.dateTime+",20SecEvent!");
wr.WriteLine(VD20SecToCsvStr(tc.DeviceName, data));
wr.Flush();
wr.Close();
wr.Dispose();
}
//throw new Exception("The method or operation is not implemented.");
}
protected void btdel_Click(object sender, EventArgs e)
{
KFB_ZHGL mo_zhgl = new KFB_ZHGL();
LinkButton btn = (LinkButton)sender;
int i_Index = ((GridViewRow)(btn.Parent.Parent)).RowIndex;
string s_NID = "";
s_NID = ((GridView)(btn.Parent.Parent.Parent.Parent)).Rows[i_Index].Cells[0].Text.ToString().Trim();
mo_zhgl = objAgentManageDB.GetModel(s_NID);
//判断是否有注單
int i_Count = objAgentManageDB.GetZD(s_NID, Comm.GetZHCol(mo_zhgl.N_HYDJ.ToString()));
if (i_Count > 0)
{
this.ShowMsg("本賬號已有注單，無法删除！");
return;
}
int i_HYCount = objAgentManageDB.GetHYZD(s_NID, Comm.GetZHCol(mo_zhgl.N_HYDJ.ToString()));
if (i_HYCount > 0)
{
this.ShowMsg("本賬號下級會員已有注單，無法删除！");
return;
}
int i_oCount = objAgentManageDB.GetOZD(s_NID, Comm.GetZHCol(mo_zhgl.N_HYDJ.ToString()));
if (i_oCount > 0)
{
this.ShowMsg("本賬號已有歷史注單，無法删除！");
return;
}
int i_oHYCount = objAgentManageDB.GetOHYZD(s_NID, Comm.GetZHCol(mo_zhgl.N_HYDJ.ToString()));
if (i_oHYCount > 0)
{
this.ShowMsg("本賬號下級會員已有歷史注單，無法删除！");
return;
}
try
{
//判斷是否存在
bool chuser = objAgentManageDB.Exists(s_NID);
if (!chuser)
{
this.ShowMsg("該會員已被刪除！");
}
else//存在則修改
{
#region "修改上级剩余额度"
objAgentManageDB.UpSJED(mo_zhgl);
#endregion
//o_KFB_ZHGL.Delete(strparid, Convert.ToInt32(strlvl));
objAgentManageDB.DeleteAll(s_NID, Comm.GetZHCol(mo_zhgl.N_HYDJ.ToString()));
SetGrid(this.drzdl.SelectedValue);
}
}
catch (Exception ex)
{
this.WriteLog("用户名=" + mUserID + ex.ToString());
this.ShowMsg("删除失败");
}
}
//public override void loadTC_AndBuildManaer()
//{
//// try
//// {
//// //System.Data.Odbc.OdbcDataReader rd;
//// //System.Data.Odbc.OdbcConnection cn = new System.Data.Odbc.OdbcConnection(Comm.DB2.Db2.db2ConnectionStr);
//// //rd = Comm.DB2.Db2.getDeviceConfigReader(cn, this.mfccid);
//// //while (rd.Read())
//// //{
//// // byte[] hw_status = new byte[4];
//// // for (int i = 0; i < 4; i++)
//// // hw_status[i] = System.Convert.ToByte(rd[3 + i]);
//// // Comm.TC.VDTC tc = new Comm.TC.VDTC(protocol, rd[0].ToString().Trim(), rd[1].ToString(), (int)rd[2], 0xffff, hw_status);
//// // ConsoleServer.WriteLine(string.Format("load tc:{0} ip:{1} port:{2}", rd[0], rd[1], rd[2]));
//// // tcAry.Add(tc);
//// //}
//// //rd.Close();
//// //cn.Close();
// Comm.TC.VDTC tc=new Comm.TC.VDTC(protocol,"VD231","192.168.22.231",1001,0xffff,new byte[]{0,0,0,0});
// tc.OnRealTimeData += new Comm.TC.OnRealTimeEventHandler(tc_OnRealTimeData);
// tc.OnTriggerEvent += new Comm.TC.OnTriggerEventHandler(tc_OnTriggerEvent);
// // tc.OnHwStatusChanged += new HWStatusChangeHandler(tc_OnHwStatusChanged);
// // tc.OnConnectStatusChanged += new ConnectStatusChangeHandler(tc_OnConnectStatusChanged);
// tc.On1MinTrafficData += new Comm.TC.On1MinEventDataHandler(tc_On1MinTrafficData);
// tcAry.Add(tc);
// this.manager = new TC_Manager(tcAry);
// //}
// //catch (Exception ex)
// //{
// // ConsoleServer.WriteLine(ex.Message);
// //}
//}
void tc_On1MinTrafficData(object vdtc, Comm.TC.VD_MinAvgData data)
{
//throw new Exception("The method or operation is not implemented.");
//this.InDbQueue.Enqueue(data);
//lock (this.InDbQueue)
//{
// System.Threading.Monitor.PulseAll(InDbQueue);
//}
try
{
// this.ToDb(data.getExecuteSql());
if (data.IsValid)
dbServer.SendSqlCmd(data.getExecuteSql());
else
{
if (r_host_comm != null)
r_host_comm.DoVD_InteropData((vdtc as TCBase).DeviceName, data.dateTime);
}
RemoteInterface.MFCC.VD1MinCycleEventData vd1min;
//if (((TCBase)vdtc).DeviceName == "VD-N1-S-149.5")
//{
vd1min = data.ToVD1MinCycleEventData();
//}
//else
//{
// vd1min = data.ToVD1MinCycleEventData();
//}
// remove on 2013-3-17
//this.notifier.NotifyAll(new NotifyEventObject(EventEnumType.VD_1min_Cycle_Event, ((TCBase)vdtc).DeviceName, vd1min));
}
catch (Exception ex)
{
ConsoleServer.WriteLine((vdtc as TCBase).DeviceName+":"+ex.Message + ex.StackTrace);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Request["nid"] != null)
{
string strnid = this.Request["nid"].ToString();
KFB_PTZD mo_PTZD = objReportDB.GetModel(strnid);
string strmes = "";
if (mo_PTZD.N_QR.ToString().Equals("1"))
{
strmes = "PS:確認時間已過，會員下注已經成功！";
}
else
{
if (this.Request["status"].Equals("0"))
{
//o_PTZD.COZDQR(strnid,"1", "0");
if (mo_PTZD != null) //如果注单存在 做删单操作
{
string strdel = mo_PTZD.N_DEL.ToString(); //注单时候删除标识位 0或者“”为未删除 1表示已经删除
decimal n_xzje = (decimal)mo_PTZD.N_XZJE;
objReportDB.Delete(strnid);
//KingOfBall.BLL.KFB_COUNT_BLL count = new KingOfBall.BLL.KFB_COUNT_BLL();
//int no = count.GetNo();
//count.InsertBillLog(no, mo_PTZD.N_HYDH, mo_PTZD.N_XZDH, mo_PTZD.N_QSBH.Value.ToString(), n_xzje, 0, 0, DateTime.Now, "6");
if (!n_xzje.Equals(0) && strdel != "1")//下注金额不等于0并且该注单未被删除，此时需要恢复会员的额度
{
objReportDB.HuiFuHYYE(mo_PTZD.N_HYDH, n_xzje / 10000);
}
}
}
else
{
objReportDB.ZDQR(strnid, "1");
}
// strmes = "操作成功！";
strmes = "";
}
//if (mo_PTZD == null)// && mo_PTZD.N_QR.ToString().Equals("1"))
//{
// strmes = "PS:確認時間已過，該筆注單已被刪除！";
//}
//else
//{
// o_PTZD.ZDQR(strnid, "1");
//}
this.Response.Write(strmes);
this.Response.Flush();
this.Response.End();;
}
if (this.Request["time"] != null && this.Request["type"] != null)
{
string strreturn = "";
string strtime = this.Request["time"].ToString();
string strtype = this.Request["type"].ToString();
if (strtime.Equals(""))
{
strtime = this.objReportDB.GetSystemTime().ToString("yyyy/MM/dd HH:mm:ss");
}
strtype = strtype.Replace("ch", "b_");
string strbslx = "'l_zdrf','l_zddx','l_zddy','l_zdhj','l_zdds','l_zdye'";
DataSet ds = objReportDB.GetZDQuick(strtime.Replace('-', '/'), strtype, strbslx);
// DataSet ds = o_PTZD.GetQuick("2008/01/01 12:00:00", strtype);
XmlDocument CreateXml = new XmlDocument();
XmlNode xmlNode = CreateXml.CreateNode(XmlNodeType.XmlDeclaration, "", "");
CreateXml.AppendChild(xmlNode);
XmlElement xmlRoot = CreateXml.CreateElement("", "ZDTB", "");
CreateXml.AppendChild(xmlRoot);
XmlElement xmlTime = CreateXml.CreateElement("", "Time", "");
//XmlText xmlTimeText = CreateXml.CreateTextNode(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss").Replace('-', '/'));
XmlText xmlTimeText = CreateXml.CreateTextNode(strtime.Replace('-', '/'));
xmlTime.AppendChild(xmlTimeText);
CreateXml.ChildNodes[1].AppendChild(xmlTime);
if (ds.Tables[0].Rows.Count > 0)
{
string strn_xzdh = "";
string strn_xzrq = "";
string strn_hydh = "";
string strnr = "";
string strn_xzwf = "";
string strn_xzje = "";
string strlx = "";
string strnid = "";
string strwxdj = "";
string strdbzd = "";
string strXZNR = "";
string strQR = "";
string strdx = "";
string strdxbl = "";
string strdxxt = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
strn_xzdh = ds.Tables[0].Rows[i]["N_XZDH"].ToString();
strn_xzrq = DateTime.Parse(ds.Tables[0].Rows[i]["N_XZRQ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
strn_hydh = ds.Tables[0].Rows[i]["N_HYDH"].ToString();
strn_xzje = ds.Tables[0].Rows[i]["N_XZJE"].ToString();
strn_xzwf = ds.Tables[0].Rows[i]["N_XZWF"].ToString();
strlx = ds.Tables[0].Rows[i]["N_BSLX"].ToString();
strnid = ds.Tables[0].Rows[i]["N_ID"].ToString();
strwxdj = ds.Tables[0].Rows[i]["N_WXDJ"].ToString();
strdbzd = ds.Tables[0].Rows[i]["N_DBZD"].ToString();
strXZNR = ds.Tables[0].Rows[i]["XZNR"].ToString();
strQR = ds.Tables[0].Rows[i]["N_QR"].ToString();
strdx = ds.Tables[0].Rows[i]["N_DX"].ToString();
strdxbl = ds.Tables[0].Rows[i]["N_DXBL"].ToString();
strdxxt = ds.Tables[0].Rows[i]["N_DXXT"].ToString();
XmlElement xmlRow = CreateXml.CreateElement("", "Rows", "");
CreateXml.ChildNodes[1].AppendChild(xmlRow);
//下注單號
XmlElement elemtEQUIP_NAME = CreateXml.CreateElement("", "N_XZDH", "");
XmlText EQUIP_NAMEtext = CreateXml.CreateTextNode(strn_xzdh);
elemtEQUIP_NAME.AppendChild(EQUIP_NAMEtext);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtEQUIP_NAME);
//下注日期
XmlElement elemtMapPath = CreateXml.CreateElement("", "N_XZRQ", "");
XmlText MapPathtext = CreateXml.CreateTextNode(strn_xzrq);
elemtMapPath.AppendChild(MapPathtext);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtMapPath);
//會員代號
XmlElement elemtPURPOSE = CreateXml.CreateElement("", "N_HYDH", "");
XmlText PURPOSEtext = CreateXml.CreateTextNode(strn_hydh);
elemtPURPOSE.AppendChild(PURPOSEtext);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtPURPOSE);
//下注金額
XmlElement eleN_XZJE = CreateXml.CreateElement("", "N_XZJE", "");
XmlText N_XZJEText = CreateXml.CreateTextNode(strn_xzje);
eleN_XZJE.AppendChild(N_XZJEText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZJE);
//下注金額
XmlElement eleN_XZWF = CreateXml.CreateElement("", "N_XZWF", "");
//XmlText N_XZWFText = CreateXml.CreateTextNode(Comm.ChType(strn_xzwf));
XmlText N_XZWFText = CreateXml.CreateTextNode(Comm.GetPlayName(strn_xzwf, "2"));
eleN_XZWF.AppendChild(N_XZWFText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZWF);
if (!strn_xzwf.Equals("l_gg"))
{
// strnr = dsnr.Tables[0].Rows[0]["n_xznr"].ToString();
strnr = strXZNR.Replace("#", "");
}
else
{
strnr = " <table class='eng_12_bk'> ";
string[] strsplit = strXZNR.Split('#');
for (int j = 0; j < strsplit.Length - 1; j++)
{
strnr = strnr + " <tr> <td width='10' bgcolor='#FFFFFF' > " + Convert.ToString(j + 1) + "</td> <td bgcolor='#FFFFFF' >" + strsplit[j].ToString() + " </td> </tr> ";
}
strnr = strnr + " </table > ";
}
//下注内容
XmlElement eleN_XZNR = CreateXml.CreateElement("", "N_XZNR", "");
XmlText N_XZNRText = CreateXml.CreateTextNode(string.Format(strnr, "", ""));
eleN_XZNR.AppendChild(N_XZNRText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZNR);
//N_ID
XmlElement eleN_ID = CreateXml.CreateElement("", "N_ID", "");
XmlText N_N_IDText = CreateXml.CreateTextNode(Comm.ChType(strnid));
eleN_ID.AppendChild(N_N_IDText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_ID);
//危險等級
XmlElement eleN_WXDJ = CreateXml.CreateElement("", "N_WXDJ", "");
XmlText N_WXDJText = CreateXml.CreateTextNode(Comm.ChType(strwxdj));
eleN_WXDJ.AppendChild(N_WXDJText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_WXDJ);
//大筆注單
XmlElement eleN_DBZD = CreateXml.CreateElement("", "N_DBZD", "");
XmlText N_DBZDText = CreateXml.CreateTextNode(Comm.ChType(strdbzd));
eleN_DBZD.AppendChild(N_DBZDText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DBZD);
//是否确认
XmlElement eleN_QR = CreateXml.CreateElement("", "N_QR", "");
XmlText N_QRText = CreateXml.CreateTextNode(Comm.ChType(strdbzd));
eleN_QR.AppendChild(N_QRText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_QR);
//DA xiao qiu tou
if ((strn_xzwf.Equals("l_zddx") || strn_xzwf.Equals("l_dx")) && strdx.Equals("0") && strdxbl.Equals("0") && strdxxt.Equals("0"))
{
XmlElement eleN_DXQT = CreateXml.CreateElement("", "N_DXQT", "");
XmlText N_DXQTText = CreateXml.CreateTextNode("1");
eleN_DXQT.AppendChild(N_DXQTText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DXQT);
}
else
{
XmlElement eleN_DXQT = CreateXml.CreateElement("", "N_DXQT", "");
XmlText N_DXQTText = CreateXml.CreateTextNode("0");
eleN_DXQT.AppendChild(N_DXQTText);
CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DXQT);
}
}
}
strreturn = CreateXml.InnerXml.ToString();
this.Response.Write(strreturn);
this.Response.Flush();
this.Response.End();;
}
}
/// <summary>
/// 按回复对象编号和回复类型返回回复集合的数量
/// </summary>
/// <param name="contentID">回复对象编号</param>
/// <param name="deleteFlag">删除状态</param>
/// <returns>回复集合的数量</returns>
public static long findForTypeCount(String contentID, CommentType type, Comm.DeletedFlag deleteFlag)
{
try
{
QueryComplete qc = Query.And(Query.EQ("CommentToID", contentID), Query.EQ("CommentType", type), Query.EQ("DeleteFlag", deleteFlag));
return MongoDBHelper.GetCount(Comment.GetCollectionName(), qc);
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
private void HistoryDataShow_Load(object sender, EventArgs e)
{
// *** BEGIN 控件整体设置 ***
zed1.IsEnableZoom = false;
zed1.IsEnableVZoom = false;
zed1.IsEnableHZoom = false;
zed1.IsShowContextMenu = false; //禁用右键弹出菜单
zed1.IsShowPointValues = false; //显示网格上对应值
//zed1.IsZoomOnMouseCenter = true; //加上这个鼠标中间可以缩放，但是有问题
zed1.BackColor = _BACK_COLOR;
zed1.BorderStyle = BorderStyle.None;
// *** END 控件整体值显示 ***
// *** BEGIN myPane设置 ***
myPane = this.zed1.GraphPane;
myPane.Fill = new Fill(_BACK_COLOR); //chart外框背景颜色
myPane.Border.IsVisible = false; //chart图边框不显示
myPane.Title.IsVisible = false; //chart图抬头不显示
myPane.Chart.Fill = new Fill(_BACK_COLOR); //chart内容绘制区域颜色
myPane.Chart.Border.IsVisible = false; //chart曲线边框不显示
// *** END myPane设置 ***
// *** BEGIN X轴设置 ***
myPane.XAxis.Cross = 0.0d; //X轴交叉刻度
myPane.XAxis.CrossAuto = true;
myPane.XAxis.Title.IsVisible = false; //X轴不显示抬头
myPane.XAxis.Color = Color.DarkGray; //X轴颜色
myPane.XAxis.Scale.IsVisible = true; //X轴显示
myPane.XAxis.Scale.FontSpec.FontColor = Color.GreenYellow; //X轴字体颜色
myPane.XAxis.MajorGrid.IsVisible = true; //X轴显示网格
myPane.XAxis.MajorGrid.Color = Color.Gray; //X轴网格颜色
//X轴最小值0
myPane.XAxis.Scale.Min = -1;
myPane.XAxis.Scale.Max = 101; //X轴最大60
myPane.XAxis.Scale.IsVisible = false; //X轴显示
//myPane.XAxis.Scale.MajorStepAuto = true; //X轴显示步长
myPane.XAxis.Scale.FontSpec.IsUnderline = false;
myPane.XAxis.Scale.MajorStep = 20; //X轴小步长1,也就是小间隔
// *** END X轴设置 ***
// *** BEGIN Y轴设置 ***
myPane.YAxis.Title.IsVisible = false; //Y轴不显示抬头
myPane.YAxis.MinorTic.IsOpposite = false;
myPane.YAxis.MajorTic.IsOpposite = false;
myPane.YAxis.Color = Color.Transparent; //Y轴颜色
myPane.YAxis.Scale.IsVisible = IsShowY; //Y轴不显示
myPane.YAxis.Scale.Align = AlignP.Inside;
myPane.YAxis.Scale.AlignH = AlignH.Center;
myPane.YAxis.Scale.FontSpec.Size = 6;
myPane.YAxis.Scale.FontSpec.FontColor = Color.GreenYellow; //Y轴字体颜色
myPane.YAxis.MajorGrid.IsVisible = true; //Y轴显示网格
myPane.YAxis.MajorGrid.Color = Color.Gray; //Y轴网格颜色
//myPane.YAxis.CrossAuto = true;
//myPane.YAxis.Cross = Comm.ConvertDateTimeInt(DateTime.Now) / 1000; //这个地方如果加上要影响Memo显示，导致Memo在放大的情况下不能展示出来
myPane.YAxis.Scale.Max = Comm.ConvertDateTimeInt(DateTime.Now) / 1000; //Y轴从0开始,这个地方要影响X轴的显示
myPane.YAxis.Scale.Min = myPane.YAxis.Scale.Max - _YCount; //Y轴上放200个点，这样看起来曲线更平滑
//myPane.YAxis.Scale.MajorStepAuto = true; //Y轴显示步长
myPane.YAxis.Scale.MajorStep = _YCount / 10; //X轴大步长为5，也就是显示文字的大间隔
myPane.YAxis.Scale.IsReverse = true; //从上到下画线
myPane.YAxis.MinorTic.IsInside = false;
// *** BEGIN Y轴设置 ***
addCurves();
//Y轴显示的文本格式化
if (IsShowY)
{
zed1.GraphPane.YAxis.ScaleFormatEvent += new Axis.ScaleFormatHandler(YAxis_ScaleFormatEvent);
}
m_dBaseTime = myPane.YAxis.Scale.Max;// (myPane.YAxis.Scale.Max + myPane.YAxis.Scale.Min) / 2;
//改变轴的刻度
zed1.AxisChange();
}
/// <summary>
/// After UpdateObjects call objects can be read using Objects property.
/// </summary>
public void UpdateObjects()
{
try
{
GXDLMSObjectCollection objs = Comm.GetObjects();
objs.Tag = this;
int pos = 0;
foreach (GXDLMSObject it in objs)
{
++pos;
NotifyProgress(this, "Creating object " + it.LogicalName, pos, objs.Count);
Objects.Add(it);
}
GXLogWriter.WriteLog("--- Created " + Objects.Count.ToString() + " objects. ---");
//Read registers units and scalers.
int cnt = Objects.Count;
if (!UseLogicalNameReferencing)
{
GXLogWriter.WriteLog("--- Reading Access rights. ---");
try
{
foreach (GXDLMSAssociationShortName sn in Objects.GetObjects(ObjectType.AssociationShortName))
{
Comm.ReadValue(sn, 3);
}
}
catch (Exception ex)
{
GXLogWriter.WriteLog(ex.Message);
}
GXLogWriter.WriteLog("--- Reading Access rights end. ---");
}
GXLogWriter.WriteLog("--- Reading scalers and units. ---");
this.OnProgress(this, "Reading scalers and units.", cnt + pos + 1, 3 * cnt);
if ((Comm.client.NegotiatedConformance & Gurux.DLMS.Enums.Conformance.MultipleReferences) != 0)
{
List <KeyValuePair <GXDLMSObject, int> > list = new List <KeyValuePair <GXDLMSObject, int> >();
foreach (GXDLMSObject it in Objects)
{
if (it is GXDLMSRegister && (it.GetAccess(3) & AccessMode.Read) != 0)
{
list.Add(new KeyValuePair <GXDLMSObject, int>(it, 3));
}
if (it is GXDLMSDemandRegister && (it.GetAccess(4) & AccessMode.Read) != 0)
{
list.Add(new KeyValuePair <GXDLMSObject, int>(it, 4));
}
}
if (list.Count != 0)
{
try
{
Comm.ReadList(list);
}
catch (Exception)
{
//Show error.
}
}
}
else
{
for (pos = 0; pos != cnt; ++pos)
{
GXDLMSObject it = Objects[pos];
if (it is GXDLMSRegister)
{
//Read scaler first.
try
{
Comm.ReadValue(it, 3);
}
catch (Exception ex)
{
GXLogWriter.WriteLog(ex.Message);
it.SetAccess(3, AccessMode.NoAccess);
if (ex is GXDLMSException)
{
continue;
}
throw ex;
}
}
if (it is GXDLMSDemandRegister)
{
//Read scaler first.
try
{
Comm.ReadValue(it, 4);
}
catch (Exception ex)
{
GXLogWriter.WriteLog(ex.Message);
UpdateError(it, 4, ex);
if (ex is GXDLMSException)
{
continue;
}
throw ex;
}
//Read Period
try
{
Comm.ReadValue(it, 8);
}
catch (Exception ex)
{
GXLogWriter.WriteLog(ex.Message);
UpdateError(it, 8, ex);
if (ex is GXDLMSException)
{
continue;
}
throw ex;
}
//Read number of periods
try
{
Comm.ReadValue(it, 9);
}
catch (Exception ex)
{
GXLogWriter.WriteLog(ex.Message);
UpdateError(it, 9, ex);
if (ex is GXDLMSException)
{
continue;
}
throw ex;
}
}
}
}
GXLogWriter.WriteLog("--- Reading scalers and units end. ---");
this.OnProgress(this, "Reading profile generic columns.", cnt, cnt);
foreach (Gurux.DLMS.Objects.GXDLMSProfileGeneric it in objs.GetObjects(ObjectType.ProfileGeneric))
{
++pos;
//Read Profile Generic Columns.
try
{
NotifyProgress(this, "Get profile generic columns", (2 * cnt) + pos, 3 * objs.Count);
UpdateColumns(it, Manufacturers.FindByIdentification(Manufacturer));
if (it.CaptureObjects == null || it.CaptureObjects.Count == 0)
{
continue;
}
}
catch
{
GXLogWriter.WriteLog(string.Format("Failed to read Profile Generic {0} columns.", it.LogicalName));
continue;
}
}
}
finally
{
NotifyProgress(this, "", 0, 0);
}
}
private void setValue(int index, string tag, double value, long timestamp)
{
//确保CurveList不为空
if (zed1.GraphPane.CurveList.Count <= 0)
{
return;
}
switch (index)
{
case 1:
//取Graph第一个曲线，也就是第一步:在GraphPane.CurveList集合中查找CurveItem
LineItem curve1 = zed1.GraphPane.CurveList[0] as LineItem;
if (curve1 == null)
{
return;
}
//第二步:在CurveItem中访问PointPairList(或者其它的IPointList)，根据自己的需要增加新数据或修改已存在的数据
IPointListEdit list1 = curve1.Points as IPointListEdit;
if (list1 == null)
{
return;
}
var newValue1 = Comm.UnitConversion(listTag, tag, AppDrill.DrillID.ToString(), value);
newValue1 = getNewValue(newValue1);
list1.Add(newValue1, timestamp);
break;
case 2:
//取Graph第一个曲线，也就是第一步:在GraphPane.CurveList集合中查找CurveItem
LineItem curve2 = zed1.GraphPane.CurveList[1] as LineItem;
if (curve2 == null)
{
return;
}
//第二步:在CurveItem中访问PointPairList(或者其它的IPointList)，根据自己的需要增加新数据或修改已存在的数据
IPointListEdit list2 = curve2.Points as IPointListEdit;
if (list2 == null)
{
return;
}
var newValue2 = Comm.UnitConversion(listTag, tag, AppDrill.DrillID.ToString(), value);
newValue2 = getNewValue(newValue2);
list2.Add(newValue2, timestamp);
break;
case 3:
//取Graph第一个曲线，也就是第一步:在GraphPane.CurveList集合中查找CurveItem
LineItem curve3 = zed1.GraphPane.CurveList[2] as LineItem;
if (curve3 == null)
{
return;
}
//第二步:在CurveItem中访问PointPairList(或者其它的IPointList)，根据自己的需要增加新数据或修改已存在的数据
IPointListEdit list3 = curve3.Points as IPointListEdit;
if (list3 == null)
{
return;
}
var newValue3 = Comm.UnitConversion(listTag, tag, AppDrill.DrillID.ToString(), value);
newValue3 = getNewValue(newValue3);
list3.Add(newValue3, timestamp);
break;
case 4:
//取Graph第一个曲线，也就是第一步:在GraphPane.CurveList集合中查找CurveItem
LineItem curve4 = zed1.GraphPane.CurveList[3] as LineItem;
if (curve4 == null)
{
return;
}
//第二步:在CurveItem中访问PointPairList(或者其它的IPointList)，根据自己的需要增加新数据或修改已存在的数据
IPointListEdit list4 = curve4.Points as IPointListEdit;
if (list4 == null)
{
return;
}
var newValue4 = Comm.UnitConversion(listTag, tag, AppDrill.DrillID.ToString(), value);
newValue4 = getNewValue(newValue4);
list4.Add(newValue4, timestamp);
break;
}
}
public abstract void sensorDev_OnReceiveText(object sender, Comm.TextPackage txtObj);
private string GetPointValue(double timestamp)
{
string strValue = " ";
try
{
double[] xVlaue = new double[4];
string[] ParaDisplay = new string[4];
List <ChartPoint> list1 = new List <ChartPoint>(); List <ChartPoint> list2 = new List <ChartPoint>();
List <ChartPoint> list3 = new List <ChartPoint>(); List <ChartPoint> list4 = new List <ChartPoint>();
IPointListEdit line1 = zed1.GraphPane.CurveList[0].Points as IPointListEdit;
IPointListEdit line2 = zed1.GraphPane.CurveList[1].Points as IPointListEdit;
IPointListEdit line3 = zed1.GraphPane.CurveList[2].Points as IPointListEdit;
IPointListEdit line4 = zed1.GraphPane.CurveList[3].Points as IPointListEdit;
//取得曲线上的点
for (int i = 0; i < line1.Count; i++)
{
list1.Add(new ChartPoint((long)line1[i].Y, line1[i].X / 100 * getTagRange(1) + Convert.ToInt16(strFrom1)));
}
for (int i = 0; i < line2.Count; i++)
{
list2.Add(new ChartPoint((long)line2[i].Y, line2[i].X / 100 * getTagRange(2) + Convert.ToInt16(strFrom2)));
}
for (int i = 0; i < line3.Count; i++)
{
list3.Add(new ChartPoint((long)line3[i].Y, line3[i].X / 100 * getTagRange(3) + Convert.ToInt16(strFrom3)));
}
for (int i = 0; i < line4.Count; i++)
{
list4.Add(new ChartPoint((long)line4[i].Y, line4[i].X / 100 * getTagRange(4) + Convert.ToInt16(strFrom4)));
}
//取得当前时间点对应的参数值
try
{
if (list1[0].dateTime < timestamp)
{
xVlaue[0] = list1.Where(o => o.dateTime >= timestamp).OrderBy(p => p.dateTime).First().value; ParaDisplay[0] = xVlaue[0].ToString();
}
}
catch
{
ParaDisplay[0] = "NA";
}
try
{
if (list2[0].dateTime < timestamp)
{
xVlaue[1] = list2.Where(o => o.dateTime >= timestamp).OrderBy(p => p.dateTime).First().value; ParaDisplay[1] = xVlaue[1].ToString();
}
}
catch
{
ParaDisplay[1] = "NA";
}
try
{
if (list3[0].dateTime < timestamp)
{
xVlaue[2] = list3.Where(o => o.dateTime >= timestamp).OrderBy(p => p.dateTime).First().value; ParaDisplay[2] = xVlaue[2].ToString();
}
}
catch
{
ParaDisplay[2] = "NA";
}
try
{
if (list4[0].dateTime < timestamp)
{
xVlaue[3] = list4.Where(o => o.dateTime >= timestamp).OrderBy(p => p.dateTime).First().value; ParaDisplay[3] = xVlaue[3].ToString();
}
}
catch
{
ParaDisplay[3] = "NA";
}
timestamp *= 1000;
strValue = Comm.ConvertIntDateTime(timestamp).ToString() + "\n" + ParaDisplay[0] + "\n" + ParaDisplay[1] + "\n" + ParaDisplay[2] + "\n" + ParaDisplay[3];
}
catch
{
}
return(strValue);
}
/// <summary>
/// Y轴显示格式
/// </summary>
/// <param name="pane"></param>
/// <param name="axis"></param>
/// <param name="val"></param>
/// <param name="index"></param>
/// <returns></returns>
private string YAxis_ScaleFormatEvent(GraphPane pane, Axis axis, double val, int index)
{
return(Comm.ConvertIntDateTime(val * 1000).ToString("HH:mm:ss"));//yyyy/MM/dd
}
private void DepthTimeChart_Load(object sender, EventArgs e)
{
_db = new DrillOSEntities();
//初次加载，读取当前井深
// m_irepeateValue = (int)double.Parse(_db.Drill.Where(p => p.ID == AppDrill.DrillID).FirstOrDefault().HoleDepth);
lbl_time.Text = DateTime.Now.ToString("yyyy/MM/dd");
try
{
if (AppDrill.permissionId != 1 && AppDrill.permissionId != 2)
{
rbtn_message.Enabled = false;
}
//获取用户配置页面缓存点个数
DataShowCnt = Int32.Parse(System.Configuration.ConfigurationManager.AppSettings["DataShowCnt"].ToString());
}
catch
{
}
// *** BEGIN 控件整体设置 ***
// zed1.IsShowPointValues = true; //显示网格上对应值
zed1.IsEnableZoom = false;
zed1.IsEnableVZoom = false;
zed1.IsEnableHZoom = false;
zed1.IsShowContextMenu = false; //禁用右键弹出菜单
//zed1.IsZoomOnMouseCenter = true; //加上这个鼠标中间可以缩放，但是有问题
zed1.BackColor = _BACK_COLOR;
zed1.BorderStyle = BorderStyle.None;
// *** END 控件整体值显示 ***
// *** BEGIN myPane设置 ***
myPane = this.zed1.GraphPane;
myPane.Fill = new Fill(_BACK_COLOR); //chart外框背景颜色
myPane.Border.IsVisible = false; //chart图边框不显示
myPane.Title.IsVisible = false; //chart图抬头不显示
myPane.Chart.Fill = new Fill(_BACK_COLOR); //chart内容绘制区域颜色
myPane.Chart.Border.IsVisible = false; //chart曲线边框不显示
// *** END myPane设置 ***
// *** BEGIN X轴设置 ***
myPane.XAxis.Cross = 0.0d; //X轴交叉刻度
myPane.XAxis.CrossAuto = true;
myPane.XAxis.Title.IsVisible = false; //X轴不显示抬头
myPane.XAxis.IsVisible = false; //X轴直接不显示
myPane.XAxis.Color = Color.Transparent; //X轴颜色
myPane.XAxis.Scale.IsVisible = true; //X轴显示
myPane.XAxis.Scale.FontSpec.FontColor = Color.GreenYellow; //X轴字体颜色
myPane.XAxis.MajorGrid.IsVisible = false; //X轴显示网格
myPane.XAxis.MajorGrid.Color = Color.Gray; //X轴网格颜色
myPane.XAxis.Scale.Min = 1; //X轴最小值0
myPane.XAxis.Scale.Max = 10; //X轴最大60
//myPane.XAxis.Scale.MajorStepAuto = true; //X轴显示步长
myPane.XAxis.Scale.FontSpec.IsUnderline = false;
//myPane.XAxis.Scale.MajorStep = 1; //X轴小步长1,也就是小间隔
// *** END X轴设置 ***
// *** BEGIN Y轴设置 ***
myPane.YAxis.Title.IsVisible = false;
myPane.YAxis.MinorTic.IsOpposite = false; //Y轴1显示抬头
myPane.YAxis.MajorTic.IsOpposite = false;
//myPane.YAxis.Title.Text = "Timing"; //Y轴1时间类型
//myPane.YAxis.Title.FontSpec.FontColor = Color.YellowGreen; //Y轴字体颜色
//myPane.YAxis.Title.FontSpec.Size = 22;
myPane.YAxis.Color = Color.White; //Y轴颜色
myPane.YAxis.Scale.IsVisible = true; //Y轴显示
myPane.YAxis.Scale.Align = AlignP.Inside;
myPane.YAxis.Scale.AlignH = AlignH.Center;
myPane.YAxis.Scale.FontSpec.Size = 20;
myPane.YAxis.Scale.FontSpec.FontColor = Color.White; //Y轴字体颜色
myPane.YAxis.MajorGrid.IsVisible = true; //Y轴显示网格
myPane.YAxis.MajorGrid.Color = Color.WhiteSmoke; //Y轴网格颜色
myPane.YAxis.Scale.Max = Comm.ConvertDateTimeInt(DateTime.Now) / 1000; //Y轴从0开始,这个地方要影响X轴的显示
myPane.YAxis.Scale.Min = myPane.YAxis.Scale.Max - _YCount;
myPane.YAxis.Scale.MajorStep = (myPane.YAxis.Scale.Max - myPane.YAxis.Scale.Min) / 10;
m_dBaseTime = myPane.YAxis.Scale.Max;
myPane.YAxis.Scale.IsReverse = true; //从上到下画线
// *** ★★★★★ 第二轴设置 ★★★★★ ***
//myPane.Y2Axis.IsVisible = true;
//myPane.Y2Axis.Title.IsVisible = true; //Y轴2显示抬头
//myPane.Y2Axis.Title.Text = "Depth"; //Y轴2时间类型
//myPane.Y2Axis.Title.FontSpec.Size = 22;
//myPane.Y2Axis.Color = Color.YellowGreen;
//myPane.Y2Axis.Scale.FontSpec.Size = 22;
//myPane.Y2Axis.Scale.FontSpec.FontColor = Color.YellowGreen;
//myPane.Y2Axis.Title.FontSpec.FontColor = Color.YellowGreen;
//myPane.Y2Axis.MajorTic.IsOpposite = false;
//myPane.Y2Axis.MinorTic.IsOpposite = false;
//myPane.Y2Axis.MajorGrid.IsVisible = true;
//// Align the Y2 axis labels so they are flush to the axis
//myPane.Y2Axis.Scale.Align = AlignP.Inside;
//myPane.Y2Axis.Scale.Min = 0; // ★★★★★ Y2的最小值可以设置为当前井深
//myPane.Y2Axis.Scale.Max = myPane.Y2Axis.Scale.Min + _DepthCount; //可以为一定步长
//myPane.Y2Axis.Scale.IsReverse = true;
// *** BEGIN Y轴设置 ***
// *** BEGIN chart线段设置 ***
//设置1200个点,假设每50毫秒更新一次,刚好检测1分钟,一旦构造后将不能更改这个值
RollingPointPairList list1 = new RollingPointPairList(DataShowCnt);
//RollingPointPairList list2 = new RollingPointPairList(259200);
// *** ★★★★★ Begin Y2的最小值可以设置为当前井深 ★★★★★
//list2.Add(6, myPane.Y2Axis.Scale.Min); //设置当前井深 由于要画线，所以得两个点
//list2.Add(6, 0); //设置当前井深 由于要画线，所以得两个点
// *** ★★★★★ End Y2的最小值可以设置为当前井深 ★★★★★
//开始，增加的线是没有数据点的(也就是list为空)
//★★★增加一条名称:Voltage，颜色Color.Bule，无符号，无数据的空线条
curve = myPane.AddCurve("", list1, Color.Green, SymbolType.None);
//curve.YAxisIndex = 0;
curve.Line.IsSmooth = true; //平滑曲线
curve.Line.SmoothTension = 0.6F;
//curve = myPane.AddCurve("", list2, Color.Red, SymbolType.None);
curve.IsY2Axis = true;
//curve.YAxisIndex = 1; //★★★ 通过词句，该队列与第二个坐标轴关联
curve.Line.IsSmooth = true; //平滑曲线
curve.Line.Width = 3;
curve.Line.SmoothTension = 0.6F;
// *** END chart线段设置 ***
zed1.GraphPane.YAxis.ScaleFormatEvent += new Axis.ScaleFormatHandler(YAxis_ScaleFormatEvent);
//改变轴的刻度
zed1.AxisChange();
//保存开始时间
tickStart = Environment.TickCount;
//SetDepth(Comm.ConvertDateTimeInt(DateTime.Now) / 1000, 1800);
}
void MFCC_BS_On_BS_1HourData(Comm.TC.BSTC tc, System.DateTime dt, int respones_type, int slope, int shift, int sink, int degree)
{
try
{
// int day_var, mon_var;
// string validChar = IsValidData(day_var, mon_var) ? "V" : "I";
string sql = "update tblBSData1Hr set bs_slope={0},bs_shift={1},bs_sink={2},bs_degree={3},DataValidity='V' where DeviceName='{4}' and timestamp='{5}'";
Program.mfcc_bs.dbServer.SendSqlCmd(string.Format(sql,slope,shift,sink,degree,tc.DeviceName,Comm.DB2.Db2.getTimeStampString(dt)));
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message + "," + ex.StackTrace);
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ballType = this.Request["bt"];
string sortId = this.Request["si"];
string accInDate = this.Request["ad"];
string selectAlliance = this.Request["sa"];
int playType = -1;
int pageSize = 10;
int pageIndex = 1;
int courtType = -1;
int isBet = -1;
if (string.IsNullOrEmpty(ballType))
{
return;
}
if (string.IsNullOrEmpty(sortId))
{
return;
}
if (accInDate == null)
{
return;
}
if (selectAlliance == null)
{
return;
}
if (!int.TryParse(this.Request["ct"], out courtType))
{
return;
}
if (!int.TryParse(this.Request["pt"], out playType))
{
return;
}
if (!int.TryParse(this.Request["ps"], out pageSize))
{
return;
}
if (!int.TryParse(this.Request["pi"], out pageIndex))
{
return;
}
if (!int.TryParse(this.Request["ib"], out isBet))
{
return;
}
List <int> selectAllianceList = new List <int>();
foreach (string str in selectAlliance.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries))
{
selectAllianceList.Add(Convert.ToInt32(str));
}
List <KFB_LMGL> allAllianceList = new List <KFB_LMGL>();
int recordCount = 0; //比赛资料
string accOutDate = "";
List <List <object> > lm = new List <List <object> >();
GameSBall objGame = new GameSBall();
List <object[]> gameList = objGame.GetCompanyGameList(ballType, selectAllianceList, courtType, sortId, isBet, accInDate, playType, pageIndex, pageSize, out recordCount, out allAllianceList, out accOutDate);
List <DateTime> zwrqlist = new List <DateTime>();
if (playType == 0) //足球早盘
{
zwrqlist = objGame.GetBreakfaseZQ(Comm.GetZWRQ().ToString("yyyy/MM/dd"));
}
else if (playType == 10)
{
zwrqlist = objGame.GetRecycleRQ(ballType);
}
JavaScriptSerializer ser = new JavaScriptSerializer();
string output = "";
//0早餐，1單式，2走地，3過關,4波胆，5半全场，6入球数，7已开赛，8过账前的历史比赛，9过账后的历史比赛,
//n_gsty 0早餐 1单式 2滚球 3过关 4波胆 5单双/入球数 6半全场
switch (playType)
{
case 0: //足球早餐
output = "[" + ser.Serialize(gameList) + "," + ser.Serialize(allAllianceList) + "," + recordCount + ",\"" + accOutDate + "\"," + ser.Serialize(zwrqlist) + "]";
break;
case 8: //已计算
output = "[" + ser.Serialize(gameList) + "," + ser.Serialize(allAllianceList) + "," + recordCount + ",\"" + accOutDate + "\"," + ser.Serialize(Comm.getZWDate()) + "]";
break;
case 9: //历史比赛
output = "[" + ser.Serialize(gameList) + "," + ser.Serialize(allAllianceList) + "," + recordCount + ",\"" + accOutDate + "\"," + ser.Serialize(Comm.getZWDate()) + "]";
break;
case 10: //垃圾桶
output = "[" + ser.Serialize(gameList) + "," + ser.Serialize(allAllianceList) + "," + recordCount + ",\"" + accOutDate + "\"," + ser.Serialize(zwrqlist) + "]";
break;
default:
output = "[" + ser.Serialize(gameList) + "," + ser.Serialize(allAllianceList) + "," + recordCount + ",\"" + accOutDate + "\"]";
break;
}
Response.Write(output);
Response.End();
}
void MFCC_RMS_OnTCReport(object tc, Comm.TextPackage txt)
{
//throw new Exception("The method or operation is not implemented.");
Comm.TC.RMSTC dev = (Comm.TC.RMSTC)tc;
if (txt.Text[0] == 0x86 || txt.Text[0] == 0xa7 || txt.Text[0] == 0xae || txt.Text[0] == 0xaf && txt.Text[1] == 0x01)
{
// ConsoleServer.WriteLine("In Rms Report:0x" + Util.ToHexString(txt.Text[0]));
System.Data.DataSet ds = this.protocol.GetSendDsByTextPackage(txt, Comm.CmdType.CmdReport);
ds.AcceptChanges();
this.notifier.NotifyAll(new NotifyEventObject(EventEnumType.MFCC_Report_Event,dev.DeviceName,ds));
string sql="";
switch (txt.Text[0])
{
case 0x86: //黃閃轉態紀錄
// ConsoleServer.WriteLine("0x86 " + txt.Text[1] +"curr_lamp:"+dev.curr_lamep);
if (dev.curr_lamep != txt.Text[1] && dev.curr_lamep == 0x05)
{
sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
try
{
ConsoleServer.WriteLine(dev.DeviceName + ", 黃閃轉態!");
ConsoleServer.WriteLine(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "86", "flash Yellow to other state"));
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "86", "flash Yellow to other state"));
}
catch (Exception ex)
{
ConsoleServer.WriteLine(ex.Message+","+ex.StackTrace);
}
}
dev.curr_lamep = txt.Text[1];
break;
case 0xa7:
sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
string display = string.Format("plan_no:{0},warnsetno:{1},", ds.Tables[0].Rows[0]["plan_no"], ds.Tables[0].Rows[0]["warnsetno"]);
ConsoleServer.WriteLine("*****A7****" + display);
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
for (int j = 0; j < ds.Tables[1].Columns.Count; j++)
{
display += ds.Tables[1].Columns[j].ColumnName + i + ":" + ds.Tables[1].Rows[i][j] + ",";
}
}
ConsoleServer.WriteLine("*****A7****"+display);
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "A7", display.Trim(new char[] { ',' })));
break;
case 0xae:
//bos_id(1:8-15)state(1:0"0_close",1"1_open",2"2_flash")msg_id(1:0-255)
int bos_id, state, msg_id;
bos_id = txt.Text[1];
state = txt.Text[2];
msg_id = txt.Text[3];
byte[] msgbyte = new byte[32];
System.Array.Copy(txt.Text, 4, msgbyte, 0, 32);
for (int i = 0; i < msgbyte.Length; i++)
if (msgbyte[i] == 0x00)
msgbyte[i] = 0x20;
string message = Util.Big5BytesToString(msgbyte);
display = string.Format("bos_id:{0}, state:{1}, msg_id:{2}, messgae:{3}", bos_id, state, msg_id, message.Trim());
sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "AE", display));
break;
}
}
else if (txt.Text[0] == 0xa6) // 現場操作燈號改變
{
string sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "A6", txt.Text[5]));
// ConsoleServer.WriteLine(dev.DeviceName + "," + (txt.Text[5] == 0 ? "儀控中止" : "儀控啟動"));
}
else if (txt.Text[0] == 0xaa) //儀控啟動結束
{
string sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(DateTime.Now), "AA", txt.Text[5]));
dev.isDisplayOff=(txt.Text[5] == 0)?true:false;
ConsoleServer.WriteLine(dev.DeviceName + "," + (txt.Text[5] == 0 ? "儀控中止" : "儀控啟動"));
}
else if (txt.Text[0] == 0xAF && txt.Text[1] == 0x02)
{
int year = txt.Text[6] * 256 + txt.Text[7];
int month = txt.Text[8];
int day = txt.Text[9];
int hour = txt.Text[10];
int min = txt.Text[11];
uint lvd_flow = (uint)(txt.Text[12] * Math.Pow(256, 3) + txt.Text[13] * Math.Pow(256, 2) + txt.Text[14] * Math.Pow(256, 1) + txt.Text[15]);
int l_no = txt.Text[16];
int l_mode = txt.Text[17];
System.DateTime dt = new DateTime(year, month, day, hour, min, 0);
string display = string.Format("vd_flow:{0},l_no:{1},l_mode:{2}", lvd_flow, l_no, l_mode);
string sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(dt), "AF02", display));
}
else if (txt.Text[0] == 0xAF && txt.Text[1] == 0x01)
{
// main_occ(1:0-100)main_flow(1:0-255)vdq_occ(1:0-100)vdq_flow(1:0-255)lvd_occ(1:0-255)lvd_flow(1:0-255)
int year = txt.Text[6] * 256 + txt.Text[7];
int month = txt.Text[8];
int day = txt.Text[9];
int hour = txt.Text[10];
int min = txt.Text[11];
int sec = txt.Text[12];
uint main_occ = txt.Text[13];
int main_flow = txt.Text[14];
int vdq_occ = txt.Text[15];
int vdq_flow = txt.Text[16];
int lvd_occ = txt.Text[17];
int lvd_flow = txt.Text[18];
System.DateTime dt = new DateTime(year, month, day, hour, min,sec);
string display = string.Format("main_occ:{0},main_flow:{1},vdq_occ:{2},vdq_flow:{3},lvd_occ:{4},lvd_flow:{5}", main_occ,main_flow,vdq_occ,vdq_flow,lvd_occ,main_flow);
string sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(dt), "AF01", display));
}
else if (txt.Text[0] == 0xAF && txt.Text[1] == 0x03)
{
// lvd_flow(0:0-255)state(1:0-1)
int year = txt.Text[6] * 256 + txt.Text[7];
int month = txt.Text[8];
int day = txt.Text[9];
int hour = txt.Text[10];
int min = txt.Text[11];
int lvd_flow = txt.Text[12];
int state=txt.Text[13];
System.DateTime dt = new DateTime(year, month, day, hour, min,0);
string display = string.Format("lvd_flow:{0},state:{1}",lvd_flow,state);
string sql = "insert into tblRmsActiveReport (devicename,timestamp,protocol,display) values('{0}','{1}','{2}','{3}')";
this.dbServer.SendSqlCmd(string.Format(sql, dev.DeviceName, DbCmdServer.getTimeStampString(dt), "AF03", display));
}
}
protected override void ProcessColumnInfo()
{
// We are connected to a Sql 7.0 server
if (TdsVersion < TdsVersion.tds80)
{
base.ProcessColumnInfo();
return;
}
// VARADHAN: TDS 8 Debugging
//Console.WriteLine ("Tds80.cs: In ProcessColumnInfo... entry");
int numColumns = Comm.GetTdsShort();
//Console.WriteLine ("Column count={0}", numColumns); TDS 8 Debugging
for (int i = 0; i < numColumns; i += 1)
{
byte[] flagData = new byte[4];
for (int j = 0; j < 4; j += 1)
{
flagData[j] = Comm.GetByte();
}
bool nullable = (flagData[2] & 0x01) > 0;
//bool caseSensitive = (flagData[2] & 0x02) > 0;
bool writable = (flagData[2] & 0x0c) > 0;
bool autoIncrement = (flagData[2] & 0x10) > 0;
bool isIdentity = (flagData[2] & 0x10) > 0;
TdsColumnType columnType = (TdsColumnType)(Comm.GetByte() & 0xff);
//Console.WriteLine ("Actual ColumnType: {0}", columnType); TDS 8 Debugging
if ((byte)columnType == 0xef)
{
columnType = TdsColumnType.NChar;
}
TdsColumnType xColumnType = columnType;
if (IsLargeType(columnType))
{
if (columnType != TdsColumnType.NChar)
{
columnType -= 128;
}
}
int columnSize;
string tableName = null;
byte[] collation = null;
int lcid = 0, sortId = 0;
if (IsBlobType(columnType))
{
columnSize = Comm.GetTdsInt();
}
else if (IsFixedSizeColumn(columnType))
{
columnSize = LookupBufferSize(columnType);
}
else if (IsLargeType(xColumnType))
{
columnSize = Comm.GetTdsShort();
}
else
{
columnSize = Comm.GetByte() & 0xff;
}
if (xColumnType == TdsColumnType.BigChar || xColumnType == TdsColumnType.BigNVarChar ||
xColumnType == TdsColumnType.BigVarChar || xColumnType == TdsColumnType.NChar ||
xColumnType == TdsColumnType.NVarChar || xColumnType == TdsColumnType.Text ||
xColumnType == TdsColumnType.NText)
{
// Read collation for SqlServer 2000 and beyond
collation = Comm.GetBytes(5, true);
lcid = TdsCollation.LCID(collation);
sortId = TdsCollation.SortId(collation);
}
if (IsBlobType(columnType))
{
tableName = Comm.GetString(Comm.GetTdsShort());
//Console.WriteLine ("Tablename: "+tableName); TDS 8 Debugging
}
byte precision = 0;
byte scale = 0;
switch (columnType)
{
case TdsColumnType.NText:
case TdsColumnType.NChar:
case TdsColumnType.NVarChar:
columnSize /= 2;
break;
case TdsColumnType.Decimal:
case TdsColumnType.Numeric:
//Comm.Skip (1);
precision = Comm.GetByte();
//Console.WriteLine ("Precision: {0}", precision); TDS 8 Debugging
scale = Comm.GetByte();
//Console.WriteLine ("Scale: {0}", scale); TDS 8 Debugging
break;
}
string columnName = Comm.GetString(Comm.GetByte());
TdsDataColumn col = new TdsDataColumn();
Columns.Add(col);
#if NET_2_0
col.ColumnType = columnType;
col.ColumnName = columnName;
col.IsAutoIncrement = autoIncrement;
col.IsIdentity = isIdentity;
col.ColumnSize = columnSize;
col.NumericPrecision = precision;
col.NumericScale = scale;
col.IsReadOnly = !writable;
col.AllowDBNull = nullable;
col.BaseTableName = tableName;
col.LCID = lcid;
col.SortOrder = sortId;
#else
col ["ColumnType"] = columnType;
col ["ColumnName"] = columnName;
col ["IsAutoIncrement"] = autoIncrement;
col ["IsIdentity"] = isIdentity;
col ["ColumnSize"] = columnSize;
col ["NumericPrecision"] = precision;
col ["NumericScale"] = scale;
col ["IsReadOnly"] = !writable;
col ["AllowDBNull"] = nullable;
col ["BaseTableName"] = tableName;
col ["LCID"] = lcid;
col ["SortOrder"] = sortId;
#endif
}
//Console.WriteLine ("Tds80.cs: In ProcessColumnInfo... exit"); TDS 8 Debugging
}
