示例#1
0
 public SensorPositionDB(PositionDB actualEntityPosition, DataFrom dataFrom = DataFrom.Parent)
 {
     ActualEntityPositionDB = actualEntityPosition;
     //if(actualEntityPosition.ParentDB != null)
     ParentPositionDB = (PositionDB)actualEntityPosition.ParentDB;
     GetDataFrom      = DataFrom.Parent;
 }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string filePath = WebHelper.GetFilePath();
            string fileName = QueryString["f"];

            Response.Clear();
            Response.Buffer = true;

            this.EnableViewState = false;
            if (!String.IsNullOrEmpty(fileName) && !fileName.StartsWith(".."))
            {
                if ("file".Equals(QueryString["t"]))
                {
                    Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(Path.GetFileName(fileName)));
                    //Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
                    Response.ContentType = "application/octet-stream";
                }
                //文件存在直接获取
                if (File.Exists(filePath + fileName))
                {
                    Response.WriteFile(filePath + fileName);
                }
                else
                {
                    if (fileName.IndexOfAny(("' (").ToCharArray()) != -1)
                    {
                        return;
                    }
                    //需要从数据库先获取
                    DataTable       dt    = null;
                    MySqlParameters mySql = new MySqlParameters("InfoAdds");
                    mySql.EditSqlMode = SqlMode.Select;
                    mySql.Add(" top 1 content");
                    mySql.Add("FilePath", fileName, "FilePath={0}");
                    try
                    {
                        dt = new DataFrom().GetDataTable(mySql);
                    }
                    catch (Exception ex)
                    {
                        log4net.LogManager.GetLogger(this.GetType()).Error(mySql.GetSql(DBType.Sql2005, false), ex);
                    }
                    if (dt != null &&
                        dt.Rows.Count == 1 &&
                        !Convert.IsDBNull(dt.Rows[0][0]))
                    {
                        byte[] content = (byte[])dt.Rows[0][0];

                        Response.BinaryWrite(content);
                        Response.Flush();

                        System.IO.FileStream   fs = new System.IO.FileStream(filePath + fileName, System.IO.FileMode.CreateNew);
                        System.IO.BinaryWriter w  = new System.IO.BinaryWriter(fs);
                        w.Write(content);
                        w.Close();
                    }
                }
            }
            Response.End();
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (String.IsNullOrEmpty(QueryString["id"]))
                {
                    btnSave.Enabled = false;
                }
                else
                {
                    userId = QueryString["id"];
                    if (!Page.IsPostBack)
                    {
                        DataFrom dataFrom = new DataFrom();
                        string   userName = dataFrom.GetScalar("select name from s_user where id='" + userId + "'");
                        literalUsers.Text = String.Format("{0}[{1}]", userName, userId);

                        string sql = @"SELECT s_role.ID,s_role.NAME,case when s_roleuser.RoleID is null then 0 else 1 end as issel 
 FROM s_role
 left join  s_roleuser on s_roleuser.RoleID=s_role.ID and s_roleuser.uid='" + userId + @"'
 WHERE s_role.Iflag>0 and '" + CurrentUser.DepID + "' like s_role.depid+'%'";

                        dataFrom.BindListCtrl(sql, chkListRoles, false);
                    }
                }
            }
            catch (Exception ex)
            {
                Logger.Error("初始化失败", ex);
                RedirectError("初始化失败,请稍候再试。原因:" + ex.Message);
            }
        }
示例#4
0
 protected void Page_Load(object sender, EventArgs e)
 {
     deal = new DataFrom();
     try
     {
         if (!this.IsPostBack)
         {
             WebHelper.SetControlAttributes(btnBuild, new TextBoxVal[] { StartDate, EndDate });
             string   sDate     = deal.GetScalar("SELECT MAX(WORKDAY)+1 FROM WORKWEEK");
             DateTime startDate = DateTime.Today;
             if (!String.IsNullOrEmpty(sDate))
             {
                 StartDate.Enabled = false;
                 startDate         = DataHelper.GetDateValue(sDate, DateTime.Today);
             }
             StartDate.Text = startDate.ToString(Constants.DATE_FORMART);
             EndDate.Text   = startDate.AddYears(1).ToString(Constants.DATE_FORMART);
         }
         SetWorkWeekInfo();
     }
     catch (Exception ex)
     {
         Logger.Error("初始化失败", ex);
         RedirectError("初始化失败,请稍候再试。原因:" + ex.Message);
         return;
     }
     if (!Page.IsPostBack)
     {
         if (dtWorkWeek == null || dtWorkWeek.Rows.Count == 0)
         {
             Alert("尚无设置工作日期,请先生成(一般生成一年的数据后再根据节假日调整)");
         }
     }
 }
