public List <Supper> GetSupperSetList() { List <Supper> lso = new List <Supper>(); string strSQL = "select a.Supper_id,a.Supper_name,b.FORGID,b.FNUMBER FOrgNumber,c.FNAME FOrgName,d.FSUPPLIERID,d.FNUMBER FSUPPLIERNumber ,e.FNAME FSUPPLIERName from tb_SupperSet a " + "inner join T_ORG_ORGANIZATIONS b on a.UserOrg_id = b.FORGID " + "inner join T_ORG_ORGANIZATIONS_L c on a.UserOrg_id = c.FORGID " + "inner join T_BD_SUPPLIER d on a.SUPPLIER_id = d.FSUPPLIERID and d.FUSEORGID = b.FORGID " + "inner join T_BD_SUPPLIER_L e on a.SUPPLIER_id = e.FSUPPLIERID"; using (SqlDataReader sdr = SqlHelper.ExecuteReader(strcon, CommandType.Text, strSQL)) { while (sdr.Read()) { Supper so = new Supper(); so.Supper_id = int.Parse(sdr["Supper_id"].ToString()); so.Supper_name = sdr["Supper_name"].ToString(); so.SUPPLIER_id = int.Parse(sdr["FSUPPLIERID"].ToString()); so.SUPPLIER_Name = sdr["FSUPPLIERName"].ToString(); so.SUPPLIER_Number = sdr["FSUPPLIERNumber"].ToString(); so.UserOrg_id = int.Parse(sdr["FORGID"].ToString()); so.UserOrg_Name = sdr["FOrgName"].ToString(); so.UserOrg_Number = sdr["FOrgNumber"].ToString(); lso.Add(so); } } return(lso); }
private void toolNew_Click(object sender, EventArgs e) { Supper so = new Supper(); FrmSupper fss = new FrmSupper(so, constr); fss.ShowDialog(); fss.Dispose(); }
private void dgSupperSet_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (dgList.CurrentRow.Index > 0) { Supper so = new Supper(); so.Supper_id = int.Parse(dgList.CurrentRow.Cells[0].Value.ToString()); so.Supper_name = dgList.CurrentRow.Cells[1].Value.ToString(); so.SUPPLIER_id = int.Parse(dgList.CurrentRow.Cells[2].Value.ToString()); so.SUPPLIER_Number = dgList.CurrentRow.Cells[3].Value.ToString(); so.SUPPLIER_Name = dgList.CurrentRow.Cells[4].Value.ToString(); so.UserOrg_id = int.Parse(dgList.CurrentRow.Cells[5].Value.ToString()); so.UserOrg_Number = dgList.CurrentRow.Cells[6].Value.ToString(); so.UserOrg_Name = dgList.CurrentRow.Cells[7].Value.ToString(); FrmSupper fss = new FrmSupper(so, constr); fss.ShowDialog(); fss.Dispose(); } }
public bool Add(Supper so) { bool isSuccess = false; try { object IsExists = SqlHelper.ExecuteScalar(strcon, CommandType.Text, "select Supper_name from tb_SupperSet where Supper_id=" + so.Supper_id + " ", null); if (IsExists == null) { int isAdd = SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "insert into tb_SupperSet(Supper_id,Supper_name,UserOrg_id,SUPPLIER_id)values(" + so.Supper_id + ",'" + so.Supper_name + "'," + so.UserOrg_id + "," + so.SUPPLIER_id + ") ", null); isSuccess = true; } } catch { isSuccess = false; } return(isSuccess); }
public bool Alter(Supper so) { bool isSuccess = false; try { object IsExists = SqlHelper.ExecuteScalar(strcon, CommandType.Text, "select Supper_name from tb_SupperSet where Supper_id=" + so.Supper_id + " ", null); if (IsExists != null) { int isAlter = SqlHelper.ExecuteNonQuery(strcon, CommandType.Text, "update tb_SupperSet set Supper_name='" + so.Supper_name + "',UserOrg_id=" + so.UserOrg_id + ",SUPPLIER_id=" + so.SUPPLIER_id + " where Supper_id=" + so.Supper_id + "", null); isSuccess = true; } } catch { isSuccess = false; } return(isSuccess); }
public FrmSupper(Supper ss, string constring) { sso = ss; constr = constring; InitializeComponent(); }