public static List <Clases.EFormula> Lee_Formula(string Receta)
{
List <Clases.EFormula> ii_LEFormula = new List <Clases.EFormula>();
Clases.EFormula ii_EFormula = new Clases.EFormula();
DataSet DS = new DataSet();
string Error = "";
string sql = " SELECT * from Formula_receta WHERE id_receta_fr = '" + Receta + "'";
DS = funciones.EjecutaSQL(sql, ref Error);
if (DS.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < DS.Tables[0].Rows.Count; i++)
{
ii_EFormula = new Clases.EFormula();
ii_EFormula.ID_Receta = DS.Tables[0].Rows[i]["id_receta_fr"].ToString();
ii_EFormula.ID_Articulo = DS.Tables[0].Rows[i]["id_articulo_fr"].ToString();
ii_EFormula.id_unidad = DS.Tables[0].Rows[i]["id_unidad_fr"].ToString();
ii_EFormula.cantidad = decimal.Parse(DS.Tables[0].Rows[i]["cant_art_fr"].ToString());
ii_EFormula.obligatorio = DS.Tables[0].Rows[i]["no_sust_art_fr"].ToString();
ii_LEFormula.Add(ii_EFormula);
}
return(ii_LEFormula);
}
return(null);
}
bool Inserta_Formula()
{
string Error = "";
List <Clases.EFormula> aa_LEFormulaAseg = new List <Clases.EFormula>();
Clases.EFormula aa_EPlanAseg = new Clases.EFormula();
for (int ii = 0; ii < dataGridView1.RowCount - 1; ii++)
{
aa_EPlanAseg = new Clases.EFormula();
aa_EPlanAseg.ID_Receta = tid.Text;
aa_EPlanAseg.ID_Articulo = dataGridView1.Rows[ii].Cells[0].Value.ToString().Trim();
aa_EPlanAseg.id_unidad = dataGridView1.Rows[ii].Cells[2].Value.ToString().Trim();
aa_EPlanAseg.cantidad = decimal.Parse(dataGridView1.Rows[ii].Cells[3].Value.ToString().Trim());
bool obligatorio = Convert.ToBoolean(dataGridView1.Rows[ii].Cells[4].Value);
if (obligatorio)
{
aa_EPlanAseg.obligatorio = "X";
}
aa_LEFormulaAseg.Add(aa_EPlanAseg);
}
if (funciones.Inserta_Formula(aa_LEFormulaAseg, ref Error))
{
return(true);
}
else
{
if (!string.IsNullOrWhiteSpace(Error.Trim()))
{
MessageBox.Show(Error.ToString().Trim());
}
}
return(false);
}