示例#5
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (txtPasswd.Text == txtPwdCheck.Text)
     {
         bool            isOk     = false;
         MySqlParameters mySql    = new MySqlParameters("s_user");
         DataFrom        dataFrom = new DataFrom();
         try
         {
             mySql.EditSqlMode = SqlMode.Update;
             mySql.Add("pwd", txtPasswd.Text);
             mySql.Add("id", CurrentUser.Id, "and id={0}");
             mySql.Add("oldpwd", txtPwdOld.Text, "and pwd={0}");
             isOk = dataFrom.SqlExecute(mySql) == 1;
         }
         catch (Exception ex)
         {
             Logger.Error(SqlHelper.GetSql(mySql, dataFrom.Dbtype), ex);
         }
         if (isOk)
         {
             Alert("密码修改成功!下次请使用新密码");
         }
         else
         {
             Alert("原密码输入错误,请重输!");
         }
     }
     else
     {
         Alert("两次密码输入不一致,请重输!");
     }
 }
示例#6
0
 protected void btnSubmit_Click(object sender, EventArgs e)
 {
     if (txtID.Text.Length > 0)
     {
         DataFrom dataFrom = new DataFrom(CurrentUser, QueryString);
         try
         {
             Authenticate auth = new Authenticate();
             MyUser       user = auth.GetUser(txtID.Text);
             if (String.IsNullOrEmpty(auth.Error))
             {
                 dataFrom.SetLogInfo("你现在为" + user.Name + "工作");
                 new DefaultMenu().SetFunctions(user);
                 SetSessionUser(user);
                 txtID.Text        = user.Name;
                 txtID.Enabled     = false;
                 btnSubmit.Enabled = false;
                 Alert("你现在为" + user.Name + "工作");
             }
             else
             {
                 dataFrom.SetLogInfo(txtID.Text + auth.Error);
                 Alert(txtID.Text + auth.Error);
             }
         }
         catch (Exception ex)
         {
             Logger.Error("代替失败", ex);
         }
     }
     else
     {
         Alert("帐户不能为空,请重输!");
     }
 }
示例#7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     RomoveLink();
     roleId = QueryString["id"];
     if (!Page.IsPostBack)
     {
         if (String.IsNullOrEmpty(roleId))
         {
             Close("请先选择角色再进行菜单权限分配");
         }
         string strSql = "";
         try
         {
             DataFrom dataFrom = new DataFrom();
             lblRoleName.Text = dataFrom.GetScalar("select name from s_role where Id='" + roleId + "' and depid='" + CurrentUser.DepID + "'");
             strSql           = @"select f.id,f.Name as text,case when rf.roleid is null then 0 else 1 end as checked,f.parentid,f.sn 
                         from S_Fun f
                         left join S_RoleFun rf on rf.funid=f.id and rf.RoleId=" + roleId
                                + " where f.iflag=1 order by f.SN";
             DataTable dt = dataFrom.GetDataTable(strSql);
             if (dt != null)
             {
                 WebHelper.BindTreeView(dt, "0", tvFunctions);
             }
         }
         catch (Exception ex)
         {
             Logger.Error(strSql, ex);
             RedirectError("角色功能编辑初始化失败,请稍候再试。原因:" + ex.Message);
         }
     }
 }
