开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
pos_chuli.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：21k
源码类别：

OA系统

开发平台：

ASP/ASPX

pos_chuli.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Data.Odbc;
  4. using System.Data.OleDb;
  5. using System.Data.SqlClient;
  6. using System.Configuration;
  7. using System.Collections;
  8. using System.Web;
  9. using System.Web.Security;
  10. using System.Web.UI;
  11. using System.Web.UI.WebControls;
  12. using System.Web.UI.WebControls.WebParts;
  13. using System.Web.UI.HtmlControls;
  14. using System.IO;
  16. public partial class web_pos_pos_chuli : System.Web.UI.Page
  17. {
  18.     string StrFilePath = "~/POS";
  19.     protected void Page_Load(object sender, EventArgs e)
  20.     {
  21.         if (!IsPostBack)
  22.         {
  23.             string filePath = Server.MapPath(StrFilePath);
  24.             if (Directory.Exists(filePath))
  25.             {
  26.                 DirectoryInfo[] arrfile = new DirectoryInfo(filePath).GetDirectories();
  27.                 foreach (DirectoryInfo s in arrfile)
  28.                 {
  29.                     shop.Items.Add(s.Name);
  30.                 }
  31.             }
  32.         }
  33.     }
  34.     protected void ShowMessageBox(string strMessage)
  35.     {
  36.         Response.Write(string.Format("<script>alert('{0}')</script>", strMessage));
  37.     }
  38.     protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
  39.     {
  40.         if (Begindate.Visible == true)
  41.         {
  42.             Begindate.Visible = false;
  43.             Begindate.Focus();
  44.         }
  45.         else
  46.         {
  47.             Begindate.Visible = true;
  48.             Begindate.Focus();
  49.         }
  50.     }
  51.     protected void Begindate_SelectionChanged(object sender, EventArgs e)
  52.     {
  53.         Begindate.Visible = false;
  54.         string year = Begindate.SelectedDate.Year.ToString();
  55.         string month = Begindate.SelectedDate.Month.ToString();
  56.         if (month.Length == 1)
  57.         {
  58.             month = "0" + month;
  59.         }
  60.         string day = Begindate.SelectedDate.Day.ToString();
  61.         if (day.Length == 1)
  62.         {
  63.             day = "0" + day;
  64.         }
  65.         b_date.Text = year + month + day ;
  66.         b_date.Focus();
  67.     }
  68.     protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
  69.     {
  70.         if (Enddate.Visible == true)
  71.         {
  72.             Enddate.Visible = false;
  73.             Enddate.Focus();
  74.         }
  75.         else
  76.         {
  77.             Enddate.Visible = true;
  78.             Enddate.Focus();
  79.         }
  80.     }
  81.     protected void Enddate_SelectionChanged(object sender, EventArgs e)
  82.     {
  83.         Enddate.Visible = false;
  84.         string year = Enddate.SelectedDate.Year.ToString();
  85.         string month = Enddate.SelectedDate.Month.ToString();
  86.         if (month.Length == 1)
  87.         {
  88.             month = "0" + month;
  89.         }
  90.         string day = Enddate.SelectedDate.Day.ToString();
  91.         if (day.Length == 1)
  92.         {
  93.             day = "0" + day;
  94.         }
  95.         e_date.Text = year + month + day ;
  96.         e_date.Focus();
  97.     }
  98.     protected void Button1_Click(object sender, EventArgs e)
  99.     {
  100.         ArrayList array_1 = new ArrayList();
  101.         ArrayList array_2 = new ArrayList();
  102.         int num=1;
  103.         if (b_date.Text.Equals("") || e_date.Text.Equals(""))
  104.         {
  105.             ShowMessageBox("请输入导入的起止日期");
  106.         }
  107.         else
  108.         {
  109.             foreach (ListItem li in shop.Items)
  110.             {
  111.                 if (li.Selected)
  112.                 {
  113.                     int begin = Convert.ToInt32(b_date.Text);
  114.                     int end = Convert.ToInt32(e_date.Text) + 1;
  115.                     for (int i = begin; i < end; i++)
  116.                     {
  117.                         string filepath = StrFilePath + "/" + li.Text.Trim().ToString() + "/eod/" + i.ToString();
  119.                         if (Directory.Exists(Server.MapPath(filepath + "/")))
  120.                         {
  121.                             string fullfilepath = Server.MapPath(filepath + "/");
  122.                             if (File.Exists(Server.MapPath(filepath + "/SPECREC.DBF")))
  123.                             {
  124.                                 string table = Server.MapPath(filepath + "/") + "SPECREC.DBF";
  125.                                 string connstr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + fullfilepath + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
  126.                                 OdbcConnection conn = new OdbcConnection("DSN = vf");
  127.                                 conn.ConnectionString = connstr;
  128.                                 conn.Open();
  129.                                 OdbcCommand comm = new OdbcCommand("select * from SPECREC", conn);
  130.                                 OdbcDataReader oledr = comm.ExecuteReader();
  131.                                 if (oledr.HasRows)
  132.                                 {
  133.                                     while (oledr.Read())
  134.                                     {
  135.                                         SqlConnection sqlcon = dbConnection.getConnection();
  136.                                         sqlcon.Open();
  137.                                         int no = 1;
  138.                                         SqlCommand sqlno = new SqlCommand("select max(NO) as no from SPECREC", sqlcon);
  139.                                         SqlDataReader drno = sqlno.ExecuteReader();
  140.                                         if (drno.HasRows)
  141.                                         {
  142.                                             while (drno.Read())
  143.                                             {
  144.                                                 try
  145.                                                 {
  146.                                                     no = Convert.ToInt32(drno["no"]) + 1;
  147.                                                 }
  148.                                                 catch
  149.                                                 {
  150.                                                 }
  151.                                             }
  152.                                         }
  153.                                         drno.Close();
  154.                                         SqlCommand sqlcom1 = new SqlCommand("select * from SPECREC where shop='" + li.Text.ToString() + "' and TDATE='" + oledr["TDATE"].ToString() + "' and TTIME='" + oledr["TTIME"].ToString() + "' and DATE='" + oledr["DATE"].ToString() + "' and TIME='" + oledr["TIME"].ToString() + "' and DESC1='" + oledr["DESC1"].ToString() + "'", sqlcon);
  155.                                         SqlDataReader dr1 = sqlcom1.ExecuteReader();
  156.                                         if (dr1.HasRows)
  157.                                         {
  158.                                             SqlConnection sqlcon1 = dbConnection.getConnection();
  159.                                             sqlcon1.Open();
  160.                                             string sqlstr = "update SPECREC set CASHIER='" + oledr["CASHIER"].ToString() + "',TAB='" + oledr["TABLE"].ToString() + "',FCODE='" + oledr["FCODE"].ToString() + "',QTY='" + Convert.ToInt32(oledr["QTY"]) + "',REMARK='" + oledr["REMARK"].ToString() + "',UNITPRICE='" + Convert.ToDouble(oledr["UNITPRICE"]) + "',ID='" + oledr["ID"].ToString() + "',NUMBER='" + oledr["NUMBER"].ToString() + "',GROU='" + oledr["GROUP"].ToString() + "',REASON='" + oledr["REASON"].ToString() + "',HANDLE_ID='" + oledr["HANDLE_ID"].ToString() + "',SYNC='" + oledr["SYNC"].ToString() + "',DESC2='" + oledr["DESC2"].ToString() + "'where shop='" + li.Text.ToString() + "' and TDATE='" + oledr["TDATE"].ToString() + "' and TTIME='" + oledr["TTIME"].ToString() + "' and DATE='" + oledr["DATE"].ToString() + "' and TIME='" + oledr["TIME"].ToString() + "'and MANAGER='" + oledr["MANAGER"].ToString() + "',DESC1='" + oledr["DESC1"].ToString() + "'";
  161.                                             try
  162.                                             {
  163.                                                 SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon1);
  164.                                                 sqlcom.ExecuteNonQuery();
  165.                                                 num = num + 1;
  166.                                             }
  167.                                             catch
  168.                                             {
  169.                                             }
  170.                                             sqlcon1.Close();
  171.                                         }
  172.                                         else
  173.                                         {
  174.                                             SqlConnection sqlcon1 = dbConnection.getConnection();
  175.                                             sqlcon1.Open();
  176.                                             string sqlstr = "insert into SPECREC(NO,shop,CASHIER,MANAGER,TDATE,TTIME,DATE,TIME,TAB,FCODE,QTY,REMARK,UNITPRICE,DESC1,ID,NUMBER,GROU,REASON,HANDLE_ID,SYNC,DESC2)values(" + no + ",'" + li.Text.ToString() + "','" + oledr["CASHIER"].ToString() + "','" + oledr["MANAGER"].ToString() + "','" + oledr["TDATE"].ToString() + "','" + oledr["TTIME"].ToString() + "','" + oledr["DATE"].ToString() + "','" + oledr["TIME"].ToString() + "','" + oledr["TABLE"].ToString() + "','" + oledr["FCODE"].ToString() + "','" + Convert.ToInt32(oledr["QTY"]) + "','" + oledr["REMARK"].ToString() + "','" + Convert.ToDouble(oledr["UNITPRICE"]) + "','" + oledr["DESC1"].ToString() + "','" + oledr["ID"].ToString() + "','" + oledr["NUMBER"].ToString() + "','" + oledr["GROUP"].ToString() + "','" + oledr["REASON"].ToString() + "','" + oledr["HANDLE_ID"].ToString() + "','" + oledr["SYNC"].ToString() + "','" + oledr["DESC2"].ToString() + "')";
  177.                                             try
  178.                                             {
  179.                                                 SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon1);
  180.                                                 sqlcom.ExecuteNonQuery();
  181.                                                 num = num + 1;
  182.                                             }
  183.                                             catch
  184.                                             {
  185.                                             }
  186.                                             sqlcon1.Close();
  187.                                         }
  188.                                         sqlcon.Close();
  189.                                     }
  190.                                 }
  191.                                 oledr.Close();
  192.                                 conn.Close();
  193.                             }
  194.                             else
  195.                             {
  196.                                 continue;
  197.                             }
  198.                             if (File.Exists(Server.MapPath(filepath + "/CTI.DBF")))
  199.                             {
  200.                                 string table = Server.MapPath(filepath + "/") + "CTI.DBF";
  201.                                 string connstr = @"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=" + fullfilepath + ";Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO";
  202.                                 OdbcConnection conn = new OdbcConnection("DSN = vf");
  203.                                 conn.ConnectionString = connstr;
  204.                                 conn.Open();
  205.                                 OdbcCommand comm = new OdbcCommand("select * from CTI", conn);
  206.                                 OdbcDataReader oledr = comm.ExecuteReader();
  207.                                 if (oledr.HasRows)
  208.                                 {
  209.                                     while (oledr.Read())
  210.                                     {
  211.                                         SqlConnection sqlcon = dbConnection.getConnection();
  212.                                         sqlcon.Open();
  213.                                         int no = 1;
  214.                                         SqlCommand sqlno = new SqlCommand("select max(NO) as no from CTI", sqlcon);
  215.                                         SqlDataReader drno = sqlno.ExecuteReader();
  216.                                         if (drno.HasRows)
  217.                                         {
  218.                                             while (drno.Read())
  219.                                             {
  220.                                                 try
  221.                                                 {
  222.                                                     no = Convert.ToInt32(drno["no"]) + 1;
  223.                                                 }
  224.                                                 catch
  225.                                                 {
  226.                                                 }
  227.                                             }
  228.                                         }
  229.                                         drno.Close();
  230.                                         SqlCommand sqlcom1 = new SqlCommand("select * from CTI where shop='" + li.Text.ToString() + "' and DATE='" + oledr["DATE"].ToString() + "' and TIME='" + oledr["TIME"].ToString() + "'and DESC1='" + oledr["DESC1"].ToString() + "' and FCODE='" + oledr["FCODE"].ToString() + "' and CASHIER='" + oledr["CASHIER"].ToString() + "' and  FGROUP='" + oledr["FGROUP"].ToString() + "' and K1='" + oledr["K1"].ToString() + "' and ID='" + oledr["ID"].ToString() + "' and NUMBER='" + Convert.ToInt32(oledr["NUMBER"]) + "' AND [GROUP]='" + oledr["GROUP"].ToString() + "' AND SEQ='" + Convert.ToInt32(oledr["SEQ"]) + "' AND SUBSEQ='" + Convert.ToInt32(oledr["SUBSEQ"]) + "' AND XREF='" + Convert.ToInt32(oledr["XREF"]) + "' AND DEPT='" + oledr["DEPT"].ToString() + "' AND SUBCODE='" + oledr["SUBCODE"].ToString() + "' AND LEVEL='" + Convert.ToInt32(oledr["LEVEL"]) + "' AND POINTS='" + Convert.ToDouble(oledr["POINTS"]) + "' AND DESC2='" + oledr["DESC2"].ToString() + "' AND ISEAT='" + Convert.ToInt32(oledr["ISEAT"]) + "' AND TAX1='" + oledr["TAX1"].ToString() + "' AND TAX2='" + oledr["TAX2"].ToString() + "' AND TAX3='" + oledr["TAX3"].ToString() + "' AND DCODE='" + Convert.ToInt32(oledr["DCODE"]) + "' AND T_ABLE='" + oledr["T_ABLE"].ToString() + "' AND D_ABLE='" + oledr["D_ABLE"].ToString() + "' AND SC_ABLE='" + oledr["SC_ABLE"].ToString() + "' AND TOMAIN='" + oledr["TOMAIN"].ToString() + "' AND TAX_GROUP='" + oledr["TAX_GROUP"].ToString() + "' AND TN='" + oledr["TN"].ToString() + "' AND HANDLE_ID='" + oledr["HANDLE_ID"].ToString() + "' AND ORDERTYPE='" + oledr["ORDERTYPE"].ToString() + "' AND POSTED='" + oledr["POSTED"].ToString() + "' AND REMARK='" + oledr["REMARK"].ToString() + "' AND SYNC='" + oledr["SYNC"].ToString() + "' AND CALCOST='" + oledr["CALCOST"].ToString() + "' AND XXREF1='" + oledr["XXREF1"].ToString() + "' AND IXREWARDS='" + oledr["IXREWARDS"].ToString() + "' AND IXREWARDRD='" + oledr["IXREWARDRD"].ToString() + "' AND IRDREQUIRE='" + oledr["IRDREQUIRE"].ToString() + "' AND SYNCID='" + oledr["SYNCID"].ToString() + "' AND OLD='" + oledr["OLD"].ToString() + "' AND BUMPED='" + oledr["BUMPED"].ToString() + "'", sqlcon);
  231.                                         SqlDataReader dr1 = sqlcom1.ExecuteReader();
  232.                                         if (dr1.HasRows)
  233.                                         {
  234.                                             SqlConnection sqlcon1 = dbConnection.getConnection();
  235.                                             sqlcon1.Open();
  236.                                             string sqlstr = "update CTI set QTY='" + Convert.ToInt32(oledr["QTY"]) + "',UNITPRICE='" + Convert.ToDouble(oledr["UNITPRICE"]) + "'where shop='" + li.Text.ToString() + "' and DATE='" + oledr["DATE"].ToString() + "' and TIME='" + oledr["TIME"].ToString() + "'and DESC1='" + oledr["DESC1"].ToString() + "' and FCODE='" + oledr["FCODE"].ToString() + "' and CASHIER='" + oledr["CASHIER"].ToString() + "' AND FGROUP='" + oledr["FGROUP"].ToString() + "' and K1='" + oledr["K1"].ToString() + "' and ID='" + oledr["ID"].ToString() + "' and NUMBER='" + Convert.ToInt32(oledr["NUMBER"]) + "' AND [GROUP]='" + oledr["GROUP"].ToString() + "' AND SEQ='" + Convert.ToInt32(oledr["SEQ"]) + "' AND SUBSEQ='" + Convert.ToInt32(oledr["SUBSEQ"]) + "' AND XREF='" + Convert.ToInt32(oledr["XREF"]) + "' AND DEPT='" + oledr["DEPT"].ToString() + "' AND SUBCODE='" + oledr["SUBCODE"].ToString() + "' AND LEVEL='" + Convert.ToInt32(oledr["LEVEL"]) + "' AND POINTS='" + Convert.ToDouble(oledr["POINTS"]) + "' AND DESC2='" + oledr["DESC2"].ToString() + "' AND ISEAT='" + Convert.ToInt32(oledr["ISEAT"]) + "' AND TAX1='" + oledr["TAX1"].ToString() + "' AND TAX2='" + oledr["TAX2"].ToString() + "' AND TAX3='" + oledr["TAX3"].ToString() + "' AND DCODE='" + Convert.ToInt32(oledr["DCODE"]) + "' AND T_ABLE='" + oledr["T_ABLE"].ToString() + "' AND D_ABLE='" + oledr["D_ABLE"].ToString() + "' AND SC_ABLE='" + oledr["SC_ABLE"].ToString() + "' AND TOMAIN='" + oledr["TOMAIN"].ToString() + "' AND TAX_GROUP='" + oledr["TAX_GROUP"].ToString() + "' AND TN='" + oledr["TN"].ToString() + "' AND HANDLE_ID='" + oledr["HANDLE_ID"].ToString() + "' AND ORDERTYPE='" + oledr["ORDERTYPE"].ToString() + "' AND POSTED='" + oledr["POSTED"].ToString() + "' AND REMARK='" + oledr["REMARK"].ToString() + "' AND SYNC='" + oledr["SYNC"].ToString() + "' AND CALCOST='" + oledr["CALCOST"].ToString() + "' AND XXREF1='" + oledr["XXREF1"].ToString() + "' AND IXREWARDS='" + oledr["IXREWARDS"].ToString() + "' AND IXREWARDRD='" + oledr["IXREWARDRD"].ToString() + "' AND IRDREQUIRE='" + oledr["IRDREQUIRE"].ToString() + "' AND SYNCID='" + oledr["SYNCID"].ToString() + "' AND OLD='" + oledr["OLD"].ToString() + "' AND BUMPED='" + oledr["BUMPED"].ToString() + "'";
  237.                                             try
  238.                                             {
  239.                                                 SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon1);
  240.                                                 sqlcom.ExecuteNonQuery();
  241.                                                 num = num + 1;
  242.                                             }
  243.                                             catch
  244.                                             {
  245.                                             }
  246.                                             sqlcon1.Close();
  247.                                         }
  248.                                         else
  249.                                         {
  250.                                             SqlConnection sqlcon1 = dbConnection.getConnection();
  251.                                             sqlcon1.Open();
  252.                                             string sqlstr = "insert into CTI(NO,shop,CASHIER,DATE,TIME,FCODE,DESC1,QTY,UNITPRICE,FGROUP,K1,ID,NUMBER,[GROUP],SEQ,SUBSEQ,XREF,DEPT,SUBCODE,LEVEL,POINTS,DESC2,ISEAT,TAX1,TAX2,TAX3,DCODE,T_ABLE,D_ABLE,SC_ABLE,TOMAIN,TAX_GROUP,TN,HANDLE_ID,ORDERTYPE,POSTED,REMARK,SYNC,CALCOST,XXREF1,IXREWARDS,IXREWARDRD,IRDREQUIRE,SYNCID,OLD,BUMPED)values(" + no + ",'" + li.Text.ToString() + "','" + oledr["CASHIER"].ToString() + "','" + oledr["DATE"].ToString() + "','" + oledr["TIME"].ToString() + "','" + oledr["FCODE"].ToString() + "','" + oledr["DESC1"].ToString() + "','" + Convert.ToInt32(oledr["QTY"]) + "','" + Convert.ToDouble(oledr["UNITPRICE"]) + "','" + oledr["FGROUP"].ToString() + "','" + oledr["K1"].ToString() + "','" + oledr["ID"].ToString() + "','" + Convert.ToInt32(oledr["NUMBER"]) + "','" + oledr["GROUP"].ToString() + "','" + Convert.ToInt32(oledr["SEQ"]) + "','" + Convert.ToInt32(oledr["SUBSEQ"]) + "','" + Convert.ToInt32(oledr["XREF"]) + "','" + oledr["DEPT"].ToString() + "','" + oledr["SUBCODE"].ToString() + "','" + Convert.ToInt32(oledr["LEVEL"]) + "','" + Convert.ToDouble(oledr["POINTS"]) + "','" + oledr["DESC2"].ToString() + "','" + Convert.ToInt32(oledr["ISEAT"]) + "','" + oledr["TAX1"].ToString() + "','" + oledr["TAX2"].ToString() + "','" + oledr["TAX3"].ToString() + "','" + Convert.ToInt32(oledr["DCODE"]) + "','" + oledr["T_ABLE"].ToString() + "','" + oledr["D_ABLE"].ToString() + "','" + oledr["SC_ABLE"].ToString() + "','" + oledr["TOMAIN"].ToString() + "','" + oledr["TAX_GROUP"].ToString() + "','" + oledr["TN"].ToString() + "','" + oledr["HANDLE_ID"].ToString() + "','" + oledr["ORDERTYPE"].ToString() + "','" + oledr["POSTED"].ToString() + "','" + oledr["REMARK"].ToString() + "','" + oledr["SYNC"].ToString() + "','" + oledr["CALCOST"].ToString() + "','" + oledr["XXREF1"].ToString() + "','" + oledr["IXREWARDS"].ToString() + "','" + oledr["IXREWARDRD"].ToString() + "','" + oledr["IRDREQUIRE"].ToString() + "','" + oledr["SYNCID"].ToString() + "','" + oledr["OLD"].ToString() + "','" + oledr["BUMPED"].ToString() + "')";
  253.                                                 SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon1);
  254.                                                 sqlcom.ExecuteNonQuery();
  255.                                                 num = num + 1;
  256.                                             sqlcon1.Close();
  257.                                         }
  258.                                         sqlcon.Close();
  259.                                     }
  260.                                 }
  261.                                 oledr.Close();
  262.                                 conn.Close();
  263.                             }
  264.                             else
  265.                             {
  266.                                 continue;
  267.                             }
  268.                         }
  269.                         else
  270.                         {
  271.                             continue;
  272.                         }
  273.                     }
  274.                 }
  275.             }
  276.             ShowMessageBox("导入成功" + num.ToString() + "笔数据");
  277.         }
  278.     }
  279. }