// 确认修改
private void button2_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确认修改 ？ ", "提示", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
BillPO billPO = new BillPO();
billPO.Billid = textBox1.Text;
//billPO.GuestName = comboBox1.SelectedItem.ToString();
billPO.Xinghao = comboBox2.SelectedItem.ToString();
billPO.Zhonglei = comboBox3.SelectedItem.ToString();
billPO.Color = textBox10.Text;
billPO.Num = Convert.ToInt32(textBox3.Text);
billPO.SinglePrice = Convert.ToDouble(textBox4.Text);
billPO.TotalPrice = Convert.ToDouble(textBox4.Text) * Convert.ToDouble(textBox3.Text);
billPO.OtherText = textBox9.Text;
MysqlManager manager = new MysqlManager();
int result = manager.UpdateBill(billPO);
if (result == 1)
{
MessageBox.Show("修改成功 ！");
}
else
{
MessageBox.Show("修改失败！");
}
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Guest guest = new Guest();
guest.Name = textBox1.Text;
if (textBox1.Text == "")
{
MessageBox.Show("用户名不为空");
}
else
{
MysqlManager mysqlManager = new MysqlManager();
int result = mysqlManager.deleteGuest(guest);
if (result != 1)
{
MessageBox.Show("删除失败");
}
else
{
MessageBox.Show("删除用户成功");
}
this.Close();
}
}
private void buttonDelete()
{//同时有两个reader或manager或出错，得先close一个，拆开来就会很麻烦
Debug.Log("buttonDelete");
mysqlManager = new MysqlManager();
MySqlDataReader reader = mysqlManager.SelectFrom("select ID from People where type = '" + SelectedOption + "'");
int i = 0, count = Convert.ToInt32(inputFieldNum.text);
int[] num = new int[count];//用来保存ID串
while (reader.Read())
{
if (i == count)
{
break;
}
num[i++] = reader.GetInt32(0);
}
reader.Close();
mysqlManager = new MysqlManager();
for (int j = 0; j < i; j++)
{
mysqlManager.DeleteFrom("People", num[j]);
}
if (count > i)
{
Debug.Log("输入数字过大，库中删除数据不足");
}
//reader.Close();
mysqlManager.Close();
}
private void OnButtonClicked(Button item)
{
MysqlManager mysqlManager = new MysqlManager();
//下拉框显示数据库内容
Debug.Log("你按下了：" + item.name);
switch (item.name)
{
case "menu":
gamObject.SetActive(true);
break;
case "menuclose":
gamObject.SetActive(false);
break;
case "add":
string str = "'" + peo_name.text + "'," + type.text + ",'" + home.text + ",'" + company.text + "'," + loc1.text + ",'" + loc2.text + "'," + loc3.text;
mysqlManager.InsertInto("People", "`name`,`type`,`home`,`company`,`loc1`,`loc2`,`loc3`", str);
break;
case "update":
str = "set name=" + peo_name.text + " type=" + type.text + " home=" + home.text + " company=" + company.text + " loc1=" + loc1.text + " loc2=" + loc2.text + " loc3=" + loc3.text;
mysqlManager.UpdateSet("People", str, int.Parse(id.text)); //未测试
break;
case "delete":
mysqlManager.DeleteFrom("People", int.Parse(id.text));
break;
}
}
//// 仅输入汉字
//private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
//{
// Regex rg = new Regex("^[\u4e00-\u9fa5]$");
// if (!rg.IsMatch(e.KeyChar.ToString()) && e.KeyChar != '\b') //'\b'是退格键
// {
// e.Handled = true;
// }
//}
// 确定按钮
private void button1_Click(object sender, EventArgs e)
{
Guest guest = new Guest();
guest.Name = textBox1.Text;
guest.Tel = textBox2.Text;
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("检查客户名 电话 是否输入为空");
}
else
{
MysqlManager mysqlManager = new MysqlManager();
Boolean f = mysqlManager.checkGuest(guest.Name);
if (!f)
{
MessageBox.Show("客户名已存在，请更换其他标识");
}
else
{
int result = mysqlManager.insertGuest(guest);
if (result != 1)
{
MessageBox.Show("插入失败");
}
else
{
MessageBox.Show("添加用户成功");
}
}
this.Close();
}
}
void Start()
{
mysqlManager = new MysqlManager();
MySqlDataReader reader = mysqlManager.SelectFrom("select type from JobLoc");
List <string> DropOptions = new List <string>();
while (reader.Read())//将数据库读取到的每一条加到下拉框里
{
int count = reader.FieldCount;
SelectedOption = reader.GetString(0);//给变量赋初值
for (int i = 0; i < count; i++)
{
string key = reader.GetString(i);
DropOptions.Add(key);
}
}
dDown.AddOptions(DropOptions);
//添加监听器,下拉表里选项被点击时触发
dDown.GetComponent <Dropdown>().onValueChanged.AddListener(ConsoleResult);
reader.Close();
mysqlManager.Close();
ButtonAdd.onClick.AddListener(buttonAdd);
ButtonDelete.onClick.AddListener(buttonDelete);
}
public virtual int GetCount(string query = "")
{
var sql = "SELECT COUNT(1) AS CNT FROM MySql WHERE 1=1 " + query;
var result = MysqlManager <MySql> .ExecuteScalar(sql);
return(Convert.ToInt32(result));
}
protected void submitInput_Click(object sender, EventArgs e)
{
if (Request.Form.Get("userID") != null && Request.Form.Get("userID").ToString() != "")
{
string userId = Request.Form.Get("userID").ToString();
string passWd = Request.Form.Get("userPassword").ToString();
MysqlManager manager = new MysqlManager();
int loginJ = manager.testUserTrue(userId, passWd);
if (loginJ != -1)
{
//Response.Write("<script>alert('" + "userId: " + Request.Cookies["userId"].Value + "');</script>");
if (loginJ == 0)
{
DataManager data = new DataManager("i");
Response.Cookies["userId"].Value = userId;
string strcode = data.selectUserNameFromId(userId);
string userNameFromUtf8 = Encoding.UTF8.GetString(Encoding.UTF8.GetBytes(strcode));
Response.Cookies["nickName"].Value = userNameFromUtf8;
Response.Cookies["passWd"].Value = passWd;
Response.Redirect("index.html");
Response.Write(new ShowMessageBox("欢迎您," + userNameFromUtf8 + ".").Text);
}
else
{
Response.Redirect("Default.aspx?user=xuhao");
Response.Write(new ShowMessageBox("管理员登录成功,即将转到管理员页面...").Text);
}
}
else
{
Response.Write(new ShowMessageBox("登录失败,请检查输入是否正确...").Text);
}
}
}
private void Start()
{
//连接数据库
MysqlManager manager = new MysqlManager("localhost", "3306", "root", "password", "player");
manager.OpenMysql();
//创建数据表
string[] col = new string[2];
col[0] = "name";
col[1] = "age";
string[] colType = new string[2];
colType[0] = "varchar(100)";
colType[1] = "varchar(100)";
//manager.UseDatabase("player");
//manager.CreateTableAutoIncremID("info2", col, colType);
//插入一组数据
string[] values = new string[3];
values[0] = "0";
values[1] = Random.Range(0, 1000).ToString();
values[2] = Random.Range(0, 1000).ToString();
//manager.InsertDataToTable("info2", values);
//更新数据
//manager.UpdateDataAtTable("info2", "name", "2222", "id", "1");
manager.SelectDataAtTable("info2");
//manager.DeleteDataAtTable("info2", "id", "1");
//删除数据表
//manager.DropTable("info");
manager.CloseMysql();
}
void add_op()//增
{
mysqlManager = new MysqlManager();
string str = "'" + peo_name.text + "','" + type.text + "','" + home.text + "','" + company.text + "','" + loc1.text + "','" + loc2.text + "','" + loc3.text + "','0'";
mysqlManager.InsertInto("People", "name,type,home,company,loc1,loc2,loc3,infected", str);
mysqlManager.Close();
}
private void update_op()//改
{
mysqlManager = new MysqlManager();
String str = "set `name`='" + peo_name.text + "',`type`='" + type.text + "',`home`='" + home.text + "',`company`='" + company.text + "',`loc1`='" + loc1.text + "',`loc2`='" + loc2.text + "',`loc3`='" + loc3.text + "'";
mysqlManager.UpdateSet("People", str, int.Parse(id.text));
mysqlManager.Close();
}
public virtual List <MySql> SelectPaging(int start = 0, int end = 10, string query = "", string listcolumn = "")
{
var sql = string.Format(@"SELECT * FROM MySql WHERE 1=1 {0} LIMIT @start, @end;", query);
if (!string.IsNullOrEmpty(listcolumn))
{
sql = sql.Replace("*", listcolumn);
}
return(MysqlManager <MySql> .ExecuteReader(sql, new { start = start, end = end }));
}
// 条件查询
private void materialRaisedButton2_Click(object sender, EventArgs e)
{
String str = null;
MysqlManager mysqlManager = new MysqlManager();
String zhonglei = comboBoxZhonglei.SelectedItem.ToString();
String xinghao = comboBoxXinghao.SelectedItem.ToString();
String color = comboBox1color.SelectedItem.ToString();
String guestName = comboBoxUserName.SelectedItem.ToString();
String starttime = dateTimePicker1.Value.ToString("yyyy-MM-dd");
//String s = dateTimePicker1.Value.ToShortDateString();
String endtime = dateTimePicker2.Value.ToString("yyyy-MM-dd");
str = "SELECT billid as '单据编号', guestName as '顾客名称',xinghao as '型号',zhonglei as '种类',color as '颜色',num as '数量',singlePrice as '单价',totalPrice as '总金额',kaipiaoDate as '开票日期',otherText as '备注' from orderlist where ";
str += "DATE_FORMAT( kaipiaoDate, '%Y-%m-%d') >= '" + starttime + "' and DATE_FORMAT( kaipiaoDate, '%Y-%m-%d') <= '" + endtime + "'";
if (zhonglei != "所有种类")
{
str += "and zhonglei='" + zhonglei + "'";
}
if (xinghao != "所有型号")
{
str += "and xinghao='" + xinghao + "'";
}
if (color != "所有颜色")
{
str += "and color='" + color + "'";
}
if (guestName != "所有客户")
{
str += "and guestName='" + guestName + "'";
}
str += ";";
dt = mysqlManager.getOrderlist(str);
double temp = 0.0;
int num_temp = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
temp += Double.Parse(dt.Rows[i]["总金额"].ToString());
num_temp += Int32.Parse(dt.Rows[i]["数量"].ToString());
}
dataGridView1.DataSource = dt;
dataGridView1.Update();
textBox3.Text = guestName;
textBox4.Text = zhonglei;
textBox5.Text = xinghao;
textBox6.Text = color;
textBox7.Text = starttime;
textBox8.Text = endtime;
textBox9.Text = dt.Rows.Count.ToString();
textBox10.Text = temp.ToString();
textBox11.Text = num_temp.ToString();
}
public virtual int Delete(int ID = 0)
{
var sql = "DELETE FROM MySql ";
if (ID == 0)
{
return(MysqlManager <MySql> .Execute(sql));
}
sql += " WHERE ID=@ID ";
return(MysqlManager <MySql> .Execute(sql, new { ID = ID }));
}
// 确认修改
private void button2_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("确认删除 ？ ", "提示", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
MysqlManager manager = new MysqlManager();
manager.DeleteBill(textBox1.Text);
MessageBox.Show("删除成功 ！");
this.Close();
}
}
private void ChooseGuest_Load(object sender, EventArgs e)
{
comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
MysqlManager manager = new MysqlManager();
DataTable table = manager.getGuestNames();
String[] guests = new string[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
comboBox1.Items.Add(table.Rows[i]["name"]);
}
}
// 页面加载时 加载查询的数据
private void UpdateBill_Load(object sender, EventArgs e)
{
xinghao = ConfigHelper.GetAppConfig("xinghao");
zhonglei = ConfigHelper.GetAppConfig("zhonglei");
color = ConfigHelper.GetAppConfig("color");
//comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox2.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox3.DropDownStyle = ComboBoxStyle.DropDownList;
//comboBox4.DropDownStyle = ComboBoxStyle.DropDownList;
String[] xinghaos = xinghao.Split('.');
String[] zhongleis = zhonglei.Split('.');
String[] colors = color.Split('.');
// 从数据库读取用户
MysqlManager manager = new MysqlManager();
//DataTable table = manager.getGuestNames();
//String[] guests = new string[table.Rows.Count];
//for (int i = 0; i < table.Rows.Count; i++)
//{
// comboBox1.Items.Add(table.Rows[i]["name"]);
//}
for (int i = 0; i < xinghaos.Length; i++)
{
comboBox2.Items.Add(xinghaos[i]);
}
for (int i = 0; i < zhongleis.Length; i++)
{
comboBox3.Items.Add(zhongleis[i]);
}
//for (int i = 0; i < colors.Length; i++)
//{
// comboBox4.Items.Add(colors[i]);
//}
// 表单填上原来的值
BillPO bill = manager.getBillPObyBillid(billid);
textBox1.Text = bill.Billid;
//comboBox1.SelectedIndex = comboBox1.FindString(bill.GuestName);
comboBox2.SelectedIndex = comboBox2.FindString(bill.Xinghao);
comboBox3.SelectedIndex = comboBox3.FindString(bill.Zhonglei);
//comboBox4.SelectedIndex = comboBox4.FindString(bill.Color);
textBox10.Text = bill.Color.ToString();
textBox3.Text = bill.Num.ToString();
textBox4.Text = bill.SinglePrice.ToString();
textBox5.Text = bill.TotalPrice.ToString();
textBox9.Text = bill.OtherText;
}
public Form1()
{
InitializeComponent();
// Initialize MaterialSkinManager
materialSkinManager = MaterialSkinManager.Instance;
materialSkinManager.AddFormToManage(this);
materialSkinManager.Theme = MaterialSkinManager.Themes.LIGHT;
materialSkinManager.ColorScheme = new ColorScheme(Primary.LightBlue900, Primary.LightBlue900, Primary.Blue900, Accent.Blue700, TextShade.WHITE);
MysqlManager.SettingConnectStr();
flushDGW();
init();
asc.controllInitializeSize(this);
}
// 加载 config 文件内容
private void NewBill_Load(object sender, EventArgs e)
{
xinghao = ConfigHelper.GetAppConfig("xinghao");
zhonglei = ConfigHelper.GetAppConfig("zhonglei");
color = ConfigHelper.GetAppConfig("color");
comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox2.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox3.DropDownStyle = ComboBoxStyle.DropDownList;
textBox11.Text = form1.preColor;
// 从数据库读取用户
MysqlManager manager = new MysqlManager();
DataTable table = manager.getGuestNames();
String[] guests = new string[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
comboBox1.Items.Add(table.Rows[i]["name"]);
}
if (form1.selectindex == -1)
{
MessageBox.Show("您还没有完成 选择用户 功能");
}
else
{
// 之前选好用户；
comboBox1.SelectedIndex = form1.selectindex;
}
String[] xinghaos = xinghao.Split('.');
String[] zhongleis = zhonglei.Split('.');
String[] colors = color.Split('.');
for (int i = 0; i < xinghaos.Length; i++)
{
comboBox2.Items.Add(xinghaos[i]);
}
for (int i = 0; i < zhongleis.Length; i++)
{
comboBox3.Items.Add(zhongleis[i]);
}
textBox2.Text = "米 / 码";
textBox6.Text = "硕麒拉链码庄订单管理系统";
textBox7.Text = "无";
textBox8.Text = "无";
}
public SelectGuest(Form1 form)
{
InitializeComponent();
comboBox1.DropDownStyle = ComboBoxStyle.DropDownList;
// 从数据库读取用户
MysqlManager manager = new MysqlManager();
DataTable table = manager.getGuestNames();
String[] guests = new string[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
comboBox1.Items.Add(table.Rows[i]["name"]);
}
form1 = form;
}
// 填充条件查询的数据
public void init()
{
comboBoxUserName.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxXinghao.DropDownStyle = ComboBoxStyle.DropDownList;
comboBoxZhonglei.DropDownStyle = ComboBoxStyle.DropDownList;
comboBox1color.DropDownStyle = ComboBoxStyle.DropDownList;
xinghao = ConfigHelper.GetAppConfig("xinghao");
zhonglei = ConfigHelper.GetAppConfig("zhonglei");
color = ConfigHelper.GetAppConfig("color");
// 从数据库读取用户
MysqlManager manager = new MysqlManager();
DataTable table = manager.getGuestNames();
String[] guests = new string[table.Rows.Count];
comboBoxUserName.Items.Add("所有客户");
comboBoxXinghao.Items.Add("所有型号");
comboBoxZhonglei.Items.Add("所有种类");
comboBox1color.Items.Add("所有颜色");
comboBoxUserName.SelectedIndex = 0;
comboBoxXinghao.SelectedIndex = 0;
comboBoxZhonglei.SelectedIndex = 0;
comboBox1color.SelectedIndex = 0;
for (int i = 0; i < table.Rows.Count; i++)
{
comboBoxUserName.Items.Add(table.Rows[i]["name"]);
}
String[] xinghaos = xinghao.Split('.');
String[] zhongleis = zhonglei.Split('.');
String[] colors = color.Split('.');
for (int i = 0; i < xinghaos.Length; i++)
{
comboBoxXinghao.Items.Add(xinghaos[i]);
}
for (int i = 0; i < zhongleis.Length; i++)
{
comboBoxZhonglei.Items.Add(zhongleis[i]);
}
for (int i = 0; i < colors.Length; i++)
{
comboBox1color.Items.Add(colors[i]);
}
}
public virtual List <MySql> Select(int ID = 0, string listcolumn = "")
{
var sql = "SELECT * FROM MySql";
if (!string.IsNullOrEmpty(listcolumn))
{
sql = sql.Replace("*", listcolumn);
}
if (ID == 0)
{
return(MysqlManager <MySql> .ExecuteReader(sql));
}
sql += " WHERE ID=@ID";
return(MysqlManager <MySql> .ExecuteReader(sql, new { ID = ID }));
}
private void button1_Click(object sender, EventArgs e)
{
Color color = new Color();
color.Cid = textBox1.Text;
color.Mcolor = textBox2.Text;
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("检查颜色型号 颜色中文 是否输入正确");
}
else
{
MysqlManager mysqlManager = new MysqlManager();
int result = mysqlManager.insertColor(color);
MessageBox.Show("添加 " + textBox1.Text + "#" + textBox2.Text + " 成功");
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Xinghao xinghao = new Xinghao();
xinghao.Kind = textBox1.Text;
if (textBox1.Text == "")
{
MessageBox.Show("检查型号是否输入正确");
}
else
{
MysqlManager mysqlManager = new MysqlManager();
int result = mysqlManager.insertXinghao(xinghao);
MessageBox.Show("插入型号 " + textBox1.Text + " 成功");
this.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
Zhonglei zhonglei = new Zhonglei();
zhonglei.Color = textBox1.Text;
if (textBox1.Text == "")
{
MessageBox.Show("检查种类是否输入正确");
}
else
{
MysqlManager mysqlManager = new MysqlManager();
int result = mysqlManager.insertZhonglei(zhonglei);
MessageBox.Show("添加种类： " + textBox1.Text + " 成功");
this.Close();
}
}
// 上一页按钮
private void btnPre_Click(object sender, EventArgs e)
{
MysqlManager mysqlManager = new MysqlManager();
int currentCount = (tbm_nowDataMaxIndex % 50 == 0 ? 50 : tbm_nowDataMaxIndex % 50);
DataTable dt = mysqlManager.getOrderInfo(tbm_nowDataMaxIndex - (50 + currentCount));
tbm_nowDataMaxIndex -= currentCount;
dataGridView1.DataSource = dt;
if (tbm_nowDataMaxIndex <= 50)
{
btnPre.Enabled = false;
}
else
{
currIndex--;
}
btnNext.Enabled = true;
labelcount.Text = "第 " + currIndex + " / " + num + " 页";
}
private void addHouse()
{
mysqlManager = new MysqlManager();
double x = Convert.ToDouble(Lx.text); //地图长，默认（学校地图）33.73
double y = Convert.ToDouble(Ly.text); //地图宽，默认（学校地图）36.34
double x1 = Convert.ToDouble(Px.text); //房子左上角坐标（对角线起点）
double y1 = Convert.ToDouble(Py.text);
double w = Convert.ToDouble(Hx.text); //地图上房子长宽
double h = Convert.ToDouble(Hy.text);
//中心点位置坐标
double X = (x1 + w / 2) / x * 300 - 150;
double Y = (y - y1 - h / 2) / y * 300 - 150;
string str = "'" + House.text + "','" + Type.text + "','" + Convert.ToString(X) + "','2','" + Convert.ToString(Y) + "','0','0','0','" + Convert.ToString(w) + "','1','" + Convert.ToString(h) + "'";
mysqlManager.InsertInto("HouseLoc", "House,type,lx,ly,lz,rx,ry,rz,sx,sy,sz", str);
mysqlManager.Close();
}
//刷新文献管理中表格
private void flushDGW()
{
currIndex = 1;
MysqlManager mysqlManager = new MysqlManager();
dt = mysqlManager.getOrderInfo(0); // index = 0~20
tbm_nowDataMaxIndex = dt.Rows.Count;
papersCount = mysqlManager.getOrderCount();
num = papersCount % 50 == 0 ? papersCount / 50 : (papersCount / 50 + 1);
labelcount.Text = "第 " + currIndex + " / " + num + " 页";
dataGridView1.DataSource = dt;
dataGridView1.Update();
btnPre.Enabled = false;
if (tbm_nowDataMaxIndex >= papersCount)
{
btnNext.Enabled = false;
}
}
// 下一页按钮
private void btnNext_Click(object sender, EventArgs e)
{
MysqlManager mysqlManager = new MysqlManager();
DataTable dt = mysqlManager.getOrderInfo(tbm_nowDataMaxIndex);
tbm_nowDataMaxIndex += dt.Rows.Count;
dataGridView1.DataSource = dt;
if (tbm_nowDataMaxIndex <= 20)
{
btnNext.Enabled = false;
}
else
{
currIndex++;
}
btnPre.Enabled = true;
if (currIndex > num)
{
currIndex = num;
}
labelcount.Text = "第 " + currIndex + " / " + num + " 页";
}
// 从datagridview插入订单到数据库
private void materialRaisedButton8_Click(object sender, EventArgs e)
{
MysqlManager manager = new MysqlManager();
DialogResult dr = MessageBox.Show("确认添加订单到数据库 ？ ", "提示", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
DataTable dt = GetDgvToTable(dataGridView2);
if (dt.Rows.Count == 0)
{
MessageBox.Show("没有数据可添加");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
BillPO billPO = new BillPO();
billPO.Billid = dt.Rows[i]["Column1"].ToString();
billPO.GuestName = dt.Rows[i]["Column2"].ToString();
billPO.Xinghao = dt.Rows[i]["Column3"].ToString();
billPO.Zhonglei = dt.Rows[i]["Column4"].ToString();
billPO.Color = dt.Rows[i]["Column5"].ToString();
billPO.Num = Convert.ToInt32(dt.Rows[i]["Column6"]);
billPO.SinglePrice = Convert.ToDouble(dt.Rows[i]["Column7"]);
billPO.TotalPrice = Convert.ToDouble(dt.Rows[i]["Column8"]);
billPO.OtherText = dt.Rows[i]["Column9"].ToString();
billPO.KaipiaoDate = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
billPO.Danwei = "码 / 米";
billPO.Kaipiaor = "硕麒拉链码庄";
billPO.Jinshour = "无";
billPO.PicPath = "无";
billPO.Address = "无";
manager.insertBill(billPO);
}
MessageBox.Show("订单添加成功，请返回首页查看 ！");
}
}
}