示例#8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            name = QueryString[Constants.MYQUERY_NAME];
            if (!Page.IsPostBack)
            {
                WebHelper.SetControlAttributes(btnSubmit, new TextBoxVal[] { txtTitle, HtmlUrl, AspxUrl });
                if (CurrentUser.IsAdmin())//仅管理员才能操作
                {
                    HtmlUrl.Enabled = true;
                    DepId.Enabled   = true;
                    divUp.Visible   = true;
                    btnUp.Visible   = true;
                    WebHelper.SetAttributesOfFile(fileHtml);
                    WebHelper.SetAttributesOfFile(fileXml);
                }
                else
                {
                    HtmlUrl.Enabled = false;
                    DepId.Enabled   = false;
                    divUp.Visible   = false;
                    btnUp.Visible   = false;
                }
                try
                {
                    DataFrom dataFrom = new DataFrom();
                    dataFrom.BindListCtrl(String.Format("select id,case when parentid='0' then '' else '  ' end+name from f_city where iflag=1 and (parentid='{0}' or id='{0}') order by parentid,id", CurrentUser.DepID), DepId, CurrentUser.IsAdmin());
                    if (!String.IsNullOrEmpty(name))
                    {
                        HtmlUrl.Text = name;
                        DataTable dt = dataFrom.GetDataTable("select Title,AspxUrl,depid from HtmlTemplate where HtmlUrl='" + name + "'");
                        if (dt != null && dt.Rows.Count > 0)
                        {
                            txtTitle.Text = dt.Rows[0]["Title"].ToString();
                            AspxUrl.Text  = dt.Rows[0]["AspxUrl"].ToString();
                            WebHelper.SetSelCtrl(dt.Rows[0]["depid"].ToString(), DepId);
                        }
                        Content.Text = TxtHelper.GetString(WebHelper.GetMyXmlPath() + "\\tpl\\" + name + Constants.HTML_SUFFIX);

                        XmlDocument doc = FromXml.GetXml(name);
                        if (doc == null)
                        {
                            txtXml.Text = XmlHelper.GetXmlDocument(true).DocumentElement.OuterXml;
                        }
                        else
                        {
                            txtXml.Text = XmlHelper.GetFormatXml(doc);
                        }
                    }
                }
                catch (Exception ex)
                {
                    Logger.Error("初始化失败", ex);
                    RedirectError("初始化失败,请稍候再试。原因:" + ex.Message);
                    return;
                }
            }
        }
示例#9
0
        public string GetWFWaiting(string userid)
        {
            string result = "0";

            try
            {
                DataTable dt = new DataFrom().GetDataTable(@"select count(*) as sumCount
 ,sum(case when wf_instance.instancestatus=0 then 1 else 0 end) as waitCount
 ,sum(case when wf_instance.instancestatus=1 then 1 else 0 end) as doCount
 from wf_instance 
 inner join wf_process on wf_process.processid=wf_instance.processid
 where (wf_instance.instancestatus=0 or wf_instance.instancestatus=1) and wf_process.processstatus=0 and wf_instance.userid='" + userid + "'");
                if (dt != null && dt.Rows.Count == 1 && Convert.ToInt32(dt.Rows[0]["sumCount"]) > 0)
                {
                    result = dt.Rows[0]["waitCount"].ToString() + "." + dt.Rows[0]["doCount"].ToString();
                }
            }
            catch (Exception ex)
            {
                log4net.LogManager.GetLogger(this.GetType()).Error("获得等待任务条数错误", ex);
            }
            return(result);
        }
示例#10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            name = QueryString[Constants.MYQUERY_NAME];
            //仅首次加载初始化
            if (String.IsNullOrEmpty(name))
            {
                Close("模板运行需要传递n参数,即对应的查询定制xml的名字(不含后缀)");
                return;
            }
            if (!Page.IsPostBack)
            {
                btnUse.Attributes.Add("onclick", "if (getSelectId('" + name + Constants.MYQUERY_SELECTID + "')) {return true;} else {alert('请先选中一个方案,再点[使用]');return false;}");
                btnDel.Attributes.Add("onclick", "if (getSelectId('" + name + Constants.MYQUERY_SELECTID + "')) {return true;} else {alert('请先选中一个方案,再点[删除]');return false;}");
            }
            //初始化参数
            MyInputs1.InputsType = MyInputsType.Detail;
            //初始化样式
            Template.SetGridViewStyle(MyGridView1);

            XmlDocument doc = null;

            //xml获取和基本判断
            try
            {
                doc = FromXml.GetXml(name);
            }
            catch (Exception ex)
            {
                Logger.Error("读取xml错误", ex);
                RedirectError("初始化失败,请稍候再试。原因:" + ex.Message);
                return;
            }
            //开始加载xml
            XmlNode myquery = XmlHelper.GetNode(doc.DocumentElement, "myquery");

            if (myquery == null)
            {
                Close("xml文件不是系统提供的定制查询配置文件");
                return;
            }
            //设置分页属性
            FromXml.SetGridViewPage(null, MyGridView1);
            try
            {
                //获得数据来源
                DataFrom dataFrom = new DataFrom(myquery, CurrentUser, QueryString);
                MyGridView1.Columns        = FromXml.GetSubjectColumns(myquery, dataFrom, MyInputs1, sqlParameters);
                MyGridView1.KeyColumnNames = "subject-id";

                if (!Page.IsPostBack)
                {
                    MyGridView1.DataBind(Template.GetSubjectData(name, MyInputs1.Columns, CurrentUser.Id));
                    MyInputs1.DataBind();
                }
            }
            catch (Exception ex)
            {
                Logger.Error("初始化失败", ex);
                RedirectError("初始化失败,请稍候再试。原因:" + ex.Message);
            }
        }
