bool ReFreshDataFromServer(string PlatForm_connectstr, string connectstr) { try { string[] IDNameColors = sqlExecute.sqlmanage.GetUniqueRecord("select Name,Description from RoleList", PlatForm_connectstr, new string[] { "Name", "Description" }).Split('|'); foreach (string IDNameColor in IDNameColors) { if (!sqlExecute.sqlmanage.ExecuteSQL("insert into RoleList(Name,Description,CreateDate) values ('" + IDNameColor.Replace(",", "','") + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "')", connectstr)) { return(false); } } return(true); } catch (Exception e) { return(false); } }
bool ReFreshDataFromServer(string PlatForm_connectstr, string connectstr) { try { if (sqlExecute.sqlmanage.ExecuteSQL("delete from ProjectState", connectstr)) { string[] IDNameColors = sqlExecute.sqlmanage.GetUniqueRecord("select StateID, StateText from ProjectState", PlatForm_connectstr, new string[] { "StateID", "StateText" }).Split('|'); foreach (string IDNameColor in IDNameColors) { if (!sqlExecute.sqlmanage.ExecuteSQL("insert into ProjectState(StateID, StateText) values('" + IDNameColor.Replace(",", "','") + "')", connectstr)) { return(false); } } return(true); } else { return(false); } } catch (Exception e) { return(false); } }