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