示例#11
0
 public SensorPositionDB(SensorPositionDB toClone)
 {
     GetDataFrom = toClone.GetDataFrom;
     MemoryRalitivePosition_m = toClone.MemoryRalitivePosition_m;
 }
示例#12
0
        /// <summary>
        /// 校验WorkOrder并返回(配置文件获取)
        /// </summary>
        /// <param name="_session"></param>
        /// <param name="_transData"></param>
        /// <param name="workOrder"></param>
        /// <param name="caller"></param>
        /// <returns></returns>
        public static bool CheckWorkOrder(MesSession _session, TransData _transData, out string workOrder, string caller, DataFrom getFrom)
        {
            workOrder = string.Empty;
            caller   += "-获取工单编码";

            META_ParameterInfo info = BLLFactory <META_Parameter> .Instance.FindSingle($"Key='WorkOrder'");

            if (info == null && string.IsNullOrEmpty(info.Value))
            {
                LogInfo log = new SocketService.LogInfo(_session, LogLevel.Error, $"[{_transData.SN}]执行【{caller}】接口失败>> 参数错误,请检查SQLLite中是否配置WorkOrder参数。");
                EmployeeComm.SendMsg(_session, _transData, CheckResult.NG);
                return(false);
            }

            switch (getFrom)
            {
            case DataFrom.SQLite:
                workOrder = info.Value;
                break;

            case DataFrom.SQLServer:
                DataTable dtR;
                DM_API.DM_SFCInterface Dm_Interface = new DM_API.DM_SFCInterface();
                bool bRet = GlobalData.RunTaskWithTimeoutDT <DataTable>(delegate { return(DBHelper.GetWorkOrderRemain()); }, out dtR, GlobalData.ApiTimeout, _session, _transData, "空", caller);
                if (!bRet)
                {
                    return(false);
                }

                workOrder  = DataTableHelper.GetCellValueinDT(dtR, 0, "ReturnMsg");
                info.Value = workOrder;
                BLLFactory <META_Parameter> .Instance.Update(info, info.ID);

                LogInfo log = new SocketService.LogInfo(_session, LogLevel.Info, $"[{_transData.SN}]执行【{caller}】接口成功,数据缓存本地成功,当前工单号:{workOrder}。");

                break;
            }
            return(true);
        }
示例#13
0
文件: Cls_SQL.cs 项目: daiseita/nokia
    /*  排序資料庫查詢  */
    public DataTable Query(string TableName, int Page, int PageNum)
    {
        string sql = "";

        if (conn.State == ConnectionState.Closed)
        {
            conn.Open();
        }
        try
        {
            //若數據庫連接的當前狀態是關閉的,則打開連接
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            thisPage    = Page;
            thisPageNum = PageNum;
            setPageCount();

            sql += "with PageSetting as( select " + ColumnNameString + " ,row_number()over(order by " + OrderByString + " )as RowNum from " + TableNameString;
            if (getWhereString() != "")
            {
                sql += " where " + getWhereString();
            }
            sql += " ) select " + ColumnNameString + " from PageSetting where RowNum between " + DataFrom.ToString() + " and " + DataEnd.ToString();

            SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter(sql, conn);
            DataTable      dt = new DataTable(TableName);
            mySqlDataAdapter.Fill(dt);
            if (strTranferColumn != "")
            {
                dt = AddtranferColumn(dt);
            }
            //if (thisDataSet.Tables.IndexOf(TableName) > 0) { thisDataSet.Tables.Remove(TableName); }
            //thisDataSet.Tables.Add(dt);
            if (dt.Rows.Count > 0)
            {
                return(dt);
            }
            else
            {
                return(null);
            }
        }
        catch (Exception e)
        {
            strError      += "數據檢索失敗:" + e.Message;
            ErrorRecorder += strError;
            return(null);
        }
        finally
        {
            if (conn.State != ConnectionState.Closed)
            {
                conn.Close();
            }
        }
    }
