public static bool Update(uaccountEntity item) { DataTable dt = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, item.uid)).Tables[0]; if (dt.Rows.Count == 1) { dt.Rows[0]["accountmony"] = item.accountmony; dt.Rows[0]["stopmoney"] = item.stopmoney; return(DBAccess.DataAccess.Miou_UpdateDataSet("", tableName, "*", "1<>1", "", dt).StartsWith("000")); } else { return(true); } }
/// <summary> /// /// </summary> /// <param name="where"></param> /// <returns></returns> public static uaccountEntity GetByKeyId(int id, ref string info) { try { uaccountEntity entity = new uaccountEntity(); DataTable dt = DBAccess.DataAccess.Miou_GetDataSetBySql(DBAccess.LogUName, string.Format("select * from {0} where {1} = {2} ;", tableName, keyName, id)).Tables[0]; var list = DBAccess.GetEntityList <uaccountEntity>(dt); if (list != null && list.Count > 0) { entity = list[0]; } return(entity); } catch (Exception ex) { info = ex.Message; return(new uaccountEntity()); } }