private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e) { if (RowRemark >= dataGridView1.RowCount) { return; } List <clsFAinfo> SaveResult = new List <clsFAinfo>(); clsFAinfo item = new clsFAinfo(); item.fapiaohao = this.dataGridView1.Rows[RowRemark].Cells["发票号"].EditedFormattedValue.ToString(); item.danganhao = this.dataGridView1.Rows[RowRemark].Cells["档案号"].EditedFormattedValue.ToString(); item.bianhao = this.dataGridView1.Rows[RowRemark].Cells["编号"].EditedFormattedValue.ToString(); item.jigoudaima = this.dataGridView1.Rows[RowRemark].Cells["机构代码"].EditedFormattedValue.ToString(); item.fapiaoleixing = this.dataGridView1.Rows[RowRemark].Cells["发票类型"].EditedFormattedValue.ToString(); item.Input_Date = DateTime.Now.ToString("yyyyMMdd-HHmmss"); item.R_id = IDclick; item.guidangrenzhanghao = guidangren; SaveResult.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.updateFA_Server(SaveResult); InitialSystemInfo(); }
protected void Page_Load(object sender, EventArgs e) { user = (yh_jinxiaocun_user)Session["user"]; try { if (user != null) { userName.InnerHtml = user.name; HtmlControl frame1 = (HtmlControl)this.FindControl("frame1"); clsAllnew allbewn = new clsAllnew(); allbewn.inputcookvalue("入库"); NewMethod(); } else { Response.Write("<script>alert('请登录!');location='/Myadmin/Login.aspx';</script>"); } } catch { Response.Write("<script>;location='~/wqx.aspx';</script>"); } }
private void button5_Click(object sender, EventArgs e) { userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox1.Text == "") { MessageBox.Show("请填写完整信息然后锁定或解锁!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (this.radioButton1.Checked == false && this.radioButton2.Checked == false) { MessageBox.Show("账户状态缺失,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } item.name = textBox1.Text.Trim(); if (this.radioButton1.Checked == true) { item.Btype = "Normal"; } else if (this.radioButton2.Checked == true) { item.Btype = "lock"; } userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.lock_Userpassword_Server(userlist_Server); MessageBox.Show("账户状态修改成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void button5_Click(object sender, EventArgs e) { bushoudaima_Server = new List <clsbushoudaima_info>(); clsbushoudaima_info item = new clsbushoudaima_info(); item.shang = textBox25.Text.Trim(); item.xia = this.textBox24.Text.Trim(); item.zuo = this.textBox30.Text.Trim(); item.you = textBox27.Text.Trim(); item.zhong = this.textBox23.Text.Trim(); item.shangzhongxia = this.textBox31.Text.Trim(); item.zuozhongyou = this.textBox28.Text.Trim(); item.nei = this.textBox29.Text.Trim(); item.wai = this.textBox26.Text.Trim(); item.zuoyou_jiegou = this.textBox32.Text.Trim(); item.zuoyou_jiegoudaima = this.textBox33.Text.Trim(); item.shangxia_jiegou = this.textBox35.Text.Trim(); item.shangxia_jiegoudaima = this.textBox34.Text.Trim(); bushoudaima_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.createbushoudaimaServer(bushoudaima_Server); MessageBox.Show("创建成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void InitialSystemInfo(string name) { clsAllnew BusinessHelp = new clsAllnew(); userlist_Server = new List <clsuserinfo>(); userlist_Server = BusinessHelp.findUser(name); #region page1 信息录入 if (userlist_Server.Count != 0) { this.textBox1.Text = userlist_Server[0].name; this.textBox2.Text = userlist_Server[0].password; this.textBox3.Text = userlist_Server[0].password; this.comboBox1.Text = userlist_Server[0].jigoudaima; if (userlist_Server[0].Btype == "lock") { this.radioButton2.Checked = true; } else { this.radioButton1.Checked = true; } if (userlist_Server[0].AdminIS == "true") { checkBox1.Checked = true; } this.textBox6.Text = userlist_Server[0].name; this.textBox4.Text = userlist_Server[0].password; this.textBox5.Text = userlist_Server[0].password; } #endregion }
private void filterButton_Click(object sender, EventArgs e) { this.pbStatus.Value = 0; this.toolStripLabel1.Text = ""; startAt = this.stockOutDateTimePicker.Value.AddDays(0).Date; endAt = this.stockInDateTimePicker1.Value.AddDays(0).Date; txfind = this.textBox8.Text; string strSelect = "select * from JNOrder_customer where Input_Date>='" + startAt.ToString("yyyy/MM/dd") + "'" + "and " + "Input_Date<='" + endAt.ToString("yyyy/MM/dd") + "'"; // strSelect = "select * from JNOrder_customer where Input_Date BETWEEN #" + startAt + "# AND #" + endAt + "#";//成功 if (txfind.Length > 0) { strSelect += " And customer_name like '%" + txfind + "%'"; if (txfind == "所有") { strSelect = "select * from JNOrder_customer"; } } strSelect += " order by customer_id desc"; clsAllnew BusinessHelp = new clsAllnew(); customerinfolist_Server = new List <clscustomerinfo>(); customerinfolist_Server = BusinessHelp.findcustomer(strSelect); this.BindDataGridView(); }
private void Read_arir(object sender, DoWorkEventArgs e) { DateTime oldDate = DateTime.Now; //初始化信息 clsAllnew BusinessHelp = new clsAllnew(); RResult = new List <clsDatabaseinfo>(); BusinessHelp.bgWorker1 = bgWorker; RResult = BusinessHelp.ReadfindngFile(inputFileName); #region 读取网站信息 //BusinessHelp.RResult = RResult; //BusinessHelp.run_type = 2; //BusinessHelp.ReadGeckoWEN(null); //RResult = BusinessHelp.RResult; #endregion DateTime FinishTime = DateTime.Now; TimeSpan s = DateTime.Now - oldDate; string timei = s.Minutes.ToString() + ":" + s.Seconds.ToString(); string Showtime = clsShowMessage.MSG_029 + timei.ToString(); bgWorker.ReportProgress(clsConstant.Thread_Progress_OK, clsShowMessage.MSG_009 + "\r\n" + Showtime); }
private void InitializeDataSource() { Results = new List <xmlDataSources>(); clsAllnew BusinessHelp = new clsAllnew(); string start_time = clsCommHelp.objToDateTime1(dateTimePicker1.Text); string end_time = clsCommHelp.objToDateTime1(dateTimePicker2.Text); string Rack_ID = this.comboBox1.Text; if (Rack_ID == "所有") { Rack_ID = ""; } Results = BusinessHelp.findXML_Server(this.keywordTextBox.Text, start_time, end_time, Rack_ID); //if (Result) var q = (from o in Results orderby o.Rack_ID descending select o); this.dataGridView1.AutoGenerateColumns = false; sortablePendingOrderList = new SortableBindingList <xmlDataSources>(q.ToList()); this.bindingSource1.DataSource = sortablePendingOrderList; // this.dataGridView1.DataSource = null; // this.bindingSource1.Sort = "Rack_ID ASC"; this.dataGridView1.DataSource = this.bindingSource1; toolStripLabel2.Text = "条目:" + Results.Count.ToString(); }
protected void btsearch_Click1(object sender, EventArgs e) { if (this.txrearchNAME.Text != "" || this.txrearchID.Text != "") { BusinessHelp = new clsAllnew(); BusinessHelp.rev_servename = servename; gohome(); readCards = new List <clCard_info>(); string conditions = "select * from t_Item_3002 where ";//成功 int DSD = 0; if (txrearchNAME.Text.Length > 0) { DSD++; conditions += " FName like '%" + txrearchNAME.Text + "%'"; } if (txrearchID.Text.Length > 0 && DSD > 0) { conditions += " AND F_104 like '%" + txrearchID.Text + "%'"; } if (txrearchID.Text.Length > 0 && DSD == 0) { conditions += "F_104 like '%" + txrearchID.Text + "%'"; } readCards = BusinessHelp.Readt_ItemServer(conditions); InitialSystemInfo(); } }
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0 || e.ColumnIndex == 0) { return; } if (RowRemark >= dataGridView1.RowCount || RowRemark == -1) { return; } var row = dataGridView1.Rows[e.RowIndex]; var model = row.DataBoundItem as xmlDataSources; List <xmlDataSources> updateResults = new List <xmlDataSources>(); if (model.Id != null && model.Id != "") { updateResults.Add(model); } clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.update_OrderServer(updateResults); InitializeDataSource(); }
public frmDataCenter() { InitializeComponent(); InitialSystemInfo(); ProcessLogger.Fatal("07932:System Login Start " + DateTime.Now.ToString()); clsAllnew BusinessHelp = new clsAllnew(); List <xmlDataSources> StatusResults = BusinessHelp.findALLStatus_Server(); ProcessLogger.Fatal("07935:System Login successful mapping data Start " + DateTime.Now.ToString()); var nations = StatusResults.Select(o => new MockEntity { ShortName = o.Rack_ID, FullName = o.Rack_ID }).ToList(); nations.Insert(0, new MockEntity { ShortName = "", FullName = "所有" }); this.comboBox1.DisplayMember = "FullName"; this.comboBox1.ValueMember = "ShortName"; this.comboBox1.DataSource = nations; if (backgroundWorker1.IsBusy != true) { backgroundWorker1.RunWorkerAsync(new WorkerArgument { OrderCount = 0, CurrentIndex = 0 }); } }
private void Read_order() { string strSelect = "select * from JNOrder_log where Input_Date>='" + startAt.ToString("yyyy/MM/dd") + "'" + "and " + "Input_Date<='" + endAt.ToString("yyyy/MM/dd") + "'"; if (txfind.Length > 0) { strSelect += " And product_no like '%" + txfind + "%'";//4、工作日志的内容查找,现在是按供应商查找,(查找供应商改为查找型号) if (txfind == "所有") { strSelect = "select * from JNOrder_log"; } } else { strSelect = "select * from JNOrder_log"; } strSelect += " order by Log_id desc"; clsAllnew BusinessHelp = new clsAllnew(); Loglist_Server = new List <clsLog_info>(); Loglist_Server = BusinessHelp.findLog(strSelect); }
private void btlogin_Click(object sender, EventArgs e) { #region Noway DateTime oldDate = DateTime.Now; DateTime dt3; string endday = DateTime.Now.ToString("yyyy/MM/dd"); dt3 = Convert.ToDateTime(endday); DateTime dt2; dt2 = Convert.ToDateTime("2018/08/08"); TimeSpan ts = dt2 - dt3; int timeTotal = ts.Days; if (timeTotal < 0) { MessageBox.Show("运行期已到,请将剩余费用付清 !"); return; } // MessageBox.Show("当前为测试系统 !"); #endregion if (txkey.Text == "") { MessageBox.Show("请写入密钥,然后重试"); return; } clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.ReadWeb_Report(txkey.Text); MessageBox.Show("login OK !", "Right", MessageBoxButtons.OK, MessageBoxIcon.Information); }
private void button1_Click(object sender, EventArgs e) { try { read(); clsAllnew BusinessHelp = new clsAllnew(); int ISURN = BusinessHelp.create_customer_Server(userlist_Server); if (ISURN == 1) { if (MessageBox.Show(" 客户创建成功 , 是否继续添加 ?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { clear(); } else { this.Close(); } } if (ISURN == 0) { MessageBox.Show("客户创建失败,请检查是否录入有误!"); } } catch (Exception ex) { return; throw; } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show(" 确认删除这条信息 , 继续 ?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { } else { return; } var oids = GetOrderIdsBySelectedGridCell(); for (int j = 0; j < oids.Count; j++) { var filtered = Orderinfolist_Server.FindAll(s => s.Item_ID == oids[j]); clsAllnew BusinessHelp = new clsAllnew(); //批量删 int istu = BusinessHelp.deleteitem(filtered[0].Item_ID.ToString()); for (int i = 0; i < filtered.Count; i++) { //单个删除 if (filtered[i].Item_ID != 0) { Orderinfolist_Server.Remove(Orderinfolist_Server.Where(o => o.Item_ID == filtered[i].Item_ID).Single()); } if (istu != 1) { MessageBox.Show("删除失败,请查看" + filtered[i].zhenghao + filtered[i].xingming, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } BindDataGridView(); }
private void Confirm_newCardNO(out string newaddno, out int FItemID) { btReadcard_server_Click(null, EventArgs.Empty); BusinessHelp = new clsAllnew(); BusinessHelp.rev_servename = servename; gohome(); if (readCards == null) { readCards = new List <clCard_info>(); } readCards.Sort(new China_System.Common.clsCommHelp.Comp()); #region 新的员工号 string qi = DateTime.Now.ToString("yyyyMMddss"); if (readCards == null || readCards.Count == 0) { qi = DateTime.Now.ToString("yyyyMMddss"); } else { //ClaimReport_Server.Sort(new Comp()); qi = System.Text.RegularExpressions.Regex.Replace(readCards[0].daima_gonghao, @"[^0-9]+", ""); } int a = Convert.ToInt32(qi) + 1; newaddno = readCards[0].daima_gonghao.Replace(qi, "") + a.ToString(); readCards.Sort(new China_System.Common.clsCommHelp.Comp1()); FItemID = Convert.ToInt32(readCards[0].Order_id) + 1; #endregion }
private void CheckCaseList(object sender, DoWorkEventArgs e) { try { //初始化信息 clsAllnew BusinessHelp = new clsAllnew(); DateTime oldDate = DateTime.Now; foreach (clsDATAinfo item in Orderinfolist_Server) { if (item.xingming != null && item.xingming != "") { BusinessHelp.ReplaceToExcel(ref this.bgWorker, item, prc_folderpath); } //rdlc 打印 //BusinessHelp.Run(item, prc_folderpath); } DateTime FinishTime = DateTime.Now; TimeSpan s = DateTime.Now - oldDate; string timei = s.Minutes.ToString() + ":" + s.Seconds.ToString(); string Showtime = clsShowMessage.MSG_029 + timei.ToString(); bgWorker.ReportProgress(clsConstant.Thread_Progress_OK, clsShowMessage.MSG_031 + "\r\n" + Showtime); } catch (Exception ex) { MessageBox.Show("12320" + ex); return; throw; } }
public frmlogin() { InitializeComponent(); aboutbox = new frmAboutBox(); InitialSystemInfo(); #region 引用皮肤 //se = new Sunisoft.IrisSkin.SkinEngine(); //se.SkinAllForm = true; //se.SkinFile = Path.Combine(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ""), "PageColor1.ssk"); #endregion InitialPassword(); ProcessLogger.Fatal("login" + DateTime.Now.ToString()); //messages = new List<string>(); //messages.Add("欢迎使用彩票号码自动推荐管理系统 " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); //messages.Add("主界面的左侧一排按键是操作历史信息 "); //timer1.Interval = 12000; //timer1.Start(); //timer1.Tick += timer1_Tick; clsAllnew BusinessHelp = new clsAllnew(); bool isve = BusinessHelp.read_sqlitefile(); if (isve == false) { copydb_file(); } }
private void 除ToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show(" 确认删除这条信息 , 继续 ?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { } else { return; } var oids = GetOrderIdsBySelectedGridCell(); for (int j = 0; j < oids.Count; j++) { var filtered = customerinfolist_Server.FindAll(s => s.customer_id == oids[j]); clsAllnew BusinessHelp = new clsAllnew(); //批量删 int istu = BusinessHelp.deletecustomer(filtered[0].customer_id.ToString()); for (int i = 0; i < filtered.Count; i++) { //单个删除 customerinfolist_Server.Remove(customerinfolist_Server.Where(o => o.customer_id == filtered[i].customer_id).Single()); if (istu != 1) { MessageBox.Show("删除失败,请查看" + filtered[i].customer_adress + filtered[i].customer_name, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { // if (!IsPostBack) { BusinessHelp = new clsAllnew(); List <cls_order_info> AddreadCards = new List <cls_order_info>(); cls_order_info item = new cls_order_info(); item.PotNo = ((TextBox)(gvList.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim(); item.DDate = ((TextBox)(gvList.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); item.AlCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim(); item.Lsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim(); item.Djzsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim(); item.Djwd = ((TextBox)(gvList.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim(); item.Fzb = ((TextBox)(gvList.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim(); item.FeCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim(); item.SiCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim(); item.AlOCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[9].Controls[0])).Text.ToString().Trim(); item.CaFCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString().Trim(); item.MgCnt = ((TextBox)(gvList.Rows[e.RowIndex].Cells[11].Controls[0])).Text.ToString().Trim(); item.LDYJ = ((TextBox)(gvList.Rows[e.RowIndex].Cells[12].Controls[0])).Text.ToString().Trim(); item.MLsp = ((TextBox)(gvList.Rows[e.RowIndex].Cells[13].Controls[0])).Text.ToString().Trim(); item.LPW = ((TextBox)(gvList.Rows[e.RowIndex].Cells[14].Controls[0])).Text.ToString().Trim(); item.Order_id = gvList.DataKeys[e.RowIndex].Values[0].ToString(); AddreadCards.Add(item); BusinessHelp.changeCardServer(AddreadCards); gvList.EditIndex = -1; bind(); } }
private void 重置密码ToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show(" 确认重置管理者账号 , 继续 ?", "Info", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { } else { return; } List <clsuserinfo> userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); item.name = "admin"; item.password = "******"; item.Btype = "Normal"; item.AdminIS = "true"; item.jigoudaima = "管理者"; item.Createdate = DateTime.Now.ToString("yyyy/MM/dd/HH"); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.createUser_Server(userlist_Server); MessageBox.Show("初始化用户成功!" + "用户名 :admin 密码 :123", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
protected void btReadcard_server_Click(object sender, EventArgs e) { BusinessHelp = new clsAllnew(); BusinessHelp.rev_servename = servename; gohome(); readCards = new List <cls_order_info>(); //string conditions = "select * from NewMeasueDataTable";//成功 int xuliehao = 0; xuliehao = Select_xuhaolei(xuliehao); string conditions = "select * from NewMeasueDataTable where ";//成功 conditions = SelectSql(xuliehao, conditions); if (!conditions.Contains("DDate")) { return; } readCards = BusinessHelp.Readt_ItemServer(conditions); InitialSystemInfo(); }
private void tabControl1_SelectedIndexChanged(object sender, EventArgs e) { if (this.tabControl1.SelectedIndex == 2) { clsAllnew BusinessHelp = new clsAllnew(); string strSelect = "select * from BuShouDaima"; List <clsbushoudaima_info> ClaimReport_Server = BusinessHelp.find_bushoudaima(strSelect); foreach (clsbushoudaima_info item in ClaimReport_Server) { textBox25.Text = item.shang; this.textBox24.Text = item.xia; this.textBox30.Text = item.zuo; textBox27.Text = item.you; textBox23.Text = item.zhong; textBox31.Text = item.shangzhongxia; this.textBox28.Text = item.zuozhongyou; this.textBox29.Text = item.nei; this.textBox26.Text = item.wai; this.textBox32.Text = item.zuoyou_jiegou; this.textBox33.Text = item.zuoyou_jiegoudaima; this.textBox35.Text = item.shangxia_jiegou; this.textBox34.Text = item.shangxia_jiegoudaima; } } }
private static void gohome1() { clsAllnew BusinessHelp = new clsAllnew(); //if (BusinessHelp.ConStr == null || BusinessHelp.ConStr == null) // Response.Redirect("~/Myadmin/login.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request["type"] != null) { type = Request["type"].ToString(); if (type == "update") { id = Request["id"].ToString(); gongsi = Request["gs"].ToString(); can = new clsAllnew(); userTable ut = can.selectUser().Find(f => f.name.Equals(id) && f.gongsi.Equals(gongsi)); Name.Text = ut.name; Pwd.Text = ut.password; Qrpwd.Text = ut.password; if (ut.AdminIS.Equals("true")) { quanxian.Items[0].Selected = true; } else { quanxian.Items[1].Selected = true; } } } } }
private void CheckCaseList(object sender, DoWorkEventArgs e) { try { Orderinfolist_Server = new List <clsOrderinfo>(); //初始化信息 clsAllnew BusinessHelp = new clsAllnew(); DateTime oldDate = DateTime.Now; Orderinfolist_Server = BusinessHelp.Readexcel(ref this.bgWorker, prc_folderpath); foreach (clsOrderinfo item in Orderinfolist_Server) { item.xinzeng = "true"; string conditions = ""; conditions = sql_yuju(e, item, conditions); int isrun = BusinessHelp.updatecustomer_Server(conditions); item.xinzeng = "false"; } DateTime FinishTime = DateTime.Now; TimeSpan s = DateTime.Now - oldDate; string timei = s.Minutes.ToString() + ":" + s.Seconds.ToString(); string Showtime = clsShowMessage.MSG_029 + timei.ToString(); bgWorker.ReportProgress(clsConstant.Thread_Progress_OK, clsShowMessage.MSG_009 + "\r\n" + Showtime); } catch (Exception ex) { MessageBox.Show("12320" + ex); return; throw; } }
private void button4_Click(object sender, EventArgs e) { userlist_Server = new List <clsuserinfo>(); clsuserinfo item = new clsuserinfo(); if (textBox4.Text == "" || textBox5.Text == "" || textBox6.Text == "") { MessageBox.Show("请填写完整信息然后创建!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (textBox4.Text.Trim() != textBox5.Text.Trim()) { MessageBox.Show("两次输入的用户密码不一致,请重新输入!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } item.name = textBox6.Text.Trim(); item.password = textBox5.Text.Trim(); userlist_Server.Add(item); clsAllnew BusinessHelp = new clsAllnew(); BusinessHelp.changeUserpassword_Server(userlist_Server); MessageBox.Show("密码修改成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); }
private void button1_Click_1(object sender, EventArgs e) { ReadOtherinfo(); if (textBox1.Text != "") { clsAllnew BusinessHelp = new clsAllnew(); string conditions = ""; //conditions = "select * from File_Managerment where wenjianbiaohao like '%" + this.textBox1.Text.ToString() + "%'";//成功 conditions = "select * from File_Managerment where dengjiriqi >= '" + startAt.ToString("MM/dd/yyyy") + "' AND dengjiriqi<='" + endAt.ToString("MM/dd/yyyy") + "'"; if (ioState.Length > 0) { conditions += " And wenjianbiaohao like '%" + ioState + "%'"; } if (nametext.Length > 0) { conditions += " And biaoti like '%" + nametext + "%'"; } xianjinliuJINGE_Result = BusinessHelp.find_File_Managerment(ref this.bgWorker, conditions); ShowDav(); } else { MessageBox.Show("请输入相关查找信息", "查找", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { clsAllnew BusinessHelp = new clsAllnew(); string id = Request.QueryString["id"]; string sql2 = "select * from Detailed where id='" + id + "'"; List <clt_detail_info> readCards = BusinessHelp.Readt_PICServer(sql2); if (readCards.Count > 0 && readCards[0].imagebytes != null) { MemoryStream imageBytes = new MemoryStream(readCards[0].imagebytes); ////System.Drawing.Bitmap image = (Bitmap)BusinessHelp.Base64ToImage(imageBytes); //System.Drawing.Bitmap image = new Bitmap(imageBytes); //System.IO.MemoryStream MStream = new System.IO.MemoryStream(); //image.Save(MStream, System.Drawing.Imaging.ImageFormat.Gif); //Response.ClearContent(); Response.ContentType = "image/Gif"; //Response.BinaryWrite(MStream.ToArray()); Response.BinaryWrite(readCards[0].imagebytes); } } }
private void binddav_combox() { string strSelect = "select * from JNOrder_customer"; strSelect += " order by customer_id desc"; clsAllnew BusinessHelp = new clsAllnew(); customerinfolist_Server = new List<clscustomerinfo>(); customerinfolist_Server = BusinessHelp.findcustomer(strSelect); this.customer_name.DisplayMember = "customer_name"; this.customer_name.ValueMember = "customer_name"; this.customer_name.DataSource = customerinfolist_Server; strSelect = "select * from JNOrder_product"; strSelect += " order by Product_id desc"; List<clsProductinfo> Productinfolist_Server = new List<clsProductinfo>(); Productinfolist_Server = BusinessHelp.findProductr(strSelect); this.Product_no.DisplayMember = "Product_no"; this.Product_no.ValueMember = "Product_no"; this.Product_no.DataSource = Productinfolist_Server; // this.Product_name.DisplayMember = "Product_name"; this.Product_name.ValueMember = "Product_name"; this.Product_name.DataSource = Productinfolist_Server; // //this.Product_salse.DisplayMember = "Product_salse"; //this.Product_salse.ValueMember = "Product_salse"; //this.Product_salse.DataSource = Productinfolist_Server; }