示例#14
0
        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            if (String.IsNullOrEmpty(Content.Text) || Content.Text.Length < 10)
            {
                Alert("内容不能为空并且必须10个字以上!");
                return;
            }
            XmlDocument doc = null;

            if (txtXml.Text.Length > 0)
            {
                string msg = null;
                doc = new XmlDocument();
                try
                {
                    doc.LoadXml(txtXml.Text);
                    if (!XmlHelper.HasChildNode(doc.DocumentElement, "myquery") ||
                        !XmlHelper.HasChildNode(doc.DocumentElement, "myquery/sql"))
                    {
                        msg = "XML配置文件不符合系统规范";
                    }
                }
                catch (Exception ex)
                {
                    msg = "xml语法错误:" + ex.Message;
                }
                if (!String.IsNullOrEmpty(msg))
                {
                    Alert(msg);
                    return;
                }
            }
            bool            isOk  = false;
            MySqlParameters mySql = new MySqlParameters("HtmlTemplate");

            if (String.IsNullOrEmpty(name))
            {
                mySql.EditSqlMode = SqlMode.Insert;
            }
            else
            {
                mySql.EditSqlMode = SqlMode.Update;
                mySql.Add("whereHtmlUrl", name, "HtmlUrl={0}");
            }
            string htmlUrl = HtmlUrl.Text;

            if (!htmlUrl.EndsWith(DepId.SelectedValue))
            {
                htmlUrl += DepId.SelectedValue;
            }
            mySql.Add("HtmlUrl", htmlUrl);
            string aspxUrl = AspxUrl.Text;

            if (String.IsNullOrEmpty(aspxUrl))
            {
                aspxUrl = HtmlGenerate.GetAspxUrl(htmlUrl);
            }
            mySql.Add("AspxUrl", aspxUrl);
            mySql.Add("Title", txtTitle.Text);
            mySql.Add("depid", DepId.SelectedValue);
            mySql.Add("optime", DateTime.Now);
            mySql.Add("userid", CurrentUser.Id);
            DataFrom data = new DataFrom();

            try
            {
                data.SqlExecute(mySql);
                TxtHelper.WriteToFile(WebHelper.GetMyXmlPath() + "\\tpl\\" + name + Constants.HTML_SUFFIX, Content.Text, true);
                if (doc != null)
                {
                    doc.Save(WebHelper.GetMyXmlPath() + "\\query\\" + name + Constants.XML_SUFFIX);
                }
                isOk = true;
            }
            catch (Exception ex)
            {
                Logger.Error(SqlHelper.GetSql(mySql, data.Dbtype), ex);
                RedirectError("提交失败,请稍候再试。原因:" + ex.Message);
                return;
            }
            if (isOk)
            {
                Redirect("Tmp/MyQuery.aspx?" + Constants.MYQUERY_NAME + "=listHtmlTemplate&sy=1");
            }
        }
