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