/// <summary> /// 同步 /// </summary> /// <param name="condition">条件字符串</param> /// <returns></returns> public static bool KeySync(string WebID) { try { string sql = @"select KeyID, b.ECID, b.ECCode, b.ECName, c.EngunitName from KPI_WebKey a left outer join KPI_ECTag b on a.ECID = b.ECID left outer join KPI_Engunit c on b.EngunitID= c.EngunitID where WebID='{0}'"; sql = string.Format(sql, WebID); DataTable dt = DBAccess.GetRelation().ExecuteDataset(sql).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { string keyid = dt.Rows[i]["KeyID"].ToString(); KPI_WebKeyEntity keyE = KPI_WebKeyDal.GetEntity(keyid); keyE.ECCode = dt.Rows[i]["ECCode"].ToString(); keyE.ECName = dt.Rows[i]["ECName"].ToString(); keyE.KeyEngunit = dt.Rows[i]["EngunitName"].ToString(); keyE.KeyModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); KPI_WebKeyDal.Update(keyE); } } catch { return(false); } return(true); }
/// <summary> /// 修改参数 /// </summary> /// <param name="KeyID">主键</param> /// <param name="value">设定值</param> /// <returns></returns> public static bool Update(string KeyID, string ECName, string KeyIsValid, string KeyNote) { KPI_WebKeyEntity mEntity = new KPI_WebKeyEntity(); mEntity.KeyID = KeyID; //mEntity.WebName = strName; mEntity.ECName = ECName; mEntity.KeyIsValid = int.Parse(KeyIsValid); mEntity.KeyNote = KeyNote; //mEntity.WebCreateTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); mEntity.KeyModifyTime = DateTime.Now.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"); return(KPI_WebKeyDal.Update(mEntity)); }