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;
}
