mes-client/UAS-出货标签管理(泽天)/贴标角度设置.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using UAS_LabelMachine.Entity;
using UAS_LabelMachine.PublicMethod;

namespace UAS_LabelMachine
{
    public partial class 贴标角度设置 : Form
    {

        DataHelper dh = SystemInf.dh;

        string custcode;

        public 贴标角度设置(string CustCode)
        {
            custcode = CustCode;
            InitializeComponent();
        }

        private void 附件内容打印_Load(object sender, EventArgs e)
        {
            DataTable dt = (DataTable)dh.ExecuteSql("select *  from PRINTXY where px_custcode='" + custcode + "' ", "select");
            if (dt.Rows.Count > 0)
            {
                X.Text = dt.Rows[0]["px_x"].ToString();
                Y.Text = dt.Rows[0]["px_y"].ToString();
                angle.Text = dt.Rows[0]["px_angle"].ToString();
                switch (dt.Rows[0]["px_type"].ToString().ToUpper())
                {
                    case "TOP":
                        Top.Checked = true;
                        break;
                    case "COVER":
                        Cover.Checked = true;
                        break;
                    case "LEFT":
                        Left.Checked = true;
                        break;
                    case "RIGHT":
                        Right.Checked = true;
                        break;
                    case "BOTTOM":
                        Bottom.Checked = true;
                        break;
                    default:
                        break;
                }
            }
        }

        private void Confirm_Click(object sender, EventArgs e)
        {
            string Type = "";
            if (Bottom.Checked)
            {
                Type = "Bottom";
            }
            if (Top.Checked)
            {
                Type = "Top";
            }
            if (Left.Checked)
            {
                Type = "Left";
            }
            if (Right.Checked)
            {
                Type = "Right";
            }
            if (Cover.Checked)
            {
                Type = "Cover";
            }
            if (angle.Text == "" || X.Text == "" || Y.Text == "")
            {
                MessageBox.Show("参数必须都填写");
                return;
            }
            if (dh.CheckExist("PRINTXY", "px_custcode='" + custcode + "'"))
            {
                dh.ExecuteSql("update PRINTXY set px_x='" + X.Text + "',px_y='" + Y.Text + "',px_angle='" + angle.Text + "',px_type='" + Type + "' where px_custcode='" + custcode + "'", "update");
            }
            else
            {
                dh.ExecuteSql("insert into PRINTXY (px_x,px_y,px_angle,px_custcode,px_type)values('" + X.Text + "','" + Y.Text + "','" + angle.Text + "','" + custcode + "','" + Type + "')", "insert");
            }
            LogManager.DoCommandLog(custcode, User.UserCode, "保持贴标角度成功", "成功");
            MessageBox.Show("保存成功");
            Close();
        }

        private void Button_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton rad = (RadioButton)sender;
            switch (rad.Name.ToUpper())
            {
                case "TOP":
                    angle.Text = "0";
                    X.Text = "0";
                    Y.Text = "0";
                    break;
                case "COVER":
                    angle.Text = "0";
                    X.Text = "0";
                    Y.Text = "0";
                    break;
                case "LEFT":
                    angle.Text = "270";
                    X.Text = "0";
                    Y.Text = "-88";
                    break;
                case "RIGHT":
                    angle.Text = "90";
                    X.Text = "0";
                    Y.Text = "-88";
                    break;
                case "BOTTOM":
                    angle.Text = "0";
                    X.Text = "4";
                    Y.Text = "-88";
                    break;
                default:
                    break;
            }
        }
    }
}