示例#15
0
 protected void btnUp_Click(object sender, EventArgs e)
 {
     if (fileHtml.Value.Length > 0)
     {
         int    p        = fileHtml.Value.IndexOf("\\web\\", StringComparison.CurrentCultureIgnoreCase);
         string fileName = Path.GetFileName(fileHtml.PostedFile.FileName);
         if (p == -1)
         {
             if (fileName.EndsWith(Constants.HTML_SUFFIX, StringComparison.CurrentCultureIgnoreCase))
             {
                 //上传htm模板
                 string rootPath = WebHelper.GetMyXmlPath() + "\\tpl\\";
                 try
                 {
                     fileHtml.PostedFile.SaveAs(rootPath + fileName);
                     DataFrom        data  = new DataFrom();
                     MySqlParameters mySql = HtmlGenerate.GetHtmlTemplate(data, fileName, CurrentUser.Id);
                     if (mySql != null)
                     {
                         data.SqlExecute(mySql);
                     }
                     name = fileName.ToLower().Replace(Constants.HTML_SUFFIX, "");
                 }
                 catch (Exception ex)
                 {
                     Logger.Error("上传HTML模板错误", ex);
                     RedirectError("上传HTML模板失败,请稍后重试。原因:" + ex.Message);
                     return;
                 }
             }
             else if (fileName.EndsWith(Constants.XML_SUFFIX, StringComparison.CurrentCultureIgnoreCase))
             {
                 string rootPath = WebHelper.GetMyXmlPath() + "\\query\\";
                 try
                 {
                     fileHtml.PostedFile.SaveAs(rootPath + fileName);
                 }
                 catch (Exception ex)
                 {
                     Logger.Error("上传XML配置错误", ex);
                     RedirectError("上传XML配置失败,请稍后重试。原因:" + ex.Message);
                     return;
                 }
             }
             else
             {
                 Alert("请选择HTML模板");
                 return;
             }
         }
         else
         {
             //上传web 目录文件
             try
             {
                 string rootPath = WebHelper.GetRootServerPath() + fileHtml.Value.Substring(p + 5, fileHtml.Value.LastIndexOf("\\") - p - 4);
                 fileHtml.PostedFile.SaveAs(rootPath + fileName);
             }
             catch (Exception ex)
             {
                 Logger.Error("上传覆盖错误", ex);
                 RedirectError("上传覆盖失败,请稍后重试。原因:" + ex.Message);
                 return;
             }
         }
     }
     else
     {
         Alert("请选择HTML模板");
     }
     if (fileXml.Value.Length > 0 &&
         fileXml.PostedFile.FileName.EndsWith(Constants.XML_SUFFIX, StringComparison.CurrentCultureIgnoreCase) &&
         !String.IsNullOrEmpty(name))
     {
         string rootPath = WebHelper.GetMyXmlPath() + "\\query\\";
         try
         {
             fileXml.PostedFile.SaveAs(rootPath + name + Constants.XML_SUFFIX);
         }
         catch (Exception ex)
         {
             Logger.Error("上传XML配置错误", ex);
             RedirectError("上传XML配置失败,请稍后重试。原因:" + ex.Message);
             return;
         }
     }
     if (!String.IsNullOrEmpty(name))
     {
         Redirect("Tmp/EditHtml.aspx?" + Constants.MYQUERY_NAME + "=" + name + "&sy=1");
     }
 }
