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