public static BUnit Select_ByCodeLocal(int Code)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlDataAdapter adapter = new SqlDataAdapter("B_Unit_Select", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet dsProduct = new DataSet();
adapter.Fill(dsProduct);
BUnit Unit = new BUnit();
if (dsProduct.Tables[0].Rows.Count > 0)
{
Unit.Code = Convert.ToInt16(dsProduct.Tables[0].Rows[0]["Code"].ToString());
Unit.Name = dsProduct.Tables[0].Rows[0]["Name"].ToString();
}
else
{
Unit.Code = -1;
}
return(Unit);
}
public static bool GetFromPoshtiban()
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
DataTable dtAllServer = SelectAllServer();
DataTable dtAllPoshtiban = SelectAllPoshtiban();
//ed.WriteMessage("Count={0}\n", dtAllServer.Rows.Count);
foreach (DataRow dr in dtAllPoshtiban.Rows)
{
if (!Convert.ToBoolean(dr["IsDeleted"]))
{
BUnit unit = Select_ByCode(Convert.ToInt16(dr["Code"].ToString()));
//ed.WriteMessage("Up1\n");
//if (bp.Code != -1)
//{
//BProduct b = Select_ByCode(Convert.ToInt32(dr["Code"].ToString()));
unit.Name = dr["Name"].ToString();
//ed.WriteMessage("Up2\n");
if (unit.Code != -1)
{
if (!unit.Update())
{
//ed.WriteMessage("Up\n");
return(false);
}
}
else
{
unit.Code = Convert.ToInt16(dr["Code"].ToString());
if (!unit.Insert())
{
//ed.WriteMessage("Insert\n");
return(false);
}
}
}
//}
}
return(true);
}