示例#16
0
        private void btnRead_Click(object sender, EventArgs e)
        {
            try
            {
                DateTime DataFrom;
                DateTime DataTo;
                string   strFromData, strToData;
                string   strFromReceipt, strToReceipt;
                TipoLettura = comboBoxLetture.SelectedIndex + 1;

                switch (cmBOXModels.Text)
                {
                case "IGLOBE":
                    if (rBVideo.Checked)
                    {
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C4");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C120");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=R1");
                    }
                    if (rBPrint.Checked)
                    {
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C4");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C120");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=R0");
                    }

                    switch (TipoLettura)
                    {
                    case 1:
                        //GE For Data From Sct to SCT
                        DataFrom       = dateTimePickerFrom.Value;
                        strFromData    = "=\"" + DataFrom.ToString("ddMMyy") + "S";
                        strFromReceipt = "=\"" + FromRcpt.Value.ToString() + "S";
                        strToReceipt   = "=\"" + ToRcpt.Value.ToString() + "S";
                        IOUserData     = MySerialTest.DirectIO(0, 0, "=C4");
                        IOUserData     = MySerialTest.DirectIO(0, 0, "=C452");
                        IOUserData     = MySerialTest.DirectIO(0, 0, strFromData);
                        IOUserData     = MySerialTest.DirectIO(0, 0, strFromReceipt);
                        IOUserData     = MySerialTest.DirectIO(0, 0, strToReceipt);
                        break;

                    case 2:
                        //GE From Data to Data
                        DataFrom    = dateTimePickerFrom.Value;
                        strFromData = "=\"" + DataFrom.ToString("ddMMyy") + "S";
                        DataTo      = dateTimePickerTo.Value;
                        strToData   = "=\"" + DataTo.ToString("ddMMyy") + "S";
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C4");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C451");
                        IOUserData  = MySerialTest.DirectIO(0, 0, strFromData);
                        IOUserData  = MySerialTest.DirectIO(0, 0, strToData);
                        break;

                    case 3:
                        //GE Full
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C4");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C450");
                        break;

                    case 4:
                        //MF
                        break;

                    case 5:
                        //MF
                        break;

                    case 6:
                        //MF
                        break;

                    default:
                        break;
                    }
                    break;

                case "ONDA":
                    break;

                case "SWING":
                    switch (TipoLettura)
                    {
                    case 1:
                        //GE For Data From Sct to SCT
                        DataFrom       = dateTimePickerFrom.Value;
                        strFromData    = "&" + DataFrom.ToString("ddMMyy");
                        strFromReceipt = "[" + FromRcpt.Value.ToString();
                        strToReceipt   = "]" + ToRcpt.Value.ToString();
                        IOUserData     = MySerialTest.DirectIO(0, 0, "=C3");
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C452/$0/" + strFromData + "/" + strFromReceipt + "/" + strToReceipt);
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C452/$1/" + strFromData + "/" + strFromReceipt + "/" + strToReceipt);
                        }
                        break;

                    case 2:
                        //GE From Data to Data
                        DataFrom    = dateTimePickerFrom.Value;
                        strFromData = "&" + DataFrom.ToString("ddMMyy");
                        DataTo      = dateTimePickerTo.Value;
                        strToData   = "[" + DataTo.ToString("ddMMyy");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C3");
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C451/$0/" + strFromData + "/" + strToData);
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C451/$1/" + strFromData + "/" + strToData);
                        }
                        break;

                    case 3:
                        //GE Full
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C450/$0");
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C450/$1");
                        }
                        break;

                    case 4:
                        //MF
                        break;

                    case 5:
                        //MF From Data to Data
                        DataFrom    = dateTimePickerFrom.Value;
                        strFromData = "&" + DataFrom.ToString("ddMMyy");
                        DataTo      = dateTimePickerTo.Value;
                        strToData   = "[" + DataTo.ToString("ddMMyy");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C3");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C401/" + strFromData + "/" + strToData);
                        break;

                    case 6:
                        //MF FULL
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C400");
                        break;

                    default:
                        break;
                    }
                    break;

                case "PRINTF":
                    switch (TipoLettura)
                    {
                    case 1:
                        //GE For Data From Sct to SCT
                        DataFrom       = dateTimePickerFrom.Value;
                        strFromData    = "&" + DataFrom.ToString("ddMMyy");
                        strFromReceipt = "[" + FromRcpt.Value.ToString();
                        strToReceipt   = "]" + ToRcpt.Value.ToString();
                        IOUserData     = MySerialTest.DirectIO(0, 0, "=C3");
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C452/$0/" + strFromData + "/" + strFromReceipt + "/" + strToReceipt);
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C452/$1/" + strFromData + "/" + strFromReceipt + "/" + strToReceipt);
                        }
                        break;

                    case 2:
                        //GE From Data to Data
                        DataFrom    = dateTimePickerFrom.Value;
                        strFromData = "&" + DataFrom.ToString("ddMMyy");
                        DataTo      = dateTimePickerTo.Value;
                        strToData   = "[" + DataTo.ToString("ddMMyy");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C3");
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C451/$0/" + strFromData + "/" + strToData);
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C451/$1/" + strFromData + "/" + strToData);
                        }
                        break;

                    case 3:
                        //GE Full
                        if (rBVideo.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C450/$0");
                        }
                        if (rBPrint.Checked)
                        {
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                            IOUserData = MySerialTest.DirectIO(0, 0, "=C450/$1");
                        }
                        break;

                    case 4:
                        //MF
                        break;

                    case 5:
                        //MF From Data to Data
                        DataFrom    = dateTimePickerFrom.Value;
                        strFromData = "&" + DataFrom.ToString("ddMMyy");
                        DataTo      = dateTimePickerTo.Value;
                        strToData   = "[" + DataTo.ToString("ddMMyy");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C3");
                        IOUserData  = MySerialTest.DirectIO(0, 0, "=C401/" + strFromData + "/" + strToData);
                        break;

                    case 6:
                        //MF FULL
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C3");
                        IOUserData = MySerialTest.DirectIO(0, 0, "=C400");
                        break;

                    default:
                        break;
                    }
                    break;

                default:
                    break;
                }
                //IOUserData = MySerialTest.DirectIO(0, 0, "=C1");
            }
            catch (System.Exception ex)
            {
                MessageBox.Show("Errore " + ex.ToString());
            }
        }