public static BRegion Select_BySecondCodeLocal(string SecondCode)
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlDataAdapter adapter = new SqlDataAdapter("B_Region_SelectBySecondCode", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iSecondCode", SecondCode));
DataSet dsProduct = new DataSet();
adapter.Fill(dsProduct);
BRegion Region = new BRegion();
if (dsProduct.Tables[0].Rows.Count > 0)
{
Region.Code = Convert.ToInt16(dsProduct.Tables[0].Rows[0]["Code"].ToString());
Region.Name = dsProduct.Tables[0].Rows[0]["Name"].ToString();
Region.SecondCode = dsProduct.Tables[0].Rows[0]["SecondCode"].ToString();
ed.WriteMessage("Code:{0} Name:{1} SecondCode:{2} \n", Region.Code, Region.Name, Region.SecondCode);
}
else
{
Region.Code = -1;
}
return(Region);
}
//HATAMI انتقال اطلاعات از سرور به پایگاه داده محلی
public static bool GetFromServer()
{
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
DataTable dtAllServer = SelectAllServer();
DataTable dtAllLocal = SelectAllLocal();
//ed.WriteMessage("Count={0}\n", dtAllServer.Rows.Count);
foreach (DataRow dr in dtAllServer.Rows)
{
BRegion region = Select_BySecondCodeLocal(dr["SecondCode"].ToString());
//ed.WriteMessage("Up1\n");
//if (bp.Code != -1)
//{
//BProduct b = Select_ByCode(Convert.ToInt32(dr["Code"].ToString()));
region.Name = dr["Name"].ToString();
//ed.WriteMessage("Up2\n");
if (region.Code != -1)
{
if (!region.UpdateLocal())
{
//ed.WriteMessage("Up\n");
return(false);
}
}
else
{
region.SecondCode = dr["SecondCode"].ToString();
if (!region.InsertLocal())
{
//ed.WriteMessage("Insert\n");
return(false);
}
}
//}
}
return(true);
}
