public bool new_VIP(string merchant_id, string client_id, string level) { try { string sql = "insert into client_VIP(merchant_id,client_id,grade) values('" + merchant_id + "','" + client_id + "'," + level + ")"; execute.Do(sql); return(true); } catch (Exception ex) { return(false); } }
public bool insertSupplier(string name, string phone_number, string address) { try { string sql = "insert into supplier(name,phone_number,address) values('" + name + "','" + phone_number + "','" + address + "')"; execute.Do(sql); MessageBox.Show("插入成功。"); return(true); } catch { return(false); } }
public bool insertDeliverOrder(string merchant_id, string order_id, string client_id, string time, string amount, string name, string total_price) { try { string sql = "insert into deliver_order values('" + merchant_id + "','" + order_id + "','" + client_id + "',to_date('" + time + "','yyyy-mm-dd'),'" + Convert.ToInt32(amount) + "','" + name + "','" + Convert.ToInt32(total_price) + "')"; execute.Do(sql); MessageBox.Show("插入成功。"); } catch { MessageBox.Show("插入失败。"); return(false); } return(true); }
public bool insertReceipt(string supplier_id, string batch_number, string merchant_id, string time, string amount, string name, string total_price) { try { string sql = "insert into receipt values('" + supplier_id + "','" + batch_number + "','" + merchant_id + "',to_date('" + time + "','yyyy-mm-dd'),'" + Convert.ToInt32(amount) + "','" + name + "','" + Convert.ToInt32(total_price) + "')"; execute.Do(sql); MessageBox.Show("插入成功。"); } catch { MessageBox.Show("插入失败。"); return(false); } return(true); }
//修改摊位信息 public bool updateStall(string stallID, string merchantID, string staffID, string Area, string startTime, string endTime, string rentMoney) { try { string sqlmerchant = "update stall set merchant_id = '" + merchantID + "' where stall_id = '" + stallID + "'"; string sqlstaff = "update stall set staff_id = '" + staffID + "' where stall_id = '" + stallID + "'"; string sqlarea = "update stall set area = '" + Area + "' where stall_id = '" + stallID + "'"; string sqlstart_time = "update stall set start_time = to_date('" + startTime + "','yyyy-mm-dd') where stall_id = '" + stallID + "'"; string sqlend_time = "update stall set end_time = to_date('" + endTime + "','yyyy-mm-dd') where stall_id = '" + stallID + "'"; string sqlrentMoney = "update stall set rent_money = '" + rentMoney + "' where stall_id = '" + stallID + "'"; execute.Do(sqlmerchant); execute.Do(sqlstaff); execute.Do(sqlarea); execute.Do(sqlstart_time); execute.Do(sqlend_time); execute.Do(sqlrentMoney); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
//添加一条新仓库表项 public bool AddAnEntry(/*string id,*/ double area1, double capacity, string m_id, string s_id) { try { string insert = "insert into warehouse (area, full_capacity, left_capacity, merchant_id, staff_id) values (" + area1.ToString() + "," + capacity.ToString() + "," + capacity.ToString() + ",'" + m_id + "','" + s_id + "')"; execute.Do(insert); MessageBox.Show("Succeed"); //dbcon.Close(); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
//新增商家 public bool addMerchant(string staffID, string Name, string Phone_number) { try { //插入商家信息 string sqlmerchant = "insert into merchant(staff_id,name,phone_number) values('" + staffID + "','" + Name + "','" + Phone_number + "')"; //OracleCommand cmdmerchant = new OracleCommand(sqlmerchant, con); //获得自动分配的商家id string sql = "select merchant_seq.currval from dual"; //OracleCommand cmd = new OracleCommand(sql, con); execute.Do(sqlmerchant); this.merchant_id = select.Do(sql).ToString(); //插入merchant_login string sqlmerchant_login = "******" + this.merchant_id + "',1234,123456789)"; //插入merchant_VIP string sqlmerchant_VIP = "insert into merchant_VIP(merchant_id,grade,discount) values('" + this.merchant_id + "',0,0.99)"; execute.Do(sqlmerchant_login); execute.Do(sqlmerchant_VIP); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool update(string ID, string newpassword) { string result = ""; string esql = "update STAFF_LOGIN set PASSWORD = '******' where STAFF_ID = '" + ID + "'"; string ssql = "select PASSWORD from STAFF_LOGIN where STAFF_ID = '" + ID + "'"; Doexecute b = Doexecute.instance; Doselect a = Doselect.instance; b.Do(esql); result = a.Do(ssql).ToString(); if (result == newpassword) { return(true); } return(false); }
public bool update(string ID, string newpassword) { string result = ""; string esql = "update MERCHANT_LOGIN set PASSWORD = '******' where MERCHANT_ID = '" + ID + "'"; string ssql = "select PASSWORD from MERCHANT_LOGIN where MERCHANT_ID = '" + ID + "'"; Doexecute b = Doexecute.instance; //Doexecute b1 = Doexecute.instance; //if (b == b1) Console.WriteLine("the same again!!"); Doselect a = Doselect.instance; b.Do(esql); result = a.Do(ssql).ToString(); if (result == newpassword) { return(true); } return(false); }
public bool addlead(string dept_name, string staff_id)//新增lead表 { try { string sql2 = "select dept_name from staff where staff_id='" + staff_id + "'"; string deptname = select.Do(sql2).ToString(); if (deptname == dept_name) { string sql = "update leading set dept_head='" + staff_id + "' where dept_name='" + dept_name + "'"; execute.Do(sql); return(true); } else { return(false); } } catch { return(false); } }
//修改表项时前后仓库ID相同时使用此方法 public bool UpdateWhenIDSame(string merchant_id, string old_supplier_id, string old_batch_number, string old_id_in_batch, double new_amount) { //string db = " DATA SOURCE=localhost:1521/orcl2;USER ID=scott; password = 1234"; //OracleConnection dbcon = new OracleConnection(db); //dbcon.Open(); string selectOldAmount = "select amount from merchandise where merchant_id = '" + merchant_id + "' and supplier_id = '" + old_supplier_id + "' and batch_number = '" + old_batch_number + "' and id_in_batch = '" + old_id_in_batch + "'"; //OracleCommand cmd = new OracleCommand(selectOldAmount, dbcon); //double old_amount = Convert.ToDouble(cmd.ExecuteScalar()); double old_amount = Convert.ToDouble(select.Do(selectOldAmount)); double change_amount = new_amount - old_amount; string selectOldWarehouseID = "select warehouse_id from merchandise where merchant_id = '" + merchant_id + "' and supplier_id = '" + old_supplier_id + "' and batch_number = '" + old_batch_number + "' and id_in_batch = '" + old_id_in_batch + "'"; // OracleCommand cmd1 = new OracleCommand(selectOldWarehouseID, dbcon); // string old_warehouse_id = cmd1.ExecuteScalar().ToString(); string old_warehouse_id = select.Do(selectOldWarehouseID).ToString(); string selectOldLeftCapacity = "select left_capacity from warehouse where warehouse_id = '" + old_warehouse_id + "'"; //OracleCommand cmd2 = new OracleCommand(selectOldLeftCapacity, dbcon); //double old_left_capacity = Convert.ToDouble(cmd2.ExecuteScalar()); double old_left_capacity = Convert.ToDouble(select.Do(selectOldLeftCapacity)); double changed_left_capacity = old_left_capacity - change_amount; if (changed_left_capacity >= 0) { string updateOldLeftCapacity = "update warehouse set left_capacity = " + changed_left_capacity.ToString() + " where warehouse_id = '" + old_warehouse_id + "'"; //OracleCommand cmd3 = new OracleCommand(updateOldLeftCapacity, dbcon); //cmd3.ExecuteNonQuery(); execute.Do(updateOldLeftCapacity); //dbcon.Close(); //MessageBox.Show("仓库剩余容量修改成功!"); return(true); } else { //dbcon.Close(); MessageBox.Show("仓库剩余容量不足!"); return(false); } }
//新增员工 public bool addStaff(string Name, string Age, string Sex, string Phone_number, string Salary, string Dept_name) { try { //string s = "DATA SOURCE=localhost:1521/orcl2;USER ID=scott; password = 1234"; //OracleConnection con = new OracleConnection(s); //con.Open(); //插入商家信息 string sqlstaff = "insert into staff(name,age,sex,phone_number,salary,dept_name) values('" + Name + "','" + Age + "','" + Sex + "','" + Phone_number + "','" + Salary + "','" + Dept_name + "')"; //OracleCommand cmdstaff = new OracleCommand(sqlstaff, con); //cmdstaff.ExecuteNonQuery(); execute.Do(sqlstaff); //获得自动分配的商家id if (Dept_name == "Material_Ctrl_Dept") { string sql = "select staff_id from staff where phone_number = '" + Phone_number + "'"; //OracleCommand cmd = new OracleCommand(sql, con); //cmdstaff.ExecuteNonQuery(); //this.staff_id = cmd.ExecuteScalar().ToString(); this.staff_id = select.Do(sql).ToString(); } else if (Dept_name == "Personal_Adm_Dept") { string sql = "select staff_id from staff where phone_number = '" + Phone_number + "'"; //OracleCommand cmd = new OracleCommand(sql, con); // cmdstaff.ExecuteNonQuery(); //this.staff_id = cmd.ExecuteScalar().ToString(); this.staff_id = select.Do(sql).ToString(); } else if (Dept_name == "Stall_Mgt_Dept") { string sql = "select staff_id from staff where phone_number = '" + Phone_number + "'"; //OracleCommand cmd = new OracleCommand(sql, con); //cmdstaff.ExecuteNonQuery(); //this.staff_id = cmd.ExecuteScalar().ToString(); this.staff_id = select.Do(sql).ToString(); } else if (Dept_name == "Merchant_Mgt_Dept") { string sql = "select staff_id from staff where phone_number = '" + Phone_number + "'"; //OracleCommand cmd = new OracleCommand(sql, con); //cmdstaff.ExecuteNonQuery(); //this.staff_id = cmd.ExecuteScalar().ToString(); this.staff_id = select.Do(sql).ToString(); } //插入merchant_login string sqlstaff_login = "******" + this.staff_id + "',2234,223456789)"; //OracleCommand cmdlogin = new OracleCommand(sqlstaff_login, con); //cmdlogin.ExecuteNonQuery(); //con.Close(); execute.Do(sqlstaff_login); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }