public string DefaultPrinterName()
    {
        string functionReturnValue = null;
        //System.Drawing.Printing.PrinterSettings oPS = new System.Drawing.Printing.PrinterSettings();

        //foreach (string strPrinter in PrinterSettings.InstalledPrinters)
        //{
        //    // Show the name of the printer
        //    MessageBox.Show(strPrinter);
        //}
        PrintDocument oPS = new PrintDocument();

        //string strDefaultPrinter = prtdoc.PrinterSettings.PrinterName;
        try {
            functionReturnValue = oPS.PrinterSettings.PrinterName;
            ESysLib.WriteLogError("Printer:" + oPS.PrinterSettings.PrinterName);
        }
        catch (System.Exception ex) {
            ESysLib.WriteLogError(ex.Message + "\n" + ex.StackTrace);
        }
        finally {
            oPS = null;
        }
        return(functionReturnValue);
    }
Exemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                string sqlText = "";

                try
                {
                    string img_pk     = Request.QueryString["img_pk"];
                    string table_name = Request.QueryString["table_name"];

                    //string dbuser = Session["APP_DBUSER"].ToString();
                    string dbuser = "******";
                    string dbpass = Session["APP_DBPASS"].ToString();

                    if (img_pk == null || img_pk == "" || img_pk == "0")
                    {
                        img_pk = "-1";//show default image
                    }

                    sqlText = "select * from " + dbuser + "." + table_name + " where pk =" + img_pk;
                    ESysLib.WriteLogFile(sqlText);
                    string conString = ConfigurationManager.AppSettings["strConn"];

                    conString += "User Id=" + dbuser + ";password="******"CONTENTTYPE"].ToString();
                        Response.BinaryWrite((byte[])dr["DATA"]);
                    }
                    connection.Close();
                }
                catch (Exception ex)
                {
                    ESysLib.WriteLogError(ex.Message + ". " + sqlText);
                    throw (ex);
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string userID, userPass = "";

                userID = Request.QueryString["userid"];
                try
                {
                    string queryString = "select esys.sf_get_pwd_by_userid('" + userID + "') xxx from dual";
                    string conString   = ConfigurationManager.AppSettings["strConn"];
                    conString += "User id=esys;Password=esys2";

                    OracleConnection connection = new OracleConnection(conString);
                    connection.Open();
                    OracleCommand    command = new OracleCommand(queryString, connection);
                    OracleDataReader reader;
                    reader = command.ExecuteReader();

                    while (reader.Read())
                    {
                        userPass = reader["xxx"].ToString();
                    }
                    reader.Close();
                    connection.Close();
                    if (userPass == "" || userPass == null)
                    {
                        Response.Redirect(Application["rooturl"] + "/login.aspx?errmsg=Invalid user id or password.");
                    }
                    else
                    {
                        CheckLogin(userID, userPass);
                    }
                }
                catch (Exception ex)
                {
                    if (ex.Message.IndexOf("Thread was being aborted", 0, ex.Message.Length - 1) == -1)
                    {
                        ESysLib.WriteLogError(Server.MachineName + "\n" + ex.Message + "\n" + ex.StackTrace);
                        Response.Redirect(Application["rooturl"] + "/login.aspx?errmsg=Invalid user id or password.");
                    }
                }
            }
        }
        private void CheckLogin(string p_user_id, string p_user_pass)
        {
            string user_info = "";

            string[] parameter;
            string[] CDelimeter = new string[] { "|!" };
            try
            {
                string queryString = "select esys.sf_check_login('" + p_user_id + "','" + p_user_pass + "') xxx, esys.sf_get_user_info('" + p_user_id + "') info  from dual";
                int    rtnValue    = -1;
                string conString   = ConfigurationManager.AppSettings["strConn"];
                conString += "User id=esys;Password=esys2";

                OracleConnection connection = new OracleConnection(conString);
                connection.Open();
                OracleCommand    command = new OracleCommand(queryString, connection);
                OracleDataReader reader;

                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    rtnValue  = Convert.ToInt16(reader["xxx"]);
                    user_info = reader["info"].ToString();
                }
                reader.Close();

                if (rtnValue > 0 && p_user_id != "" && p_user_id != null)
                {
                    if (user_info == "no_data_found")
                    {
                        Response.Redirect(Application["rooturl"] + "/login.aspx?errmsg=You have no permision to login the system.");
                    }
                    parameter = user_info.Split(CDelimeter, System.StringSplitOptions.None);

                    Session["User_ID"]       = p_user_id.ToLower();
                    Session["LOGIN_ID"]      = p_user_id.ToLower();
                    Session["USER_PK"]       = rtnValue;
                    Session["ORG_PK"]        = parameter[6];
                    Session["ORG_NAME"]      = parameter[2];
                    Session["DEPT_PK"]       = parameter[6];
                    Session["DEPT_NAME"]     = parameter[2];
                    Session["ROLE_NAME"]     = parameter[3];
                    Session["CODEADMIN_YN"]  = parameter[4];
                    Session["Debug_YN"]      = parameter[4];
                    Session["USER_NAME"]     = parameter[0];
                    Session["EMPLOYEE_PK"]   = parameter[1];
                    Session["COMPANY_PK"]    = parameter[5];
                    Session["HR_LEVEL"]      = parameter[7];
                    Session["SESSION_LANG"]  = parameter[8];
                    Session["EMP_ID"]        = parameter[9];
                    Session["POSITION_NAME"] = parameter[10];
                    Session["ANNOUNCE_YN"]   = parameter[11];

                    command             = new OracleCommand();
                    command.Connection  = connection;
                    command.CommandText = "esys.sp_login_entry";
                    command.CommandType = CommandType.StoredProcedure;
                    command.Parameters.Add("p_user_id", OracleType.VarChar, 20).Value      = p_user_id;
                    command.Parameters.Add("p_login_ip", OracleType.VarChar, 50).Value     = Request.UserHostAddress;
                    command.Parameters.Add("p_login_pcname", OracleType.VarChar, 50).Value = Request.UserHostName;
                    command.ExecuteNonQuery();
                    connection.Close();
                    connection.Dispose();
                    Response.Redirect(Application["rooturl"] + "/system/Main.aspx");
                }
                else
                {
                    connection.Close();
                    connection.Dispose();
                    Response.Redirect(Application["rooturl"] + "/login.aspx?errmsg=Invalid user id or password.");
                }
            }
            catch (Exception ex)
            {
                if (ex.Message.IndexOf("Thread was being aborted", 0, ex.Message.Length - 1) == -1)
                {
                    ESysLib.WriteLogError(ex.Message + "\n" + ex.StackTrace);
                    Response.Redirect(Application["rooturl"] + "/login.aspx?errmsg=System meet error. Please check log file to know the reason.");
                }
            }
        }
        private void CreateImage(string function)
        {
            string rtnValue = "";

            try
            {
                string _dbuser   = function.Substring(0, function.IndexOf(".", 0));
                string conString = ConfigurationManager.AppSettings["strConn"];
                conString += "User Id=" + _dbuser + ";Password="******"2";

                OracleConnection con = new OracleConnection(conString);
                con.Open();
                string queryString = "select " + function + " xxx from dual";


                OracleCommand    command = new OracleCommand(queryString, con);
                OracleDataReader reader;

                reader = command.ExecuteReader();
                while (reader.Read())
                {
                    rtnValue = Convert.ToString(reader["xxx"]);
                }
                reader.Close();
                con.Close();
            }
            catch (Exception ex)
            {
                ESysLib.WriteLogError(ex.Message + "\n" + ex.StackTrace);
                return;
            }

            if (rtnValue == "")
            {
                return;
            }

            Bitmap   objBitmap;
            Graphics objGraphics = null;
            int      ActualRows = 0;
            int      ActualCols = 0;
            int      ActualWidth = 0;
            int      ActualHeight = 0;
            int      ExtraWidth, ExtraHeight;
            Point    p;

            Response.ContentType = "image/gif";

            PDF417Net MyPDF417 = new PDF417Net();

            MyPDF417.BackColor = Color.FromName("White");
            MyPDF417.BarColor  = Color.FromName("Black");
            MyPDF417.Data      = rtnValue;   // "12321984912\n3ry8sdjhfv\nsdj sdjsd \nds v sdhsdjvsjd\njdsjsdahjsd sdav csaj  sjd jhv\nahsdv chjw";//Request.QueryString["Data"];
            //MyPDF417.ErrorCorrectionLevel = 2; //0->8
            MyPDF417.Mode = 0;               //0:Binary, 1:Text, 2:Auto
            //MyPDF417.NarrowBarWidth = 0.07;//(float)System.Convert.ToDouble(Request.QueryString["NarrowBarWidth"]);
            MyPDF417.Orientation    = 0;     //0: 0 degree, 1: 90 degree, 2: 180 degree, 3: 270 degree
            MyPDF417.Columns        = 4;     //1->30
            MyPDF417.Rows           = 3;     //1->90
            MyPDF417.TruncateSymbol = false; //(Request.QueryString["TruncateSymbol"] == "ON");
            MyPDF417.HandleTilde    = false; // (Request.QueryString["HandleTilde"] == "ON");
            //MyPDF417.Y2XRatio = 3.0;//(float)System.Convert.ToDouble(Request.QueryString["Y2XRatio"]);

            //// Get actual rows and columns of PDF417 barcode
            MyPDF417.GetActualRC(ref ActualRows, ref ActualCols);

            //// Get actual barcode width and height
            MyPDF417.GetActualSize(ref ActualWidth, ref ActualHeight);

            ExtraWidth  = 30; //System.Convert.ToInt16(Request.QueryString["ExtraWidth"]);
            ExtraHeight = 40; //System.Convert.ToInt16(Request.QueryString["ExtraHeight"]);

            // Image size = barcode size + extra space
            //if (MyPDF417.Orientation == 0 || MyPDF417.Orientation == 2)
            //{
            //    MyPDF417.SetSize(ActualWidth + ExtraWidth, ActualHeight + ExtraHeight);
            //    objBitmap = new Bitmap(ActualWidth + ExtraWidth, ActualHeight + ExtraHeight);
            //}
            //else
            //{
            //    MyPDF417.SetSize(ActualHeight + ExtraWidth, ActualWidth + ExtraHeight);
            //    objBitmap = new Bitmap(ActualHeight + ExtraWidth, ActualWidth + ExtraHeight);
            //}
            MyPDF417.SetSize(ActualWidth + ExtraWidth, ActualHeight + ExtraHeight);
            objBitmap   = new Bitmap(ActualWidth + ExtraWidth, ActualHeight + ExtraHeight);
            objGraphics = Graphics.FromImage(objBitmap);

            p = new Point(0, 0);
            MyPDF417.Render(objGraphics, p);

            objBitmap.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Gif);

            objGraphics.Flush();
        }