private void checkSource(DataRow drSource, DataTable dtCase)
{
string streamName = drSource["streamname"].ToString();
string sourceType = drSource["sourcetype"].ToString();
DataTable dtDic_Source = db.getDataByTable("dictionarysource", "categoryvalue='" + sourceType + "'");
DataRow dr = dtDic_Source.Rows[0];
foreach (DataRow drCase in dtCase.Rows)
{
string caseid = drCase["case_id"].ToString();
string caseName = drCase["casename"].ToString();
string sql = "update frmcase_feed set flowstop=0 where streamname='" + streamName + "' and case_id=" + caseid;
if (dr[caseName].ToString() == "0")
{
sql = "update frmcase_feed set flowstop=1 where streamname='" + streamName + "' and case_id=" + caseid;
}
dbF.saveDataBySQL(sql);
}
}